VSAM/OSAM Databases situations
You can take corrective action if database activity cause errors.
- IMS_DB_Dyn_Backout_Error
- The IMS system has had a
problem when trying to dynamically back out of a change to a database.
When this exception occurs, verify that the database identified by
the exception is still usable and contains the correct data.
The formula is:
VSAM/OSAM_Databases.Dynamic_Backout_Error EQ Yes - IMS_DB_I/O_Errors
- The IMS system had a write
error when trying to update the database identified in this exception.
Examine this database to determine if the data is still usable and
valid.
The formula is:
VSAM/OSAM_Databases.Write_Error EQ Yes - IMS_OSAM_Rate_High_Critical
- The OSAM data set I/O rate has exceeded the threshold. When the
rate for any database is high, it might cause the applications to
slow down since they end up sitting in an I/O wait status. Check the
application to ensure that it is running properly.
The formula is:
VSAM/OSAM_Databases.EXCP_Rate GE 60 AND VSAM/OSAM_Databases.Access_Method EQ OSAM - IMS_OSAM_Rate_High_Warning
- The OSAM data set I/O rate has exceeded the threshold. When the
rate for any database is high, it might cause the applications to
slow down since they end up sitting in an I/O wait status. Check the
application to ensure that it is running properly.
The formula is:
VSAM/OSAM_Databases.EXCP_Rate GE 50 AND VSAM/OSAM_Databases.EXCP_Rate LT 60 AND VSAM/OSAM_Databases.Access_Method EQ OSAM - IMS_VSAM_Rate_High_Critical
- The VSAM data set I/O rate has exceeded the threshold. When the
rate for any database is high, it can cause the applications to slow
down since they end up sitting in an I/O wait status. Check that the
application is running properly.
The formula is:
VSAM/OSAM_Databases.EXCP_Rate GE 80 AND VSAM/OSAM_Databases.Access_Method EQ VSAM - IMS_VSAM_Rate_High_Warning
- The VSAM data set I/O rate has exceeded the threshold. When the
rate for any database is high, it can cause the applications to slow
down since they end up sitting in an I/O wait status. Check that the
application is running properly.
The formula is:
VSAM/OSAM_Databases.EXCP_Rate GE 30 AND VSAM/OSAM_Databases.EXCP_Rate LT 80 AND VALUE VSAM/OSAM_Databases.Access_Method EQ VSAM