Previous Topic: DBUTLTY Function REPORT with MEMORY=MVSNext Topic: RAAT Long Keys


DBUTLTY REPORT Function with TYPE=DATASP

The first line is not changed:

AREA A01 BLKSIZE 4,096 TRACKS 31 BLOCKS 372 URI YES DSOP 1 RANDOM SLACK 0

The second section with table information is not there in that form, described when it occurs after the main space usage information.

The third section with usage headings have changed, just the right hand side. An example before the change is:

---------- FREESPACE IN BLOCKS ----------- 0 TO 1/4K 1/2K 1K 2K 3K 4K 8K 12K 16K 20K 24K 32K

An example after the change is:

---------- FREESPACE IN BLOCKS ----------- 0-128 256 512 768 1,024 1,280 1,536 2,048 2,560 3,072 3,584 4,094

What is different about the headings are the numbers picked on the right side. Before this feature the numbers were always the same and varied from a low number to 32k regardless of the block size for the area. With the change the numbers vary with block size. The example above is a block size of up to 4k (4096). The first entry has a 0- to show that it is a count of blocks with zero (0) bytes of free space through 128 bytes of free space. The next entry is the first number plus 1 through the number printed. The last number will always be the block size less 2 bytes.

Following the TOTALS section will be a new section. The forms shown here show data areas that are using Data Space Options 1-5, and the area has been opened for update.

DSOP 1-5 TOTALS EMPTY LARGE SMALL LESS THAN NEVER USED 4,094 96 72 BLOCKS TO EMPTY BLOCKS TO LARGE BLOCKS SMALL BLOCKS BLOCKS 31 0 0 0 341

This section provides information about ‘available’ blocks as handled by the DSOP processing for options 1-5. The first and third heading line notes the count of EMPTY BLOCKS, LARGE TO EMPTY BLOCKS, SMALL TO LARGE BLOCKS, LESS THAN SMALL BLOCKS, and NEVER USED BLOCKS. The second heading line provides the definition of an empty block, large block, and small block. Datacom picks the values for the small value to track as available and the large value to track as available with no user input or controls. They are based upon the tables in the area. The details of the DSOP 1-5 available blocks is internal and not published. A block that has been used for data records but has no current data records is considered empty and has a space of the block size less 2. A block that has less available space but does have room for what is considered a large record is counted. A block with less space but does have room for what is considered a small record is counted. Blocks that have even less space are counted. The final count is for blocks that have never had a data row (since the last INIT of the data area).

The next (last) section provides information about tables of the area. It starts as existed in prior releases but now has columns as provided here:

PHYSICAL PHYSICAL PHYSICAL PHYSICAL CXX SMALL LARGE AVERAGE TBL CMP USER COMPRESSION CXX RECORDS SCAN RECORDS ROW SIZE ROW SIZE ROW SIZE ROW SIZE

A sample line is:

AGR YES 466 466 821 136 365 276

On the line is the table name AGR, that is has DB compression, no user compression. The CXX stored record count is 466, the scan of the data area found 466 records, the physical row size (user data plus Datacom Record Control Element) is 821, the physical small row size is 136 (smallest compressed stored row found in scan), the physical largest row size is 365 (largest compressed stored row found in scan), and the average physical row size is 276. Note that the largest physical row size may be larger than the row as not compressed.