Sensor Data Statistics report from FP Stand-alone Database Sensor

The Sensor Data Statistics report contains the names and the values of the data elements that were collected in the DB Sensor job.

For the definitions of these data elements, see the topics about data elements in IMS Tools Base Policy Services User’s Guide.

The following figures show an example of the Sensor Data Statistics report.

Figure 1. Sensor Data Statistics report (FP Stand-alone DB Sensor) (Part 1 of 2)

IMS HPFP UTILITIES - DB SENSOR                     "SENSOR DATA STATISTICS REPORT"                                    PAGE:       1
5698-FPP V2R1                                                                                                   2021-10-30 15:57:52

DBD NAME: DEDBJN23, AREA NAME: DB23AR0 , AREA NUMBER:    1
------------------------------------------------------------------------------------------------------------------------------------

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

Data Element Name                        Value 
------------------------  -------------------- 
DB_AREADEF_CISIZE                        4,096
DB_AREADEF_UOW1                             20
DB_AREADEF_UOW2                             10
DB_AREADEF_ROOT1                         1,500
DB_AREADEF_ROOT2                         1,000 
DB_AREADEF_NUM_SDEP_CIS                 10,000


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

Data Element Name                        Value 
------------------------  -------------------- 
DB_PCT_BYTES_FS_RAA                        50%
DB_PCT_BYTES_FS_DOVF                       50%
DB_PCT_BYTES_FS_IOVF                       50%
DB_PCT_BYTES_FS_SDEP                       50%


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

Data Element Name                        Value 
------------------------  --------------------  
DB_PCT_NUM_UOW_USE_DOVF                    50%
DB_AVG_NUM_DOVFCI_BY_UOW                678.99
DB_MAX_NUM_DOVFCI_BY_UOW                 9,999
DB_PCT_NUM_UOW_USE_IOVF                    50%
DB_NUM_UOW_USE_IOVF                      9,999
DB_AVG_NUM_IOVFCI_BY_UOW                678.99
DB_MAX_NUM_IOVFCI_BY_UOW                 9,999
DB_MIN_NUM_IOVFCI_BY_UOW                 9,999
DB_PCT_NUM_IOVFCI_USED                     50%
DB_PCT_NUM_RAPCI_OVFL                      50%


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

Data Element Name                        Value 
------------------------  --------------------  
DB_NUM_SEG                          12,345,678

Figure 2. Sensor Data Statistics report (FP Stand-alone DB Sensor) (Part 2 of 2)

IMS HPFP UTILITIES - DB SENSOR                     "SENSOR DATA STATISTICS REPORT"                                    PAGE:       2
5698-FPP V2R1                                                                                                   2021-10-30 15:57:52

DBD NAME: DEDBJN23, AREA NAME: DB23AR0 , AREA NUMBER:    1
-----------------------------------------------------------------------------------------------------------------------------------

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

Data Element Name                        Value 
------------------------  --------------------  
DB_NUM_ROOT                            111,111
DB_AVG_DBREC_LENGTH                     111.00
DB_MAX_DBREC_LENGTH                    111,111
DB_MIN_DBREC_LENGTH                    111,111
DB_PCT_NUM_DBREC_IOVF                      50%  


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

Data Element Name                        Value 
------------------------  --------------------  
DB_AVG_LEN_SYNONYM_CHAIN                  1.11
DB_MAX_LEN_SYNONYM_CHAIN                99,999


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

Data Element Name                        Value 
------------------------  --------------------   
DB_ESTIMATED_DBREC_IO                     1.25
DB_ESTIMATED_ROOT_IO                      1.25
DB_AVG_DBREC_IO                         678.99
DB_MAX_DBREC_IO                         99,999
DB_AVG_ROOT_IO                          678.99
DB_MAX_ROOT_IO                          99,999


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

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

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 both of the following conditions are met:

SENSOR_UOW=YES is specified
HFPAUOWC DD statement is not specified

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

Figure 3. Sensor Data Statistics report when SENSOR_UOW=YES (without HFPAUOWC DD, FP Stand-alone DB Sensor) (Part 1 of 4)

IMS HPFP UTILITIES - DB SENSOR                     "SENSOR DATA STATISTICS REPORT"                                    PAGE:       1
5698-FPP V2R1                                                                                                   2021-10-30 17:11:31

DBD NAME: DEDBJN23, AREA NAME: DB23AR0 , AREA NUMBER:    1
------------------------------------------------------------------------------------------------------------------------------------

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

Data Element Name                        Value 
------------------------  -------------------- 
DB_AREADEF_CISIZE                        4,096
DB_AREADEF_UOW1                             20
DB_AREADEF_UOW2                             10
DB_AREADEF_ROOT1                         1,500
DB_AREADEF_ROOT2                         1,000 
DB_AREADEF_NUM_SDEP_CIS                 10,000


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

