Sensor Data Statistics report from the FP DB Sensor Printing utility

The Sensor Data Statistics report contains the value of sensor data. This report is printed in the HFPSPRT data set.

This report contains the data element names and their values. For the definitions of these data elements, see the topics about data elements in the IMS Tools Base Policy Services User’s Guide.

The number of data elements in the report differs based on the sensor data that is stored in the Sensor Data repository and the UOW_REPORT keyword specification in the JCL.

The following figures show an example of the Sensor Data Statistics report when UOW-related sensor data is not stored in the Sensor Data repository, or when UOW_REPORT=NO is specified.

Figure 1. Sensor Data Statistics report when UOW-related sensor data is not stored or UOW_REPORT=NO (FP DB Sensor Printing utility) (Part 1 of 2)

IMS HPFP UTILITIES - DB SENSOR                     "PRINTING UTILITY - SENSOR DATA STATISTICS REPORT"                    PAGE:     1
5698-FPP                                                   DATE: 10/30/2022  TIME: 17.10.43                         HFPSPRNT - V2.R1

DBD NAME: DEDBJN21, AREA NAME: DB21AR0                                                              Collected on 10/29/2022 17.05.05
------------------------------------------------------------------------------------------------------------------------------------

==============================================
   AREA DEFINITION
==============================================

Data Element Name                        Value
------------------------  --------------------
DB_AREADEF_CISIZE                        1,024
DB_AREADEF_UOW1                             15
DB_AREADEF_UOW2                             10
DB_AREADEF_ROOT1                            10
DB_AREADEF_ROOT2                             5
DB_AREADEF_NUM_SDEP_CIS                     64


==============================================
   FREE SPACE PERCENTAGE STATISTICS
==============================================

Data Element Name                        Value
------------------------  --------------------
DB_PCT_BYTES_FS_RAA                        96%
DB_PCT_BYTES_FS_DOVF                       81%
DB_PCT_BYTES_FS_IOVF                       96%
DB_PCT_BYTES_FS_SDEP                       52%


==============================================
   OVERFLOW USAGE STATISTICS
==============================================

Data Element Name                        Value
------------------------  --------------------
DB_PCT_NUM_UOW_USE_DOVF                    20%
DB_AVG_NUM_DOVFCI_BY_UOW                 10.00
DB_MAX_NUM_DOVFCI_BY_UOW                    10
DB_PCT_NUM_UOW_USE_IOVF                    20%
DB_NUM_UOW_USE_IOVF                          1
DB_AVG_NUM_IOVFCI_BY_UOW                  3.00
DB_MAX_NUM_IOVFCI_BY_UOW                     3
DB_MIN_NUM_IOVFCI_BY_UOW                     3
DB_PCT_NUM_IOVFCI_USED                      5%
DB_PCT_NUM_RAPCI_OVFL                     100%


==============================================
   SEGMENT OCCURRENCE STATISTICS
==============================================

Data Element Name                        Value
------------------------  --------------------
DB_NUM_SEG                                 130

Figure 2. Sensor Data Statistics report when UOW-related sensor data is not stored or UOW_REPORT=NO (FP DB Sensor Printing utility) (Part 2 of 2)

IMS HPFP UTILITIES - DB SENSOR                     "PRINTING UTILITY - SENSOR DATA STATISTICS REPORT"                    PAGE:     2
5698-FPP                                                   DATE: 10/30/2022  TIME: 17.10.43                         HFPSPRNT - V2.R1

DBD NAME: DEDBJN21, AREA NAME: DB21AR0                                                              Collected on 10/29/2022 17.05.05
------------------------------------------------------------------------------------------------------------------------------------

==============================================
   DATABASE RECORD STATISTICS
==============================================

Data Element Name                        Value
------------------------  --------------------
DB_NUM_ROOT                                120
DB_AVG_DBREC_LENGTH                     106.00
DB_MAX_DBREC_LENGTH                        582
DB_MIN_DBREC_LENGTH                        102
DB_PCT_NUM_DBREC_IOVF                      18%


==============================================
   RANDOMIZING STATISTICS
==============================================

Data Element Name                        Value
------------------------  --------------------
DB_AVG_LEN_SYNONYM_CHAIN                120.00
DB_MAX_LEN_SYNONYM_CHAIN                   120


==============================================
   PHYSICAL I/O STATISTICS
==============================================

Data Element Name                        Value
------------------------  --------------------
DB_ESTIMATED_DBREC_IO                    26.00
DB_ESTIMATED_ROOT_IO                     26.00
DB_AVG_DBREC_IO                           7.06
DB_MAX_DBREC_IO                             13
DB_AVG_ROOT_IO                            7.06
DB_MAX_ROOT_IO                              13


