DB2 Version 9.7 for Linux, UNIX, and Windows

NOTIFICATIONLIST administrative view - Retrieve contact list for health notification

The NOTIFICATIONLIST administrative view returns the list of contacts and contact groups that are notified about the health of an instance.

The schema is SYSIBMADM.

Authorization

One of the following authorizations is required:

SELECT privilege on the NOTIFICATIONLIST administrative view
CONTROL privilege on the NOTIFICATIONLIST administrative view
DATAACCESS authority

Example

Retrieve all contacts that will receive notification of health alerts.

SELECT * FROM SYSIBMADM.NOTIFICATIONLIST

The following example is a sample output for this query.

NAME                   TYPE   
------------...------- -------
group3                 GROUP  
user4                  CONTACT
group3                 GROUP  
                                                                                                                                        
  3 record(s) selected.

Information returned

Table 1. Information returned by the NOTIFICATIONLIST administrative view
Column name	Data type	Description
NAME	VARCHAR(128)	Name of contact.
TYPE	VARCHAR(7)	Type of contact: 'CONTACT' 'GROUP'