DB2 Version 10.1 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
DBADM authority
SQLADM authority

Default PUBLIC privilege

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

Example

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

The following is an example of 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`'