==============================================
   UOW STATISTICS INFORMATION
==============================================

Data Element Name                        Value
------------------------  --------------------
DB_FLAG_UOW_DATA                             N
DB_FLAG_UOW_GROUP_DATA                       N
DB_NUM_UOW_GROUPS                          n/a
DB_THRESHOLD_RBASEFS                       30%
DB_THRESHOLD_RDOVFFS                       50%
DB_NUM_UOW_RFS_COND                         50 
DB_PCT_NUM_UOW_RFS_COND                    10%


==============================================
   REPOSITORY GROUP INFORMATION
==============================================

Data Element Name                        Value
------------------------  --------------------
DB_SENSOR_DATA_GROUP_ID                    n/a

The following figures show another example of the Sensor Data Statistics report. In this report, logical pages 3 and 4 contain data element values for the first UOW in the area that is specified by the IAREA keyword. This report is printed if all of the following conditions are met:

UOW_REPORT=YES is specified
UOW-related sensor data exists in the Sensor Data repository
HFPAUOWC DD statement was not specified in the job that collected and stored the sensor data

In actual reports, data element values for other UOWs are printed in the subsequent pages.

Figure 3. Sensor Data Statistics report when UOW_REPORT=YES and sensor data for all UOWs is stored (FP DB Sensor Printing utility) (Part 1 of 4)

IMS HPFP UTILITIES - DB SENSOR                     "PRINTING UTILITY - SENSOR DATA STATISTICS REPORT"                    PAGE:     1
5698-FPP                                                   DATE: 10/30/2022  TIME: 17.10.43                         HFPSPRNT - V2.R1

DBD NAME: DEDBJN21, AREA NAME: DB21AR0                                                              Collected on 10/29/2022 17.05.05
------------------------------------------------------------------------------------------------------------------------------------

==============================================
   AREA DEFINITION
==============================================

Data Element Name                        Value
------------------------  --------------------
DB_AREADEF_CISIZE                        1,024
DB_AREADEF_UOW1                             15
DB_AREADEF_UOW2                             10
DB_AREADEF_ROOT1                            10
DB_AREADEF_ROOT2                             5
DB_AREADEF_NUM_SDEP_CIS                     64


==============================================
   FREE SPACE PERCENTAGE STATISTICS
==============================================

Data Element Name                        Value
------------------------  --------------------
DB_PCT_BYTES_FS_RAA                        96%
DB_PCT_BYTES_FS_DOVF                       81%
DB_PCT_BYTES_FS_IOVF                       96%
DB_PCT_BYTES_FS_SDEP                       52%


==============================================
   OVERFLOW USAGE STATISTICS
==============================================

Data Element Name                        Value
------------------------  --------------------
DB_PCT_NUM_UOW_USE_DOVF                    20%
DB_AVG_NUM_DOVFCI_BY_UOW                 10.00
DB_MAX_NUM_DOVFCI_BY_UOW                    10
DB_PCT_NUM_UOW_USE_IOVF                    20%
DB_NUM_UOW_USE_IOVF                          1
DB_AVG_NUM_IOVFCI_BY_UOW                  3.00
DB_MAX_NUM_IOVFCI_BY_UOW                     3
DB_MIN_NUM_IOVFCI_BY_UOW                     3
DB_PCT_NUM_IOVFCI_USED                      5%
DB_PCT_NUM_RAPCI_OVFL                     100%


==============================================
   SEGMENT OCCURRENCE STATISTICS
==============================================

Data Element Name                        Value
------------------------  --------------------
DB_NUM_SEG                                 130

Figure 4. Sensor Data Statistics report when UOW_REPORT=YES and sensor data for all UOWs is stored (FP DB Sensor Printing utility) (Part 2 of 4)

IMS HPFP UTILITIES - DB SENSOR                     "PRINTING UTILITY - SENSOR DATA STATISTICS REPORT"                    PAGE:     2
5698-FPP                                                   DATE: 10/30/2022  TIME: 17.10.43                         HFPSPRNT - V2.R1

DBD NAME: DEDBJN21, AREA NAME: DB21AR0                                                              Collected on 10/29/2022 17.05.05
------------------------------------------------------------------------------------------------------------------------------------

==============================================
   DATABASE RECORD STATISTICS
==============================================

Data Element Name                        Value
------------------------  --------------------
DB_NUM_ROOT                                120
DB_AVG_DBREC_LENGTH                     106.00
DB_MAX_DBREC_LENGTH                        582
DB_MIN_DBREC_LENGTH                        102
DB_PCT_NUM_DBREC_IOVF                      18%


