CONTACTS administrative view - Retrieve list of contacts

The CONTACTS administrative view returns the list of contacts defined on the database server. The setting of the Database Administration Server (DAS) contact_host configuration parameter determines whether the list is local or global.
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 CONTACTS administrative view
  • CONTROL privilege on the CONTACTS 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

Retrieve all contacts. 
SELECT * FROM SYSIBMADM.CONTACTS
The following is an example of output for this query. 
NAME      TYPE  ADDRESS              MAX_PAGE_LENGTH DESCRIPTION           
-----...- ----- ----------------...- --------------- ------------------...-
user1     EMAIL user3@ca.ibm.com                   - DBA Extraordinaire    
user2     EMAIL user2@ca.ibm.com                   - DBA on Email          
user3     PAGE  user3@ca.ibm.com                 128 DBA on Page           
user5     EMAIL user2@ca.ibm.com                   - DBA Extraordinaire    

  4 record(s) selected.

Usage note

The DAS must have been created and be running.

Information returned

Table 1. Information returned by the CONTACTS administrative view
Column name Data type Description
NAME VARCHAR(128) Name of contact.
TYPE VARCHAR(5) Type of contact:
  • 'EMAIL'
  • 'PAGE'
ADDRESS VARCHAR(128) address - IP address from which the connection was initiated
MAX_PAGE_LENGTH INTEGER Maximum message length. Used for example, if the paging service has a message-length restriction.
DESCRIPTION VARCHAR(128) Description of contact.