Sample Report: DATASP without BLOCKS= Specified

REPORT (Generate Reports) › TYPE=DATASP - Data Area Space Report › Sample Report: DATASP without BLOCKS= Specified

Sample Report: DATASP without BLOCKS= Specified

Following are sample report pages. For an example report header, see Sample Report Headers.

CONTROL CARD(S) .........1.........2.........3.........4.........5.........6.........7.........8 REPORT TYPE=DATASP,DBID=1,AREA=PAY FUNCTION=REPORT AREA=PAY DBID=00001 TYPE=DATASP

This page of the report shows the following:

The command exactly as entered.
An analysis of keywords encountered and expected. Any errors found are flagged with a note in the left margin.
Any messages related to syntax processing.

AREA DD1 BLKSIZE 4,096 TRACKS 225 BLOCKS 2,700 URI YES DSOP 1 RANDOM SLACK 0 GROUP# BLOCKS KBYTES ROWS FREESP ROWS ROWLEN ---------- FREESPACE IN BLOCKS ----------- IN-USE % IN-USE % IN-USE MAX MAX MAX 0-128 256 512 768 EMPTY % EMPTY % DELETED MIN MIN MIN 1,024 1,280 1,536 2,048 *AVAIL AVG AVG AVG 2,560 3,072 3,584 4,094 TOTALS 1,193 78 4,597 75 20,650 4,094 54 2,503 691 432 44 10 344 22 1,543 25 128 0 0 58 4 2 2 0 6,017 1,030 13 227 2 0 1 1,512

This page of the report shows the following:

AREA: Displays the area DATACOM-NAME, PAY.
BLKSIZE: Displays the blocksize in the area, 4096.
TRACKS: Displays the number of tracks used, 25.
BLOCKS: Displays the number of blocks, 2700.
URI: Displays whether URI is assigned, YES.
DSOP: Identifies that the data space option is 1 RANDOM.
SLACK: This is the total number of SLACK bytes in the area. 5 digits

The next lines are created for each table in the area.

Note: Table entries in the middle of the alphabet have been omitted.

BLOCKS IN-USE % EMPTY %

Displays the number of blocks in use followed by the percentage in use over the number of blocks empty followed by the percentage of blocks empty.

KBYTES IN-USE % EMPTY %

Displays the number of kilobytes in use followed by the percentage in use over the number of kilobytes empty followed by the percentage of kilobytes empty.

ROWS IN-USE DELETED *AVAIL

Displays the number of rows in use, rows that are currently marked logically deleted, and number of rows could be added. Available rows are a best estimate based on average row size, space available in data blocks, and so on.

FREESP MAX MIN AVG

Displays the size of the largest segment of free-space bytes (MAX), the smallest segment of free-space bytes (MIN), and the average segment size of free-space bytes (AVG).

ROWS MAX MIN AVG

Displays the largest number of rows found in any data block (MAX), smallest number of rows found in a data block (MIN), and average number of rows per data block (AVG).

ROWLEN MAX MIN AVG

Displays the largest row length found in any data block (MAX), smallest row length found in a data block (MIN), and average row length per data block (AVG).

FREESPACE IN BLOCKS

Displays a map of free-space segments in each size grouping.

The numbers vary with block size. The example shows a block size of up to 4k (4096). The first entry starts with a zero (0) to show that it is a count of blocks with zero bytes of free space through 128 bytes of free space. The next entry is the first number plus 1 to through the number printed. The last number is always the block size less 2 bytes (4,094).

TOTALS

Displays a summary of all group information.

DSOP 1-5 TOTALS EMPTY LARGE SMALL LESS THAN NEVER USED 4,094 4,060 285 BLOCKS TO EMPTY BLOCKS TO LARGE BLOCKS SMALL BLOCKS BLOCKS 2 0 42 1,149 1,507

This section provides information about ‘available’ blocks as handled by the Data Area Space Management Options (DSOP) processing for DSOP options 1 through 5.

EMPTY 4094 BLOCKS 31.: Provides the size of an empty block less the block overhead that, in this example, is 4094. There are 31 blocks that have been used but are now empty.
LARGE 4060 TO EMPTY BLOCKS 0.: Provides the size that CA Datacom has selected as a "large" record (4060 in this example, where calculation is interal to CA Datacom--not published, but used in space management decisions). The count, in this case 0, refers to the blocks that have 4060 bytes or 4061, and so on, up to the number set as an empty block (4094, in this example).
SMALL 285 TO LARGE BLOCKS 42.: Provides the size CA Datacom has selected as a "small" record (285 in this example, where calculation is internal to CA Datacom--not published, but used in space management decisions). The count, in this case 42, refers to the blocks that have 285 bytes up to the large size of 4060 bytes.
LESS THAN SMALL BLOCKS 1,149.: Provides the number of blocks that have less space than the calculated small size (285 in this example).
NEVER USED BLOCKS 1,507.: Provides the number of blocks that have never had rows since the last INIT function execution or, possibly, since the last LOAD function execution.

The next (last) section provides information about tables of the area.

TBL CMP USER COMPRESSION CXX RECORDS AGR YES 339 ALS YES 1,924 ARA YES 55 ATZ YES 9 BAS YES 25 DOC YES 0 DVW YES 37 ELM YES 639 FCN YES 0 FIL YES 89 FLD YES 13,177 HSD YES 207 JOB YES 0 KEY YES 764 KWC YES 30 LIB YES 0 MEM YES 0 MOD YES 0 NOD YES 0 PCV YES 0 PER YES 2 PGM YES 0 PLN YES 1 PNL YES 0 PRC YES 0 PRT YES 0 REL YES 3,232 RPT YES 0 STM YES 0 STP YES 0 SYS YES 12 TRG YES 0 TXT YES 105 PHYSICAL PHYSICAL PHYSICAL PHYSICAL CXX SMALL LARGE AVERAGE SCAN RECORDS ROW SIZE ROW SIZE ROW SIZE ROW SIZE 339 821 159 449 273 1,926 388 58 216 143 55 562 121 245 188 9 379 108 142 127 26 512 92 244 196 0 384 37 541 164 202 186 639 492 140 284 189 0 616 89 534 139 207 176 13,177 900 136 367 250 207 4,060 183 2,503 676 0 414 764 856 190 415 267 30 612 112 155 133 0 415 0 468 0 458 0 396 0 734 2 494 129 132 131 0 765 1 704 158 158 158 0 547 0 598 0 1,784 3,232 666 83 216 154 0 549 0 626 0 404 12 458 109 146 115 0 657 105 1,212 121 676 260

TBL: Displays the table DATACOM-NAME.
CMP: Displays whether this is a compressed table.
USER COMPRESSION: Contains the user exit name when this table has a user compression routine specified, or it contains blanks when CA Datacom/DB standard compression is used.
RECLN: Displays record length, including the RCE bytes.
CXX RECORDS: Displays the number of records as known to the CXX.
SCAN RECORDS: Displays the numer of records found during the scan.
PHYSICAL CXX ROW SIZE: Identifies the row size with the overhead stored in the data block.
PHYSICAL SMALL ROW SIZE: Identifies the smallest row size found in the data area.
PHYSICAL LARGE ROW SIZE: Identifies the largest row size found in the data area.

Note: The largest physical row size could be larger than the row as not compressed.