The ability to import referential integrity class is based on the ACTIVATION field in the HSURDRIA table located in the Data Manager knowledge base. During the z/OS Host installation this table is not created in the knowledge base. It must be created manually in case the import type Referential Integrity in the Import Class window will be used. This way of handling automatic referential integrity has been chosen in order to prevent uncontrolled access to z-OS knowledge base from user interface, because the referential integrity process is a time consuming one and it can affect the z-OS performances.
CREATE TABLESPACE HSURDRIA IN &URDBASE USING STOGROUP &URSGROUP PRIQTY 12 SECQTY 12 FREEPAGE 0 PCTFREE 0 BUFFERPOOL &URBPTS SEGSIZE 64 COMPRESS NO; CREATE TABLE &UROWNER.HSURDRIA FREEPAGE 0 PCTFREE 0 BUFFERPOOL &URBPTS SEGSIZE 64 COMPRESS NO; CREATE TABLE &UROWNER.HSURDRIA (ACTIVATION CHAR(1) NOT NULL WITH DEFAULT) IN &URDBASE..HSURDRIA; CREATE UNIQUE INDEX &UROWNER.HSURDRIAX1 ON &UROWNER..HSURDRIA (ACTIVATION) USING STOGROUP &URSGROUP PRIQTY 12 SECQTY 12 CLUSTER BUFFERPOOL &URBPIX;