The schema is SYSIBMADM.
In a non-restrictive database, SELECT privilege is granted to PUBLIC when the view is automatically created.
SELECT * FROM SYSIBMADM.CONTACTS
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.
The DAS must have been created and be running.
Column name | Data type | Description |
---|---|---|
NAME | VARCHAR(128) | Name of contact. |
TYPE | VARCHAR(5) | Type of contact:
|
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. |