Free Space Analysis Report


The Free Space Analysis Report provides the following information:

  • Summary and detailed information about the total and usable amount of free space in each section of the database (RAA base, DOVF, and IOVF)
  • Statistics about the number and size of the free space elements in each section of the database
  • Overflow usage analysis (DOVF and IOVF)

For an additional example of the report, refer to the PFPANLYZ member in the REPORTS data set.

The Free Space Analysis Report provides valuable information that can be used to determine the following items:

  • When to reorganize or expand an area
  • Optimal values for UOW and ROOT parameters
  • DOVF and IOVF usage

Free space calculations have the following characteristics:

  • The entire area is included in the report. When an optional UOW range report is requested, the report also contains a summary of the free space within the selected UOWs.
  • The total usable space in a CI is the block size minus 21 (the overhead bytes).
  • The length of the free space element (FSE) is included in usable free space only if it is large enough to hold the smallest maximum segment that is defined in the area.
  • Scraps (free space less than 4 bytes in length) are included in free space calculations, but they are not included in FSE calculations.

Free Space Analysis Report

1Date: 02/22/2016                                 FAST PATH ANALYZER/EP                                      (4.00.00.01)
 Time: 09:02AM                                  Free Space Analysis Report                                      Page   12
0DBD Name: PFPDEMO   Area Name:   PFPDEMO1  Area DSname: PFP.DB.PFPDEMO1
                     Area number: 1                  UOW Range: All
0
 Area Overview                                            RAP    DOVF    IOVF    SDEP
0                                         Total % FS:     27%     10%     83%     96%
                                          Usable % FS:    27%      9%     83%     94%
                                          Unused:         10%      7%     81%     94%
                                          In Area:         5%      1%     32%
                                          FS for Root:    43%
0Analysis of RAP Blocks
                ---CIs---   -----No. of FSEs------  -------Size of FSEs--------    Using
     FS %        No.    %    Avg  SDev   Max   Min     Avg   SDev    Max    Min   Ovflow

     100          11   10
    90-99          0    0
    80-89          3    3    1.0   0.0     1     1   6,884    168   7048   6712        0
    70-79          4    4    1.0   0.0     1     1   5,967    230   6306   5799        0
    60-69          6    5    1.0   0.0     1     1   5,268    268   5715   5052        0
    50-59          7    6    1.0   0.0     1     1   4,488    263   4751   4120        0
    40-49          6    5    1.0   0.0     1     1   3,717    275   3993   3432        0
    30-39          3    3    1.0   0.0     1     1   2,748    291   3070   2505        0
    20-29          3    3    1.0   0.0     1     1   2,122    199   2349   1980        0
    10-19          6    5    1.0   0.0     1     1   1,220    194   1563    986        0
     0-9          65   57    1.0   0.1     1     0     200    169    769      8       60
0       RAP CI Usage Summary       Total:       114     Used:       103   (90%)
             CIs Using Overflow:      No:        60    % CIs:    58%
-Analysis of Overflow Blocks
  % DOVF   --UOWs---  ---DOVF CIs Used--- ----No. of FSEs----  ------Size of FSEs------    In  --IOVF CIs Used---  FSEs/
  Part FS    No.   %   Avg SDev  Max  Min  Avg SDev  Max  Min     Avg  SDev   Max   Min  IOVF  Avg SDev  Max  Min IOVF CI

    100        0
   90-99       0
   80-89       0
   70-79       0
   60-69       0
   50-59       1  17   3.0  0.0    3    3  1.0  0.0    1    1   4,116 4,050  8171    43     0
   40-49       0
   30-39       0
   20-29       0
   10-19       0
    0-9        5  83   5.0  0.0    5    5  1.0  0.2    1    0     170   135   464    15     5  3.6  2.1    6    1    1.0
0       DOVF CI Usage Summary      Total:        30     Used:        28   (93%)
             UOWs Using DOVF:        No.:         6   % UOWs:   100%
             No. DOVF CIs Used:      Avg:      4.67     SDev:   0.82   Max:     5   Min:     3
0       IOVF CI Usage Summary      Total:        95     Used:        18   (19%)
             UOWs Using IOVF:        No.:         5   % UOWs:    83%
             No. IOVF CIs Used:      Avg:      3.60     SDev:   2.07   Max:     6   Min:     1
             Available IOVF CIs:     No.:        77    % CIs:    81%

The following table lists the fields that are displayed in this report:

Field

Description

DBD Name

The DBD name of the database.

Area Name

The ddname of the area.

Area number

The area number.

UOW Range

The range of UOWs that are included in the report. The value All indicates the entire area is being reported; a range value (start to stop) indicates the range of UOWs being reported.

This section contains the following topics:


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

Fast Path/EP products reference information 4.1