CHECK PLUS RI rules tables
Installing CHECK PLUS creates the following additional tables:
- BMCRELS
- BMCFOREIGNKEYS
- BMCPRIMARYKEYS
- BMCKEYS
CHECK PLUS uses these tables to store any user-defined RI rules that you define under the CHECK DATA option when you specify SAVERULES YES. Subsequent CHECK DATA utility jobs automatically use these saved rules when running against the Db2 objects affected by the rules definitions. For information about the option that uses these tables, see SAVERULES.
The CHECK PLUS RI rules tables are created using Db2-defined RI, with the cascade delete rule. You can access these BMC RI tables by using SQL statements.
CHECK PLUS BMCRELS table
Column name | Data type | Description |
|---|---|---|
CREATOR | VARCHAR(128) | Creator of the table a |
TBNAME | VARCHAR(128) | Table name a |
RELNAME | VARCHAR(128) | Constraint name a |
REFTBCREATOR | VARCHAR(128) | Creator of referenced table |
REFTBNAME | VARCHAR(128) | Name of referenced table |
COLCOUNT | SMALLINT | Number of key columns |
TIMESTAMP | TIMESTAMP | Timestamp of when the row was inserted |
a The first three columns make up the primary key.
CHECK PLUS BMCFOREIGNKEYS table
Column name | Data type | Description |
|---|---|---|
CREATOR | VARCHAR(128) | creator of the table a |
TBNAME | VARCHAR(128) | table name a |
RELNAME | VARCHAR(128) | constraint name a |
COLNAME | VARCHAR(128) | name of key column |
COLNO | SMALLINT | column number in table |
COLSEQ | SMALLINT | column sequence in key |
a The first three columns make up the foreign key.
CHECK PLUS BMCPRIMARYKEYS table
Column name | Data type | Description |
|---|---|---|
TBCREATOR | VARCHAR(128) | Creator of the table a |
TBNAME | VARCHAR(128) | Table name a |
COLCOUNT | SMALLINT | Number of key columns |
TIMESTAMP | TIMESTAMP | Timestamp of when the row was inserted |
a The first two columns make up the primary key.
CHECK PLUS BMCKEYS table
Column name | Data type | Description |
|---|---|---|
TBCREATOR | VARCHAR(128) | Creator of the table a |
TBNAME | VARCHAR(128) | Table name a |
COLNAME | VARCHAR(128) | Column name |
COLSEQ | SMALLINT | Column sequence in key |
a The first two columns make up the foreign key.