UOW Detailed Analysis Report


The UOW Detailed Analysis Report provides detailed information about each UOW.

You can use the report to better perform the following analysis tasks:

  • Identify which UOWs require reorganization
  • Manage space usage when the randomizer has been modified to group related data into contiguous UOWs

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

1Date: 02/22/2016                                 FAST PATH ANALYZER/EP                                      (4.00.00.01)
 Time: 09:02AM                                 UOW Detailed Analysis Report                                     Page    2
0DBD Name: PFPDEMO   Area Name:   PFPDEMO1  Area DSname: PFP.DB.PFPDEMO1
                     Area number: 1                  UOW Range: All
-       UOW    ---Number CIs Used---   No. RAPs  --% RAP FS---   % DOVF   No. DB    ---Record Length Statistics---
        No.      RAP    DOVF    IOVF   Use Ovfl  Avg  Max  Min  Part FS  Records         Avg        Max        Min

          0       18       5       6       12     12   77    0      1         69       3,133      8,948        398
          1       16       3       0        5     31   82    0     50         40       2,758      8,608        336
          2       18       5       4       10     26   86    0      3         63       2,831      8,089        447
          3       16       5       1        9     20   72    0      2         56       2,634      6,126        784
          4       17       5       5       14     10   49    0      1         66       3,098     10,053        414
          5       18       5       2       10     19   71    0      2         55       3,168      8,234        448
0     Total      103      28      18       60                                349
    Average       17       5       3       10     20               11         58       2,954
    Minimum       16       3       0        5                                 40
    Maximum       18       5       6       14                                 69
0          UOWs using 100% of DOVF = 5 (83.3%)

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 that the entire area is being reported; a range value (start to stop) indicates the range of UOWs being reported.

UOW No.

The UOW number.

Number CIs Used

Number of control intervals used per UOW

  • RAP – The number of RAP blocks in the UOW that contain data.
  • DOVF – The number of DOVF blocks in the UOW that contain data.
  • IOVF – The number of IOVF blocks that are allocated to the UOW.

No. RAPs Use Ovfl

The number of RAP blocks containing a pointer that references a DOVF block or an IOVF block.

% RAP FS

Statistics about the percentage of free space (FS) in used RAP blocks. Empty RAP blocks are excluded from the calculations.

  • Avg –The average percentage of free space in used RAP blocks.
  • Max – The maximum percentage of free space in used RAP blocks.
  • Min – The minimum percentage of free space in used RAP blocks.

% DOVF Part FS

The percentage of free space in the DOVF blocks in the UOW. DOVF free space for a UOW includes free space in used and unused DOVF blocks.

No. DB Records

The number of database records in the UOW.

Record Length Statistics

Statistics about the record lengths in the UOW. The record length includes bytes in the segment prefix and user data.

  • Avg – The average bytes that are used per record.
  • Max – The maximum record length. This value is not reported when POINTER_VALIDATION=QUICK has been specified.
  • Min – The minimum record length. This value is not reported when POINTER_VALIDATION=QUICK has been specified.

UOW Range Total

The total number of records and the average record length for the range of UOWs that are being reported.


 

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

Fast Path/EP products reference information 4.1