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 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 
                                                                                                                    
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:

AREA

Displays the area DATACOM-NAME, PAY.

BLKSIZE

Displays the blocksize in the area, 1,024.

TRACKS

Displays the number of tracks used, 2.

BLOCKS

Displays the number of blocks, 66.

URI

Displays whether URI is assigned, YES.

DSOP

Identifies that the data space option is 0 with no reclamation.

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

TBL

Displays the table DATACOM-NAME, PAY.

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 blanks when CA Datacom/DB standard compression is used.

RECLN

Displays record length including the RCE bytes, 52.

RECORDS

Displays the number of records, 200.

DSOP

Identifies that the data space option is 0 with no reclamation.

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.