Created On:  26 May 2011

Problem:

Import type “Referential Integrity” in the “Import Class” window on customer computer is not active and does not work. In the Micro Focus Data Express Getting Started with z/OS Data Stores, chapter “Importing Referential Integrity Classes” it is written that import type “Referential Integrity” can be used for both Data Express for z/OS and Data Express for Distributed Systems. The customer uses Data Express for z/OS and It is not active.

Resolution:

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 knowledgebase. 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. The steps for creating the table HSURDRIA and activating/deactivating the function import type “Referential Integrity” are:   
 
   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;
 
 where:   

      &URDBASE  is the name of the DB2 database where the product tables are created.

      &URSGROUP is  the name of the DB2 storage group.  

      &UROWNER  is the name of the DB2 creator that is used in order to create all the product tables.

      &URBPTS is the name of the buffer pool containing the data of the product tables. 

    &URBPIX  is the 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'
 
Incident #2512576