FABADA5 UOWRPT DD data set

The UOWRPT data set contains the report for UOW analysis produced by the FABADA5 program.

Note: DATE and TIME in the report header are the date and time of the image copy data set that is used as the input to the analysis process. If the input data set is a VSAM ESDS, the date and time show the time the FABADA1 program was run. They are printed as mm/dd/yyyy and hh.mm.ss.

Format

This data set contains 133-byte fixed-length records, and block size (if coded in your JCL statement) must be a multiple of 133. You should code your DD statement as follows:

//UOWRPT DD SYSOUT=A

UOW report

This optional report provides automated threshold reporting, which causes warning messages to be generated when conditions within the database do not meet user-specified criteria. This feature can be used to show when reorganization or expansion is required, or if database performance falls below acceptable standards.

Purpose

The optional report for UOW analysis provides detailed information on each UOW.

Report content

The following figure shows an example of the UOW report.

Figure 1. UOW report

 
IMS HPFP UTILITIES - DEDBPC                                          "UOW REPORT"                                        PAGE:     1
5698-FPP                                                   DATE: 11/22/2020  TIME: 20.13.18                         FABADA5  -  V2R1


 
DBDNAME: VRSDSRF    AREA NAME :VRSTSS3 
                    AREA NUMBER:   3 

 
             ---NUMBER CI'S USED---  #RAPS USE  ---%RAP FS---   % DOVF    #DB     ------RECORD LENGTH STATS------
   UOW NO.    #RAPS   #DOVF   #IOVF  OVFL CI'S  AVG  MAX  MIN  PART FS  RECORDS     AVERAGE    MAXIMUM    MINIMUM 
 
         0        2       1       0        2     12   20    4     52          2       5,534      5,930      5,138
         1        1       1       0        1      8    8    8     79          1       5,440      5,440      5,440
         2        1       1       0        1      4    4    4     84          1       5,138      5,138      5,138
         3        2       2       0        2     19   22   15     30          3       4,080      4,540      3,704
         4        1       2       2        1      4    4    4      1          3       6,367      6,992      5,716
         5        4       2       3        4      9   14    3      1          7       4,503      6,892      2,266
         6        2       2       0        2      8    9    7     45          3       3,964      4,108      3,788
         7        3       1       0        1     17   34    5     59          3       4,442      6,810      2,678
         8        3       2       1        2     16   25   11      9          5       4,165      5,400      2,466
         9        3       1       0        2     12   34    0     65          3       4,492      6,710      2,678
        10        1       2       1        1     16   16   16      1          3       5,152      5,952      4,540
        11        1       1       0        1      8    8    8     96          1       3,998      3,998      3,998
        12        4       2       2        4      9   26    2      4          5       5,707      8,880      3,904
        13        3       2       1        2     21   39    8      6          4       4,536      5,590      2,466
        14        1       2       0        1      9    9    9     47          2       3,968      3,998      3,938
        15        4       2       0        4      7    9    3     31          5       4,140      5,771      2,566
        16        3       2       2        3     18   25    8      2          5       4,522      6,111      3,820
        17        0       0       0        0                     100          0
        18        2       2       5        2      6   10    1      9          5       6,528     10,882      4,540
        19        4       2       2        4     13   33    4     13          6       4,489      6,226      2,566
        20        1       0       0        0     11   11   11    100          1       3,604      3,604      3,604
        21        1       1       0        1      8    8    8     51          1       7,690      7,690      7,690
        22        2       2       4        2     22   39    6      8          5       5,501      7,690      3,984
        23        3       2       3        3     11   20    5      7          5       5,386      7,806      3,938
        24        3       2       3        3     15   22    8      2          4       6,943      9,533      5,138

The following are the descriptions for this report:

UOW NO.: The number of the unit of work.
#RAPS: The number of RAPs in the UOW that contain data (that is, the remaining RAPs are "dead RAPs").
#DOVF: The number of DOVF CIs that contain data in this UOW.
#IOVF: The number of IOVF CIs that are allocated to the UOW.
#RAPS USE OVFL CI'S: The number of RAP CIs that contain a pointer that references either DOVF or IOVF.
%RAP FS: Provides statistics on the average, maximum, and minimum percentage free space in used RAP CIs. Empty RAP CIs are excluded form the calculations.
% DOVF PART FS: The percentage free space in the DOVF part of the UOW. DOVF part free space for a UOW includes all FSEs in used DOVF CIs plus all empty DOVF CIs.
#DB RECORDS: The number of database records in the UOW.
RECORD LENGTH STATS: Provides statistics on the average, maximum, and minimum record lengths. The record length includes both prefix and data lengths

Usage

The UOW report can be used to:

List detailed information about each UOW
Identify which UOWs require reorganization
Manage space utilization when the randomizer has been modified to group related data into contiguous UOWs
List only those UOWs that violate the user-specified space utilization criteria.

Since no single report provides all the required information, usage of the reports is discussed in the topic "DEDB monitoring and tuning guide" in the IMS Fast Path Solution Pack: IMS High Performance Fast Path Utilities User's Guide.