Administrative and Operational Enhancements › Utility Enhancements › PRINT SPACE Page Reserve Reporting

PRINT SPACE Page Reserve Reporting

For Version 18.0, the PRINT SPACE utility was enhanced to report on the amount of available space reserved for the expansion of variable-length records. This information is useful when you are planning for database expansions and reorganizations.

The following report shows the output from the enhanced PRINT SPACE utility:

PRINT SPACE FOR AREA SYSSQL.DDLCATX FULL;
                                       AVAILABLE Space Distribution Report
                                                 AVAIL         NUMBER
                                                 SPACE        OF PAGES
AREA       SYSSQL.DDLCATX
 PAGE SIZE          4,276
 PAGE RESERVE         212
    PAGES          10,001 THRU         13,000
                                                91-100%             56
                                                81-90 %            117
                                                71-80 %            125
                                                61-70 %            197
                                                51-60 %            197
                                                41-50 %            229
                                                31-40 %            230
                                                21-30 %            225
                                                11-20 %            203
                                                00-10 %          1,419
                                                SMPS                 2
                                                TOTAL            3,000
    FILE   SYSSQL.DDLCATX
    BLOCKS              1 THRU          3,000
Total Space Allocated                               12,828,000
Total Space Available            (Percent)           3,240,368     (25.26%)
Total Reserved Space Available   (Percent)             511,128     ( 3.98%)
Total Unreserved Space Available (Percent)           2,729,240     (21.28%)
Total Space Used                                     9,587,632
Logically Full Pages                                         0             
Total Space Unusable     (Percent)                           0    (  0.00%)
AREA       SYSSQL.DDLCATX              Distribution of USED Space Report   
             Maximum                                          Percent of   
Record Type  Length       Occurrences   Total Space Used      Total Used   
Null Line         8             54                 432             0.00    
  SR5            48              1                  48             0.00    
  SR7            40             12                 480             0.00    
  SR8         1,404         28,567           9,482,184            99.93    
Space Inv.    4,244              2               8,488             0.08    
Overhead         32          3,000              96,000             0.98    
        *** NO logically deleted records found ***                         

The PRINT SPACE utility output contains the following new fields:

PAGE RESERVE

The number of bytes initially reserved on each page for the expansion of variable length records.

Total Reserved Space Available

The total amount of space reserved for the expansion of variable length-records.

Total Unreserved Space Available

The total amount of available space that is not reserved for the expansion of variable length records.