After DB Sensor stores sensor data, DB Sensor generates
a Sensor Data Statistics report. This report is printed in the BBESPRT
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 following figures show an example of the Sensor Data Statistics report when
SEGMENT_STAT=YES is specified.
Note: The heading information in the
report is different based on the database type.
For non-HALDBs, the report header displays "SENSOR DATA STATISTICS REPORT".
For HALDBs,
When SEGMENT_STAT=YES is specified, the report header displays "SENSOR DATA
STATISTICS REPORT - HALDB" and "SENSOR DATA STATISTICS REPORT - HALDB PARTITION".
When SEGMENT_STAT=NO is specified, only "SENSOR DATA STATISTICS REPORT - HALDB
PARTITION" header is displayed.
Figure 1. Sensor Data Statistics report when SEGMENT_STAT=YES (FF Stand-alone DB Sensor) (Part
1 of 5)
IMS DATABASE SOLUTION PACK FOR z/OS "SENSOR DATA STATISTICS REPORT - HALDB" PAGE: 1
5655-DSP DATE: 08/22/2023 TIME: 07.50.46 BBESENSR - V2.R2
Database Statistics (DBD: PHIMDB1 , DBTYPE: PHIDAM )
------------------------------------------------------------------------------------------------------------------------------------
===================================
Segment Statistics for Database
===================================
Segment statistics summary
============================
Data Element Name Value
------------------------ ------------------
DB_FLAG_SEGMENT_STAT Y
DB_NUM_SEGTYPE 255
DB_NUM_SEG_DB 1,713
DB_NUM_SEG_DSG01_DB 1,713
Segment definition and statistics per segment type
====================================================
Data Element Name Value
------------------------ ------------------
DB_SEG_SC 1
DB_SEG_LEVEL 1
DB_SEG_DSG A
DB_SEG_NAME ROOT
DB_NUM_SEG_SC_DB 17
DB_FLAG_SEG_LEN_TYPE VC
DB_SEG_SC 2
DB_SEG_LEVEL 2
DB_SEG_DSG A
DB_SEG_NAME D001
DB_NUM_SEG_SC_DB 336
DB_FLAG_SEG_LEN_TYPE V
DB_SEG_SC 3
DB_SEG_LEVEL 2
DB_SEG_DSG A
DB_SEG_NAME D002
DB_NUM_SEG_SC_DB 243
DB_FLAG_SEG_LEN_TYPE V
DB_SEG_SC 4
DB_SEG_LEVEL 3
DB_SEG_DSG A
DB_SEG_NAME D003
DB_NUM_SEG_SC_DB 112
DB_FLAG_SEG_LEN_TYPE V
DB_SEG_SC 5
DB_SEG_LEVEL 2
DB_SEG_DSG A
DB_SEG_NAME D004
DB_NUM_SEG_SC_DB 408
DB_FLAG_SEG_LEN_TYPE V
IMS DATABASE SOLUTION PACK FOR z/OS "SENSOR DATA STATISTICS REPORT - HALDB" PAGE: 38
5655-DSP DATE: 08/22/2023 TIME: 07.50.46 BBESENSR - V2.R2
Database Statistics (DBD: PHIMDB1 , DBTYPE: PHIDAM )
------------------------------------------------------------------------------------------------------------------------------------
================================
Segment Statistics for Index
================================
Segment statistics summary
============================
Data Element Name Value
------------------------ ------------------
DBX_FLAG_SEGMENT_STAT Y
DBX_SEG_NAME n/a
DBX_NUM_IPS_DB 18
IMS DATABASE SOLUTION PACK FOR z/OS "SENSOR DATA STATISTICS REPORT - HALDB PARTITION" PAGE: 39
5655-DSP DATE: 08/22/2023 TIME: 07.50.46 BBESMAIN - V2.R2
Partition Statistics (DBD: PHIMDB1 , Partition: PHIM1A , DBTYPE: PHIDAM , ACTIVE DBDS= A-J)
------------------------------------------------------------------------------------------------------------------------------------
==============================
Database Record Statistics
==============================
Data Element Name Value
------------------------ ------------------
DB_FLAG_SENSOR_DBINFO Y
DB_NUM_ROOT 17
DB_AVG_DBREC_LENGTH 13,216.82
IMS DATABASE SOLUTION PACK FOR z/OS "SENSOR DATA STATISTICS REPORT - HALDB PARTITION" PAGE: 40
5655-DSP DATE: 08/22/2023 TIME: 07.50.46 BBESMAIN - V2.R2
Partition Statistics (DBD: PHIMDB1 , Partition: PHIM1A , DBTYPE: PHIDAM , ACTIVE DBDS= A-J)
------------------------------------------------------------------------------------------------------------------------------------
===========================
Physical I/O Statistics
===========================
Data Element Name Value
------------------------ ------------------
DB_ESTIMATED_DBREC_IO 20.18
DB_ESTIMATED_ROOT_IO n/a
Figure 2. Sensor Data Statistics report when SEGMENT_STAT=YES (FF Stand-alone DB Sensor) (Part
2 of 5)
IMS DATABASE SOLUTION PACK FOR z/OS "SENSOR DATA STATISTICS REPORT - HALDB PARTITION" PAGE: 41
5655-DSP DATE: 08/22/2023 TIME: 07.50.46 BBESMAIN - V2.R2
Partition Statistics (DBD: PHIMDB1 , Partition: PHIM1A , DBTYPE: PHIDAM , ACTIVE DBDS= A-J)
------------------------------------------------------------------------------------------------------------------------------------
====================================
Segment Statistics for Partition
====================================
Segment statistics summary
============================
Data Element Name Value
------------------------ ------------------
DB_FLAG_SEGMENT_STAT Y
DB_NUM_SEGTYPE 255
DB_NUM_SEG_PART 1,713
DB_NUM_SEG_DSG01_PART 1,713
Segment definition and statistics per segment type
====================================================
Data Element Name Value
------------------------ ------------------
DB_SEG_SC 1
DB_SEG_LEVEL 1
DB_SEG_DSG A
DB_SEG_NAME ROOT
DB_NUM_SEG_SC 17
DB_FLAG_SEG_LEN_TYPE VC
DB_SEG_SC 2
DB_SEG_LEVEL 2
DB_SEG_DSG A
DB_SEG_NAME D001
DB_NUM_SEG_SC 336
DB_FLAG_SEG_LEN_TYPE V
DB_SEG_SC 3
DB_SEG_LEVEL 2
DB_SEG_DSG A
DB_SEG_NAME D002
DB_NUM_SEG_SC 243
DB_FLAG_SEG_LEN_TYPE V
DB_SEG_SC 4
DB_SEG_LEVEL 3
DB_SEG_DSG A
DB_SEG_NAME D003
DB_NUM_SEG_SC 112
DB_FLAG_SEG_LEN_TYPE V
DB_SEG_SC 5
DB_SEG_LEVEL 2
DB_SEG_DSG A
DB_SEG_NAME D004
DB_NUM_SEG_SC 408
DB_FLAG_SEG_LEN_TYPE V
IMS DATABASE SOLUTION PACK FOR z/OS "SENSOR DATA STATISTICS REPORT - HALDB PARTITION" PAGE: 78
5655-DSP DATE: 08/22/2023 TIME: 07.50.46 BBESMAIN - V2.R2
Partition Statistics (DBD: PHIMDB1 , Partition: PHIM1A , DBTYPE: PHIDAM , ACTIVE DBDS= A-J)
------------------------------------------------------------------------------------------------------------------------------------
======================================
Index Space Utilization Statistics
======================================
Data Element Name Value
------------------------ ------------------
DBX_NUM_IPS 18
DBX_NUM_IPS_OVFL n/a
DBX_PCT_IPS_OVFL n/a
IMS DATABASE SOLUTION PACK FOR z/OS "SENSOR DATA STATISTICS REPORT - HALDB PARTITION" PAGE: 79
5655-DSP DATE: 08/22/2023 TIME: 07.50.46 BBESMAIN - V2.R2
Partition Statistics (DBD: PHIMDB1 , Partition: PHIM1A , DBTYPE: PHIDAM , ACTIVE DBDS= A-J)
------------------------------------------------------------------------------------------------------------------------------------
================================
Segment Statistics for Index
================================
Segment statistics summary
============================
Data Element Name Value
------------------------ ------------------
DBX_FLAG_SEGMENT_STAT Y
DBX_SEG_NAME n/a
DBX_NUM_IPS 18
DBX_NUM_IPS_PRIM n/a
DBX_NUM_IPS_OVFL n/a
Figure 3. Sensor Data Statistics report when SEGMENT_STAT=YES (FF Stand-alone DB Sensor) (Part
3 of 5)
IMS DATABASE SOLUTION PACK FOR z/OS "SENSOR DATA STATISTICS REPORT - HALDB PARTITION" PAGE: 80
5655-DSP DATE: 08/22/2023 TIME: 07.50.46 BBESMAIN - V2.R2
Data Set Statistics (DBD: PHIMDB1 , Partition: PHIM1A , DBTYPE: PHIDAM , Primary Index Data Set)
------------------------------------------------------------------------------------------------------------------------------------
============================
Volume/Extent Statistics
============================
Data set definition and environment information
=================================================
Data Element Name Value
------------------------ ------------------
DBX_FLAG_SPACE_TYPE T
DBX_NUM_PRI_SPACE 1
DBX_NUM_SEC_SPACE 1
DBX_FLAG_SMS Y
DBX_MAX_EXT_DS 251
DBX_MAX_EXT_VOL 123
Data set usage information
============================
Data Element Name Value
------------------------ ------------------
DBX_NUM_EXT 1
DBX_NUM_VOL 1
DBX_NUM_UNUSED_VOL 0
DBX_NUM_UNUSED_VOL_SER 0
DBX_NUM_UNUSED_VOL_CAND 0
Remaining available data set extent estimation
================================================
Data Element Name Value
------------------------ ------------------
DBX_AVAIL_EXT_LESS_100 N
DBX_NUM_AVAIL_EXT n/a
DBX_AVAIL_EXT_LIMIT n/a
Remark: If DBX_NUM_UNUSED_VOL_CAND is not zero, more extents than those
indicated by DBX_NUM_AVAIL_EXT might be available.
IMS DATABASE SOLUTION PACK FOR z/OS "SENSOR DATA STATISTICS REPORT - HALDB PARTITION" PAGE: 81
5655-DSP DATE: 08/22/2023 TIME: 07.50.46 BBESMAIN - V2.R2
Data Set Statistics (DBD: PHIMDB1 , Partition: PHIM1A , DBTYPE: PHIDAM , Primary Index Data Set)
------------------------------------------------------------------------------------------------------------------------------------
===================================
Data Set Space Usage Statistics
===================================
Data Element Name Value
------------------------ ------------------
DBX_BLOCK_SIZE 512
DBX_NUM_DBDS_BLOCKS 49
DBX_MAX_DS_SIZE 4G
DBX_PCT_OF_MAX_DS_SIZE 0%
DBX_RBA_HIGH_ALLOC 25,088
DBX_RBA_HIGH_USED 25,088
DBX_UNUSED_BYTES 24,576
DBX_PCT_UNUSED_BYTES 98%
IMS DATABASE SOLUTION PACK FOR z/OS "SENSOR DATA STATISTICS REPORT - HALDB PARTITION" PAGE: 82
5655-DSP DATE: 08/22/2023 TIME: 07.50.46 BBESMAIN - V2.R2
Data Set Statistics (DBD: PHIMDB1 , Partition: PHIM1A , DBTYPE: PHIDAM , Primary Index Data Set)
------------------------------------------------------------------------------------------------------------------------------------
====================
Index Statistics
====================
Data Element Name Value
------------------------ ------------------
DBX_NUM_CI_SPLIT 0
DBX_PCT_NUM_CI_SPLIT 0%
DBX_NUM_CA_SPLIT 0
DBX_PCT_NUM_CA_SPLIT 0%
DBX_LRECL_SIZE 16
IMS DATABASE SOLUTION PACK FOR z/OS "SENSOR DATA STATISTICS REPORT - HALDB PARTITION" PAGE: 83
5655-DSP DATE: 08/22/2023 TIME: 07.50.46 BBESMAIN - V2.R2
Data Set Statistics (DBD: PHIMDB1 , Partition: PHIM1A , DBTYPE: PHIDAM , Primary Index Data Set)
------------------------------------------------------------------------------------------------------------------------------------
================================
Segment Statistics for Index
================================
Segment statistics summary
============================
Data Element Name Value
------------------------ ------------------
DBX_FLAG_SEGMENT_STAT Y
DBX_SEG_NAME n/a
DBX_NUM_IPS 18
DBX_NUM_IPS_PRIM n/a
DBX_NUM_IPS_OVFL n/a
Figure 4. Sensor Data Statistics report when SEGMENT_STAT=YES (FF Stand-alone DB Sensor) (Part
4 of 5)
IMS DATABASE SOLUTION PACK FOR z/OS "SENSOR DATA STATISTICS REPORT - HALDB PARTITION" PAGE: 84
5655-DSP DATE: 08/22/2023 TIME: 07.50.46 BBESMAIN - V2.R2
Data Set Statistics (DBD: PHIMDB1 , Partition: PHIM1A , DBTYPE: PHIDAM , DSG: A )
------------------------------------------------------------------------------------------------------------------------------------
============================
Volume/Extent Statistics
============================
Data set definition and environment information
=================================================
Data Element Name Value
------------------------ ------------------
DB_FLAG_SPACE_TYPE C
DB_NUM_PRI_SPACE 2
DB_NUM_SEC_SPACE 1
DB_FLAG_SMS Y
DB_MAX_EXT_DS 251
DB_MAX_EXT_VOL 123
Data set usage information
============================
Data Element Name Value
------------------------ ------------------
DB_NUM_EXT 1
DB_NUM_VOL 1
DB_NUM_UNUSED_VOL 0
DB_NUM_UNUSED_VOL_SER 0
DB_NUM_UNUSED_VOL_CAND 0
Remaining available data set extent estimation
================================================
Data Element Name Value
------------------------ ------------------
DB_AVAIL_EXT_LESS_100 N
DB_NUM_AVAIL_EXT n/a
DB_AVAIL_EXT_LIMIT n/a
Remark: If DB_NUM_UNUSED_VOL_CAND is not zero, more extents than those
indicated by DB_NUM_AVAIL_EXT might be available.
IMS DATABASE SOLUTION PACK FOR z/OS "SENSOR DATA STATISTICS REPORT - HALDB PARTITION" PAGE: 85
5655-DSP DATE: 08/22/2023 TIME: 07.50.46 BBESMAIN - V2.R2
Data Set Statistics (DBD: PHIMDB1 , Partition: PHIM1A , DBTYPE: PHIDAM , DSG: A )
------------------------------------------------------------------------------------------------------------------------------------
===================================
Data Set Space Usage Statistics
===================================
Data Element Name Value
------------------------ ------------------
DB_BLOCK_SIZE 1,024
DB_NUM_DBDS_BLOCKS 261
DB_MAX_DS_SIZE 4G
DB_PCT_OF_MAX_DS_SIZE 0%
DB_RBA_HIGH_ALLOC 1,013,760
DB_RBA_HIGH_USED 267,264
DB_UNUSED_BYTES 746,496
DB_PCT_UNUSED_BYTES 74%
Figure 5. Sensor Data Statistics report when SEGMENT_STAT=YES (FF Stand-alone DB Sensor) (Part
5 of 5)
IMS DATABASE SOLUTION PACK FOR z/OS "SENSOR DATA STATISTICS REPORT - HALDB PARTITION" PAGE: 86
5655-DSP DATE: 08/22/2023 TIME: 07.50.46 BBESMAIN - V2.R2
Data Set Statistics (DBD: PHIMDB1 , Partition: PHIM1A , DBTYPE: PHIDAM , DSG: A )
------------------------------------------------------------------------------------------------------------------------------------
====================================
IMS Space Utilization Statistics
====================================
Data Element Name Value
------------------------ ------------------
DB_BYTES_SEG 224,686
DB_BYTES_FREE_SPACE 37,208
DB_BYTES_UNIDENTIFIED 42
DB_PCT_BYTES_FREE_SPACE 14%
DB_PCT_BYTES_SEG 84%
DB_NUM_SEG 1,713
DB_NUM_VLSEG 1,713
DB_NUM_VLSEG_SPLIT 0
DB_PCT_NUM_VLSEG_SPLIT 0%
DB_NUM_UNIDENTIFIED 10
DB_AVG_NUM_UNIDENTIFIED .04
DB_NUM_FSE 246
DB_AVG_NUM_FSE .94
DB_NUM_FSE_MIN 176
DB_NUM_FSE_MAX 0
DB_AVG_NUM_NOREUSE_FSE .27
DB_PCT_NUM_NOREUSE_FSE 28%
DB_AVG_NUM_FRAGD_FSE .94
DB_PCT_NUM_FRAGD_FSE 100%
DB_NUM_PTR 4,672
DB_NUM_PTR_DIFF_BLK 1,976
DB_PCT_NUM_PTR_DIFF_BLK 42%
IMS DATABASE SOLUTION PACK FOR z/OS "SENSOR DATA STATISTICS REPORT - HALDB PARTITION" PAGE: 87
5655-DSP DATE: 08/22/2023 TIME: 07.50.46 BBESMAIN - V2.R2
Data Set Statistics (DBD: PHIMDB1 , Partition: PHIM1A , DBTYPE: PHIDAM , DSG: A )
------------------------------------------------------------------------------------------------------------------------------------
===================================
Segment Statistics for Data Set
===================================
Segment statistics summary
============================
Data Element Name Value
------------------------ ------------------
DB_FLAG_SEGMENT_STAT Y
DB_NUM_SEG 1,713
Segment definition and statistics per segment type
====================================================
Data Element Name Value
------------------------ ------------------
DB_SEG_SC 1
DB_SEG_LEVEL 1
DB_SEG_DSG A
DB_SEG_NAME ROOT
DB_NUM_SEG_SC 17
DB_FLAG_SEG_LEN_TYPE VC
DB_SEG_SC 2
DB_SEG_LEVEL 2
DB_SEG_DSG A
DB_SEG_NAME D001
DB_NUM_SEG_SC 336
DB_FLAG_SEG_LEN_TYPE V
DB_SEG_SC 3
DB_SEG_LEVEL 2
DB_SEG_DSG A
DB_SEG_NAME D002
DB_NUM_SEG_SC 243
DB_FLAG_SEG_LEN_TYPE V
DB_SEG_SC 4
DB_SEG_LEVEL 3
DB_SEG_DSG A
DB_SEG_NAME D003
DB_NUM_SEG_SC 112
DB_FLAG_SEG_LEN_TYPE V
DB_SEG_SC 5
DB_SEG_LEVEL 2
DB_SEG_DSG A
DB_SEG_NAME D004
DB_NUM_SEG_SC 408
DB_FLAG_SEG_LEN_TYPE V