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.

Important: This view is deprecated for Db2® version 11.5.8 and will be discontinued in a future release or modification pack.

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
  • ACCESSCTRL authority
  • SECADM 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'