master.class_membership table
The master.class_membership table supports the mapping of Tivoli Enterprise Console classes to Tivoli Netcool/OMNIbus classes, and stores class membership information. This table is used with the instance_of() SQL function.
The following table describes the columns in the master.class_membership table.
| Column name | Data type | Description |
|---|---|---|
| Class | integer | Primary key for table. Class number as stored in the alert.status table. |
| ClassName | varchar(255) | Name of class. |
| Parent | integer | Primary key for table. Parent ID of class. The root class has a parent ID of -1. If a class has multiple parents, a row exists for each parent. |
The master.class_membership table does not permit duplicate mappings of class names to class numbers. The table also does not permit multiple entries with either the same class name or class number. If a duplicate entry is inserted into the table, a warning message of the following format is written to the ObjectServer log:
Warning: W-OBJ-103-002: Class name 'ClassName' and number 'class_number' must be unique, row discarded