Data Element Name                        Value 
------------------------  -------------------- 
DB_PCT_BYTES_FS_RAA                        50%
DB_PCT_BYTES_FS_DOVF                       50%
DB_PCT_BYTES_FS_IOVF                       50%
DB_PCT_BYTES_FS_SDEP                       52%


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

Data Element Name                        Value 
------------------------  --------------------  
DB_PCT_NUM_UOW_USE_DOVF                    50%
DB_AVG_NUM_DOVFCI_BY_UOW                678.99
DB_MAX_NUM_DOVFCI_BY_UOW                 9,999
DB_PCT_NUM_UOW_USE_IOVF                    50%
DB_NUM_UOW_USE_IOVF                      9,999
DB_AVG_NUM_IOVFCI_BY_UOW                678.99
DB_MAX_NUM_IOVFCI_BY_UOW                 9,999
DB_MIN_NUM_IOVFCI_BY_UOW                 9,999
DB_PCT_NUM_IOVFCI_USED                     50%
DB_PCT_NUM_RAPCI_OVFL                      50%


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

Data Element Name                        Value 
------------------------  --------------------  
DB_NUM_SEG                          12,345,678

Figure 4. Sensor Data Statistics report when SENSOR_UOW=YES (without HFPAUOWC DD, FP Stand-alone DB Sensor) (Part 2 of 4)

IMS HPFP UTILITIES - DB SENSOR                     "SENSOR DATA STATISTICS REPORT"                                    PAGE:       2
5698-FPP V2R1                                                                                                   2021-10-30 17:11:31

DBD NAME: DEDBJN23, AREA NAME: DB23AR0 , AREA NUMBER:    1
------------------------------------------------------------------------------------------------------------------------------------

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

Data Element Name                        Value 
------------------------  --------------------  
DB_NUM_ROOT                            111,111
DB_AVG_DBREC_LENGTH                     111.00
DB_MAX_DBREC_LENGTH                    111,111 
DB_MIN_DBREC_LENGTH                    111,111 
DB_PCT_NUM_DBREC_IOVF                      50% 


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

Data Element Name                        Value 
------------------------  -------------------- 
DB_AVG_LEN_SYNONYM_CHAIN                  1.11 
DB_MAX_LEN_SYNONYM_CHAIN                99,999 


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

Data Element Name                        Value 
------------------------  --------------------   
DB_ESTIMATED_DBREC_IO                     1.25
DB_ESTIMATED_ROOT_IO                      1.25
DB_AVG_DBREC_IO                         678.99 
DB_MAX_DBREC_IO                         99,999 
DB_AVG_ROOT_IO                          678.99 
DB_MAX_ROOT_IO                          99,999 


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

Data Element Name                        Value
------------------------  --------------------
DB_FLAG_UOW_DATA                             Y
DB_FLAG_UOW_GROUP_DATA                       N
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                   IMS1

Figure 5. Sensor Data Statistics report when SENSOR_UOW=YES (without HFPAUOWC DD, FP Stand-alone DB Sensor) (Part 3 of 4)

IMS HPFP UTILITIES - DB SENSOR                     "SENSOR DATA STATISTICS REPORT"                                    PAGE:       3
5698-FPP V2R1                                                                                                   2021-10-30 17:11:31

DBD NAME: DEDBJN23, AREA NAME: DB23AR0 , AREA NUMBER:    1, UOW NUMBER:      0  
------------------------------------------------------------------------------------------------------------------------------------

==============================================
   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 SENSOR_UOW=YES (without HFPAUOWC DD, FP Stand-alone DB Sensor) (Part 4 of 4)

IMS HPFP UTILITIES - DB SENSOR                     "SENSOR DATA STATISTICS REPORT"                                    PAGE:       4
5698-FPP V2R1                                                                                                   2021-10-30 17:11:31

DBD NAME: DEDBJN23, AREA NAME: DB23AR0 , AREA NUMBER:    1, UOW NUMBER:      0  
------------------------------------------------------------------------------------------------------------------------------------

==============================================
   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 is specified by the HFPAUOWC DD statement. This report is printed if both of the following conditions are met:

SENSOR_UOW=YES is specified
HFPAUOWC DD statement is specified

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 SENSOR_UOW=YES (with HFPAUOWC DD, FP Stand-alone DB Sensor) (Part 1 of 4)

IMS HPFP UTILITIES - DB SENSOR                     "SENSOR DATA STATISTICS REPORT"                                    PAGE:       1
5698-FPP V2R1                                                                                                   2021-10-30 17:11:31

