How the agent handles DB2 error codes during detail monitoring

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

Action

Description

IGNORE

Ignores the error.

UNKNOWN

Marks the resource state as UNKNOWN and sends a notification if the Notifier resource is configured. For more information about VCS notification, refer to the Symantec Cluster Server Administrator's Guide. This action is typically associated with configuration errors.

WARN

Marks the resource state as ONLINE and sends a notification if the Notifier resource is configured. This action is typically associated with low-severity errors.