==============================================
   RANDOMIZING STATISTICS
==============================================

Data Element Name                        Value
------------------------  --------------------
DB_AVG_LEN_SYNONYM_CHAIN                120.00
DB_MAX_LEN_SYNONYM_CHAIN                   120


==============================================
   PHYSICAL I/O STATISTICS
==============================================

Data Element Name                        Value
------------------------  --------------------
DB_ESTIMATED_DBREC_IO                    26.00
DB_ESTIMATED_ROOT_IO                     26.00
DB_AVG_DBREC_IO                           7.06
DB_MAX_DBREC_IO                             13
DB_AVG_ROOT_IO                            7.06
DB_MAX_ROOT_IO                              13


==============================================
   UOW STATISTICS INFORMATION
==============================================

Data Element Name                        Value
------------------------  --------------------
DB_FLAG_UOW_DATA                             Y
DB_FLAG_UOW_GROUP_DATA                       N
DB_NUM_UOW_GROUPS                          n/a
DB_THRESHOLD_RBASEFS                       30%
DB_THRESHOLD_RDOVFFS                       50%
DB_NUM_UOW_RFS_COND                         50 
DB_PCT_NUM_UOW_RFS_COND                    10%


==============================================
   REPOSITORY GROUP INFORMATION
==============================================

Data Element Name                        Value
------------------------  --------------------
DB_SENSOR_DATA_GROUP_ID                   MYID

Figure 5. Sensor Data Statistics report when UOW_REPORT=YES and sensor data for all UOWs is stored (FP DB Sensor Printing utility) (Part 3 of 4)

IMS HPFP UTILITIES - DB SENSOR                     "PRINTING UTILITY - SENSOR DATA STATISTICS REPORT"                    PAGE:     3
5698-FPP                                                   DATE: 10/30/2022  TIME: 17.10.43                         HFPSPRNT - V2.R1

DBD NAME: DEDBJN21, AREA NAME: DB21AR0, UOW NUMBER:     0                                           Collected on 10/29/2022 17.05.05
------------------------------------------------------------------------------------------------------------------------------------

==============================================
   FREE SPACE PERCENTAGE STATISTICS
==============================================

Data Element Name                        Value
------------------------  --------------------
DBU_PCT_BYTES_FS_RAA                       80% 
DBU_PCT_BYTES_FS_DOVF                      80%
DBU_PCT_BYTES_FS_IOVF                      95%
DBU_PCT_USABLE_RAAFS                       80%
DBU_PCT_USABLE_DOVFFS                      80%
DBU_PCT_USABLE_IOVFFS                      95%
DBU_PCT_RAP_ROOTSZFS                        0%
DBU_MAX_PCT_BYTES_RAPFS                     0%
DBU_FLAG_UOW_USING_OVFL                      Y
DBU_FLAG_UOW_USING_IOVF                      Y


==============================================
   OVERFLOW USAGE STATISTICS
==============================================

Data Element Name                        Value
------------------------  --------------------
DBU_NUM_DOVFCI_BY_UOW                       10
DBU_NUM_IOVFCI_BY_UOW                        3
DBU_PCT_NUM_RAPCI_OVFL                    100% 


==============================================
   DATABASE RECORD STATISTICS
==============================================

Data Element Name                        Value
------------------------  --------------------
DBU_NUM_ROOT                               120
DBU_AVG_DBREC_LENGTH                    106.00
DBU_MAX_DBREC_LENGTH                       582 
DBU_MIN_DBREC_LENGTH                       102
DBU_PCT_NUM_DBREC_IOVF                     18%

Figure 6. Sensor Data Statistics report when UOW_REPORT=YES and sensor data for all UOWs is stored (FP DB Sensor Printing utility) (Part 4 of 4)

IMS HPFP UTILITIES - DB SENSOR                     "PRINTING UTILITY - SENSOR DATA STATISTICS REPORT"                    PAGE:     4
5698-FPP                                                   DATE: 10/30/2022  TIME: 17.10.43                         HFPSPRNT - V2.R1

DBD NAME: DEDBJN21, AREA NAME: DB21AR0, UOW NUMBER:     0                                           Collected on 10/29/2022 17.05.05
------------------------------------------------------------------------------------------------------------------------------------

==============================================
   RANDOMIZING STATISTICS
==============================================

Data Element Name                        Value
------------------------  --------------------
DBU_AVG_LEN_SYN_CHAIN                   120.00
DBU_MAX_LEN_SYN_CHAIN                      120


==============================================
   PHYSICAL I/O STATISTICS