DBD NAME: DEDBJN23, AREA NAME: DB23AR0 , AREA NUMBER:    1
------------------------------------------------------------------------------------------------------------------------------------

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

Data Element Name                        Value 
------------------------  -------------------- 
DB_AREADEF_CISIZE                        4,096
DB_AREADEF_UOW1                             20
DB_AREADEF_UOW2                             10
DB_AREADEF_ROOT1                         1,500
DB_AREADEF_ROOT2                         1,000 
DB_AREADEF_NUM_SDEP_CIS                 10,000


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

Data Element Name                        Value 
------------------------  -------------------- 
DB_PCT_BYTES_FS_RAA                        50%
DB_PCT_BYTES_FS_DOVF                       50%
DB_PCT_BYTES_FS_IOVF                       50%
DB_PCT_BYTES_FS_SDEP                       52%


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

Data Element Name                        Value 
------------------------  --------------------  
DB_PCT_NUM_UOW_USE_DOVF                    50%
DB_AVG_NUM_DOVFCI_BY_UOW                678.99
DB_MAX_NUM_DOVFCI_BY_UOW                 9,999
DB_PCT_NUM_UOW_USE_IOVF                    50%
DB_NUM_UOW_USE_IOVF                      9,999
DB_AVG_NUM_IOVFCI_BY_UOW                678.99
DB_MAX_NUM_IOVFCI_BY_UOW                 9,999
DB_MIN_NUM_IOVFCI_BY_UOW                 9,999
DB_PCT_NUM_IOVFCI_USED                     50%
DB_PCT_NUM_RAPCI_OVFL                      50%


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

Data Element Name                        Value 
------------------------  --------------------  
DB_NUM_SEG                          12,345,678

Figure 8. Sensor Data Statistics report when SENSOR_UOW=YES (with HFPAUOWC DD, FP Stand-alone DB Sensor) (Part 2 of 4)

IMS HPFP UTILITIES - DB SENSOR                     "SENSOR DATA STATISTICS REPORT"                                    PAGE:       2
5698-FPP V2R1                                                                                                   2021-10-30 17:11:31

DBD NAME: DEDBJN23, AREA NAME: DB23AR0 , AREA NUMBER:    1
------------------------------------------------------------------------------------------------------------------------------------

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

Data Element Name                        Value 
------------------------  --------------------  
DB_NUM_ROOT                            111,111
DB_AVG_DBREC_LENGTH                     111.00
DB_MAX_DBREC_LENGTH                    111,111 
DB_MIN_DBREC_LENGTH                    111,111 
DB_PCT_NUM_DBREC_IOVF                      50% 


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

Data Element Name                        Value 
------------------------  -------------------- 
DB_AVG_LEN_SYNONYM_CHAIN                  1.11 
DB_MAX_LEN_SYNONYM_CHAIN                99,999 


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

Data Element Name                        Value 
------------------------  --------------------   
DB_ESTIMATED_DBREC_IO                     1.25
DB_ESTIMATED_ROOT_IO                      1.25
DB_AVG_DBREC_IO                         678.99 
DB_MAX_DBREC_IO                         99,999 
DB_AVG_ROOT_IO                          678.99 
DB_MAX_ROOT_IO                          99,999 


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

Data Element Name                        Value
------------------------  --------------------
DB_FLAG_UOW_DATA                             N
DB_FLAG_UOW_GROUP_DATA                       Y
DB_NUM_UOW_GROUPS                            2
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                   IMS1

Figure 9. Sensor Data Statistics report when SENSOR_UOW=YES (with HFPAUOWC DD, FP Stand-alone DB Sensor) (Part 3 of 4)

IMS HPFP UTILITIES - DB SENSOR                     "SENSOR DATA STATISTICS REPORT"                                    PAGE:       3
5698-FPP V2R1                                                                                                   2021-10-30 17:11:31

DBD NAME: DEDBJN23, AREA NAME: DB23AR0 , AREA NUMBER:    1, UOW GROUP (STARTUOW: 10001, STOPUOW: 20000)  
------------------------------------------------------------------------------------------------------------------------------------

==============================================
   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 USAGE 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 SENSOR_UOW=YES (with HFPAUOWC DD, FP Stand-alone DB Sensor) (Part 4 of 4)

IMS HPFP UTILITIES - DB SENSOR                     "SENSOR DATA STATISTICS REPORT"                                    PAGE:       4
5698-FPP V2R1                                                                                                   2021-10-30 17:11:31

DBD NAME: DEDBJN23, AREA NAME: DB23AR0 , AREA NUMBER:    1, UOW GROUP (STARTUOW: 10001, STOPUOW: 20000)  
------------------------------------------------------------------------------------------------------------------------------------

==============================================
   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