DB2 Version 10.1 for Linux, UNIX, and Windows

DB2_INSTANCE_ALERTS view - get information about alerts

The DB2_INSTANCE_ALERTS administrative view provides information about alerts in the DB2® pureScale® instance.

The schema is SYSIBMADM.

Authorization

The following authorizations is required:

SELECT privilege on the DB2_INSTANCE_ALERTS administrative view

Default PUBLIC privilege

In a non-restrictive database, SELECT privilege is granted to PUBLIC when the view is automatically created.

Example

The following example demonstrates the kind of information you can retrieve using the DB2_INSTANCE_ALERTS administrative view.

SELECT * FROM SYSIBMADM.DB2_INSTANCE_ALERTS

The following is an example of output for this query. The columns have been placed on separate rows for readability.

MESSAGE           
-------------------------------------------------------------------------------
Restart light failed for member 0 on host(s) hostC.  Check the db2diag.log for 
messages concerning a restart light or database crash recovery failure on these
hosts for member 0.  See the DB2 Information Center for more details.

ACTION
-------------------------------------------------------------------------------
This alert must be cleared manually with the command: 
   db2cluster -clear -alert -member 0

IMPACT
-------------------------------------------------------------------------------
Restart light will not succeed for member 0 on the hosts listed until this 
alert has been cleared.

Information returned

Table 1. Information returned by the DB2_INSTANCE_ALERTS administrative view
Column name	Data type	Description or Monitor element
MESSAGE	VARCHAR(32672)	message - Control Table Message monitor element
ACTION	VARCHAR(32672)	Action required to clear the alert.
IMPACT	VARCHAR(32672)	The impact to the DB2 pureScale instance if the alert is not cleared.