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 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.

  1. Ensure administrative privileges for the DB2 userid.
  2. 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.
  3. 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')
  4. After restarting Data Builder you should see import type Referential Integrity active.
  5. To deactivate the import type Referential Integrity perform the command below and then restart the Data Builder: DELETE FROM &UROWNER.HSURDRIA WHERE ACTIVATION = 'Y'