The CONTACTGROUPS administrative view returns the list of contact groups, which can be defined locally on the system or in a global list. The setting of the Database Administration Server (DAS) CONTACT_HOST configuration parameter determines whether the list is local or global.
The schema is SYSIBMADM.
SELECT * FROM SYSIBMADM.CONTACTGROUPS
NAME DESCRIPTION MEMBERNAME MEMBERTYPE
-------...--- ------------------------...--- -----------...--- ----------
group1 DBA Group1 Contact List name1 CONTACT
group1 DBA Group1 Contact List name9 CONTACT
group2 DBA Group2 List name2 CONTACT
group3 group2 GROUP
group5 DBA Group5 group2 GROUP
group6 DBA Group6 group3 GROUP
group7 name1 CONTACT
7 record(s) selected.
The DAS must have been created and be running.
Column name | Data type | Description |
---|---|---|
NAME | VARCHAR(128) | Name of the contact group. |
DESCRIPTION | VARCHAR(128) | Description of the contact group. |
MEMBERNAME | VARCHAR(128) | Name of the member in the contact group. This name can refer to a contact or another contact group. |
MEMBERTYPE | VARCHAR(7) | Type of member in the contact group. The type is either CONTACT or GROUP. |