==============================================

Data Element Name                        Value
------------------------  --------------------
DBU_AVG_DBREC_IO                          7.06
DBU_MAX_DBREC_IO                            13
DBU_AVG_ROOT_IO                           7.06
DBU_MAX_ROOT_IO                             13

The following figures show another example of the Sensor Data Statistics report. In this report, logical pages 3 and 4 contain data element values for a UOW group that was specified by the HFPAUOWC DD statement in the job that collected and stored the sensor data. This report is printed if all of the following conditions are met:

UOW_REPORT=YES is specified
UOW-related sensor data exists in the Sensor Data repository
HFPAUOWC DD statement was specified in the job that collected and stored the sensor data

In actual reports, if multiple UOW groups are specified, data element values for other UOW groups are printed in the subsequent pages.

Figure 7. Sensor Data Statistics report when UOW_REPORT=YES and sensor data for a UOW range is stored (FP DB Sensor Printing utility) (Part 1 of 4)

IMS HPFP UTILITIES - DB SENSOR                     "PRINTING UTILITY - SENSOR DATA STATISTICS REPORT"                    PAGE:     1
5698-FPP                                                   DATE: 10/30/2022  TIME: 17.10.43                         HFPSPRNT - V2.R1

DBD NAME: DEDBJN21, AREA NAME: DB21AR0                                                              Collected on 10/29/2022 17.05.05
------------------------------------------------------------------------------------------------------------------------------------

==============================================
   AREA DEFINITION
==============================================

Data Element Name                        Value
------------------------  --------------------
DB_AREADEF_CISIZE                        1,024
DB_AREADEF_UOW1                             15
DB_AREADEF_UOW2                             10
DB_AREADEF_ROOT1                            10
DB_AREADEF_ROOT2                             5
DB_AREADEF_NUM_SDEP_CIS                     64


==============================================
   FREE SPACE PERCENTAGE STATISTICS
==============================================

Data Element Name                        Value
------------------------  --------------------
DB_PCT_BYTES_FS_RAA                        96%
DB_PCT_BYTES_FS_DOVF                       81%
DB_PCT_BYTES_FS_IOVF                       96%
DB_PCT_BYTES_FS_SDEP                       52%


==============================================
   OVERFLOW USAGE STATISTICS
==============================================

Data Element Name                        Value
------------------------  --------------------
DB_PCT_NUM_UOW_USE_DOVF                    20%
DB_AVG_NUM_DOVFCI_BY_UOW                 10.00
DB_MAX_NUM_DOVFCI_BY_UOW                    10
DB_PCT_NUM_UOW_USE_IOVF                    20%
DB_NUM_UOW_USE_IOVF                          1
DB_AVG_NUM_IOVFCI_BY_UOW                  3.00
DB_MAX_NUM_IOVFCI_BY_UOW                     3
DB_MIN_NUM_IOVFCI_BY_UOW                     3
DB_PCT_NUM_IOVFCI_USED                      5%
DB_PCT_NUM_RAPCI_OVFL                     100%


==============================================
   SEGMENT OCCURRENCE STATISTICS
==============================================

Data Element Name                        Value
------------------------  --------------------
DB_NUM_SEG                                 130

Figure 8. Sensor Data Statistics report when UOW_REPORT=YES and sensor data for a UOW range is stored (FP DB Sensor Printing utility) (Part 2 of 4)

IMS HPFP UTILITIES - DB SENSOR                     "PRINTING UTILITY - SENSOR DATA STATISTICS REPORT"                    PAGE:     2
5698-FPP                                                   DATE: 10/30/2022  TIME: 17.10.43                         HFPSPRNT - V2.R1

DBD NAME: DEDBJN21, AREA NAME: DB21AR0                                                              Collected on 10/29/2022 17.05.05
------------------------------------------------------------------------------------------------------------------------------------

==============================================
   DATABASE RECORD STATISTICS
==============================================

Data Element Name                        Value
------------------------  --------------------
DB_NUM_ROOT                                120
DB_AVG_DBREC_LENGTH                     106.00
DB_MAX_DBREC_LENGTH                        582
DB_MIN_DBREC_LENGTH                        102
DB_PCT_NUM_DBREC_IOVF                      18%


==============================================
   RANDOMIZING STATISTICS
==============================================

Data Element Name                        Value
------------------------  --------------------
DB_AVG_LEN_SYNONYM_CHAIN                120.00
DB_MAX_LEN_SYNONYM_CHAIN                   120


==============================================
   PHYSICAL I/O STATISTICS
==============================================

