Creating the HSURDRIA table

The ability to import referential integrity class is based on the ACTIVATION field in the HSURDRIA table located in the Data Express 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.

Ensure administrative privileges for the DB2 userid.

Create the table HSURDRIA using the DDL below:

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;

&URDBASE: Name of the DB2 database where the product tables are created.
&URSGROUP: Name of the DB2 storage group.
&UROWNER: Name of the DB2 creator that is used in order to create all the product tables.
&URBPTS: Name of the buffer pool containing the data of the product tables.
&URBPIX: Name of the buffer pool containing the indexes of the product tables.

To activate the import type Referential Integrity, insert a value Y in the field ACTIVATION using the command: INSERT INTO &UROWNER.HSURDRIA (ACTIVATION) VALUES ('Y')
After restarting Data Builder you should see import type Referential Integrity active.
To deactivate the import type Referential Integrity perform the command below and then restart the Data Builder: DELETE FROM &UROWNER.HSURDRIA WHERE ACTIVATION = 'Y'