Sample Report: DATASP with BLOCKS= Specified

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

Sample Report: DATASP with 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,BLOCKS=10 FUNCTION=REPORT AREA=PAY BLOCKS=000010 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 PAY BLKSIZE 1,024 TRACKS 2 BLOCKS 66 URI YES DSOP 0 NO RECLAMATION TBL CMP USER COMPRESSION RECLN RECORDS PAY 52 200 GROUP# BLOCKS KBYTES ROWS FREESP ROWS ROWLEN ---------- FREESPACE IN BLOCKS ----------- IN-USE % IN-USE % IN-USE MAX MAX MAX 0 TO 1/4K 1/2K 1K 2K EMPTY % EMPTY % DELETED MIN MIN MIN 3K 4K 8K 12K *AVAIL AVG AVG AVG 16K 20K 24K 32K 1 10 100 10 97 190 34 19 52 10 0 0 0 0 0 0 3 0 34 19 52 0 0 0 0 0 34 19 52 0 0 0 0 2 1 10 1 5 10 1,022 10 52 0 1 9 0 9 90 9 95 0 502 0 52 0 0 0 0 180 970 1 52 0 0 0 0 3 0 0 0 0 0 1,022 0 0 0 0 10 0 10 100 10 100 0 1,022 0 0 0 0 0 0 190 1,022 0 0 0 0 0 0 . . . . . . 6 0 0 0 0 0 1,022 0 0 0 0 10 0 10 100 10 100 0 1,022 0 0 0 0 0 0 190 1,022 0 0 0 0 0 0 7 0 0 0 0 0 1,022 0 0 0 0 4 0 4 100 4 100 0 1,022 0 0 0 0 0 0 76 1,022 0 0 0 0 0 0 TOTALS 13 17 10 16 200 1,022 19 52 10 1 53 0 53 83 54 84 0 34 0 52 0 0 0 0 1,016 860 3 52 0 0 0 0

This page of the report shows the following information describing the selected data area followed by information describing the table or tables in the area. One line is created for each table in the area.

Note: The columns under the following headings are filled in for each reference group as specified with the REFGROUP parameter on the DBUTLTY OLREORG function.

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), the smallest number of rows found in a data block (MIN), and the 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.

Note: Additional groups of blocks are listed with their information.

TOTALS: Displays a summary of all group information.