A fix is available
APAR status
Closed as program error.
Error description
The Full-Function DB Sensor generates incorrect values for some sensor data elements when VSAM statistics are invalid. If the incorrect values are not acceptable for IBM Tools Base, the sensor data elements are not stored in the ITB Sensor repository and MSG BBE1451E appears. This problem occurs in the following condition: - The database data set is VSAM - Close of the VSAM had failed before DB Sensor run The incorrect VSAM statistics are explained in APAR "II14008: IDCAMS LISTCAT SHOWS INVALID IN THE STATISTICS SECTION".
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: The following products users who perform * * Full-Function Database Sensor or * * Conditional Reorganization: * * - IBM IMS Database Reorganization Expert for * * z/OS V4.1(FMID=H25N410) * * - IBM IMS Online Reorganization Facility for * * z/OS V2.1(FMID=HAHP210) * * - IBM IMS Database Solution Pack for * * V2.1(FMID=HAHP210) * * - IBM IMS Database Utility Solution for * * V1.1(FMID=HDFA110) * **************************************************************** * PROBLEM DESCRIPTION: DB Sensor generates incorrect Sensor * * data elements, or DB Sensor does not * * generate Sensor data elements with * * MSGBBE1451E. * **************************************************************** * RECOMMENDATION: Apply the maintenance for this APAR. * **************************************************************** When VSAM close operation had been failure, VSAM statistics in Catalog became invalid. In this condition, DB Sensor cannot calculate some of DB Sensor elements correctly. As the result, so that DB Sensor generates incorrect Sensor data elements or DB Sensor issues MSGBBE1451E and RC=08. For details of Invalid VSAM Statistics, refer APAR II14008 in IBM Support web site.
Problem conclusion
The following modules and macro have been modified to resolve this error. BBESDIC BBESMSGT BBESUCSI BBESWSTA ======================== = DOCUMENTATION CHANGE = ======================== The documentation is modified as follows: ============================================================== IMS Database Reorgaization Expert V4R1, User's Guide (SC19113705) and IMS Solution Packs Data Sensor V2R1, User's Guide (SC19328303) ============================================================== > Troubleshooting >> Messages and codes << The following message is added. >> |BBE1332I SOME OF SENSOR DATA ELEMENTS ARE NOT STORED BECAUSE OF | INVALID VSAM STATISTIC. |Explanation: | The following Sensor data elements are not stored because | VSAM statistic values in Catalog are invalid. | For more details of invalid values in VSAM statistics, refer | APAR II14008 in IBM Support web site. | -DB_UNUSED_BYTES | -DB_PCT_UNUSED_BYTES | -DB_NUM_CI_SPLIT | -DB_PCT_NUM_CI_SPLIT | -DB_NUM_CA_SPLIT | -DB_PCT_NUM_CA_SPLIT | -DBX_NUM_IPS | -DBX_NUM_IPS_OVFL | -DBX_PCT_IPS_OVFL | -DBX_UNUSED_BYTES | -DBX_PCT_UNUSED_BYTES | -DBX_NUM_CI_SPLIT | -DBX_PCT_NUM_CI_SPLIT | -DBX_NUM_CA_SPLIT | -DBX_PCT_NUM_CA_SPLIT | Another BBE1332I message follows this message. The second | BBE1332I message indicates the data set that has invalid VSAM | statistics values. |System Action: | DB Sensor stores Sensor data elements other than the above | and continues processing. |User Response: | To store the above Sensor data elements, refer APAR II14008 | description and correct the statistic values of the VSAM data | set. ================= End of Documentation Change =================
Temporary fix
Comments
APAR Information
APAR number
PI79036
Reported component name
IMS DB REORG EX
Reported component ID
5655F7400
Reported release
410
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2017-03-29
Closed date
2017-04-17
Last modified date
2017-05-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI46464
Modules/Macros
BBESMSGT BBESUCSI BBESWSTA
SC19113705 | SC19328303 |
Fix information
Fixed component name
IMS DB REORG EX
Fixed component ID
5655F7400
Applicable component levels
R410 PSY UI46464
UP17/04/18 P F704
Fix is available
Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSVL5Q","label":"IMS Database Reorganization Expert for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"4.1.0","Edition":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]
Document Information
Modified date:
06 January 2023