Data Element Name                        Value
------------------------  --------------------
DB_ESTIMATED_DBREC_IO                    26.00
DB_ESTIMATED_ROOT_IO                     26.00
DB_AVG_DBREC_IO                           7.06
DB_MAX_DBREC_IO                             13
DB_AVG_ROOT_IO                            7.06
DB_MAX_ROOT_IO                              13


==============================================
   UOW STATISTICS INFORMATION
==============================================

Data Element Name                        Value
------------------------  --------------------
DB_FLAG_UOW_DATA                             N
DB_FLAG_UOW_GROUP_DATA                       Y
DB_NUM_UOW_GROUPS                            1
DB_THRESHOLD_RBASEFS                       30%
DB_THRESHOLD_RDOVFFS                       50%
DB_NUM_UOW_RFS_COND                         50 
DB_PCT_NUM_UOW_RFS_COND                    10%


==============================================
   REPOSITORY GROUP INFORMATION
==============================================

Data Element Name                        Value
------------------------  --------------------
DB_SENSOR_DATA_GROUP_ID                    n/a

Figure 9. Sensor Data Statistics report when UOW_REPORT=YES and sensor data for a UOW range is stored (FP DB Sensor Printing utility) (Part 3 of 4)

IMS HPFP UTILITIES - DB SENSOR                     "PRINTING UTILITY - SENSOR DATA STATISTICS REPORT"                    PAGE:     3
5698-FPP                                                   DATE: 10/30/2022  TIME: 17.10.43                         HFPSPRNT - V2.R1
 
DBD NAME: DEDBJN21, AREA NAME: DB21AR0 , UOW GROUP (STARTUOW:     1, STOPUOW:     3)                Collected on 10/29/2022 17.05.05
------------------------------------------------------------------------------------------------------------------------------------

==============================================
   FREE SPACE PERCENTAGE STATISTICS
==============================================

Data Element Name                        Value
------------------------  --------------------
DBUG_PCT_BYTES_FS_RAA                      80%
DBUG_PCT_BYTES_FS_DOVF                     80%
DBUG_PCT_BYTES_FS_IOVF                     95%
DBUG_PCT_USABLE_RAAFS                      80%
DBUG_PCT_USABLE_DOVFFS                     80%
DBUG_PCT_USABLE_IOVFFS                     95%
DBUG_PCT_RAP_ROOTSZFS                       0%


==============================================
   OVERFLOW USAGE STATISTICS
==============================================

Data Element Name                        Value
------------------------  --------------------
DBUG_PCT_NUM_UOW_DOVF                      80%
DBUG_AVG_NUM_DOVFCI                          5
DBUG_MAX_NUM_DOVFCI                         10
DBUG_PCT_NUM_UOW_IOVF                      80%
DBUG_AVG_NUM_IOVFCI                         10
DBUG_MAX_NUM_IOVFCI                         50
DBUG_PCT_NUM_RAPCI_OVFL                   100%


==============================================
   DATABASE RECORD STATISTICS
==============================================

Data Element Name                        Value
------------------------  --------------------
DBUG_NUM_ROOT                              120
DBUG_AVG_DBREC_LENGTH                   106.00
DBUG_MAX_DBREC_LENGTH                      582
DBUG_MIN_DBREC_LENGTH                      102
DBUG_PCT_NUM_DBREC_IOVF                    18%

Figure 10. Sensor Data Statistics report when UOW_REPORT=YES and sensor data for a UOW range is stored (FP DB Sensor Printing utility) (Part 4 of 4)

IMS HPFP UTILITIES - DB SENSOR                     "PRINTING UTILITY - SENSOR DATA STATISTICS REPORT"                    PAGE:     4
5698-FPP                                                   DATE: 10/30/2022  TIME: 17.10.43                         HFPSPRNT - V2.R1

 
DBD NAME: DEDBJN21, AREA NAME: DB21AR0 , UOW GROUP (STARTUOW:     1, STOPUOW:     3)                Collected on 10/29/2022 17.05.05
------------------------------------------------------------------------------------------------------------------------------------

==============================================
   RANDOMIZING STATISTICS
==============================================

Data Element Name                        Value
------------------------  --------------------
DBUG_AVG_LEN_SYN_CHAIN                  120.00
DBUG_MAX_LEN_SYN_CHAIN                     120


==============================================
   PHYSICAL I/O STATISTICS
==============================================

Data Element Name                        Value
------------------------  --------------------
DBUG_AVG_DBREC_IO                         7.06
DBUG_MAX_DBREC_IO                           13
DBUG_AVG_ROOT_IO                          7.06
DBUG_MAX_ROOT_IO                            13