DB2 Version 9.7 for Linux, UNIX, and Windows

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.

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

Example

Retrieve all contacts.

SELECT * FROM SYSIBMADM.CONTACTS

The following example is a sample 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.