The Symantec ApplicationHA agent for DB2 comes with enhanced ability to handle DB2 errors during detail monitoring. The agent classifies DB2 errors according to their severity and associates predefined actions with each error code. You can create a custom error handling file, db2error.dat. The file lists the DB2 errors and the associated actions that the agent should take when it encounters an error.
The file stores information in the following format:
SQL_error_string:action_to_be_taken
For example:
SQL1034N: IGNORE SQL1039N: WARN
Table: Predefined agent actions for DB2 errors lists the predefined actions that the agent takes when a DB2 error is encountered.
Table: Predefined agent actions for DB2 errors