Start of change

Update the CICS IA UDB database

When a CICS® IA UDB database is created, you can load the data.

To load the data to the database, follow these steps:
  1. Run the supplied sample jobs to unload the data from the VSAM files into CSV files. For more information about CSV files, see Preparing CSV files.
  2. When the CSV files are created, transfer them in ASCII to your DB2® Windows workstation.
    Note:
    • The transfer of these files might create a blank line at the end of each file. If the blank line remains at the end of each file, a warning is issued during the create or load process. It is recommended that you edit and remove the last line if required.
    • Depending on the method you use, you might need to uncomment the CONNECT statement in the following samples.
    • The DB2 command IMPORT must be used to load data from CSV files into the tables.
  3. Load data from CSV files into the tables.
    1. Create and edit load.in file:
      CONNECT TO _udbname_;
      SET SCHEMA _udbqual_;
      import from affinity.csv of del insert into _udbqual_.CIU_AFF_EVENTS;
      import from appl1.csv    of del insert into _udbqual_.CIU_APPLS_DESC;
      import from appl2.csv    of del insert into _udbqual_.CIU_APPLS_RESOURCE;
      import from cics.csv     of del insert into _udbqual_.CIU_CICS_DATA;
      import from cmdflow.csv  of del insert into _udbqual_.CIU_CMDFLOW_DATA;
      import from cmdindex.csv of del insert into _udbqual_.CIU_CMDFLOW_INDEX;
      import from conn.csv     of del insert into _udbqual_.CIU_CONNECTIONS;
      import from csect.csv    of del insert into _udbqual_.CIU_CSECT_INFO;
      import from csprog.csv   of del insert into _udbqual_.CIU_PROGRAM_INFO;
      import from db2.csv      of del insert into _udbqual_.CIU_DB2_DATA;
      import from event.csv    of del insert into _udbqual_.CIU_EVENT_DETAIL;
      import from exit.csv     of del insert into _udbqual_.CIU_EXIT_INFO;
      import from file.csv     of del insert into _udbqual_.CIU_FILE_DETAIL;
      import from ims.csv      of del insert into _udbqual_.CIU_IMS_DATA;
      import from mq.csv       of del insert into _udbqual_.CIU_MQ_DATA;
      import from natural.csv  of del insert into _udbqual_.CIU_NATURAL_DATA;
      import from program.csv  of del insert into _udbqual_.CIU_PROGRAM_DETAIL;
      import from region.csv   of del insert into _udbqual_.CIU_REGION_INFO;
      import from scandet.csv  of del insert into _udbqual_.CIU_SCAN_DETAIL;
      import from scansum.csv  of del insert into _udbqual_.CIU_SCAN_SUMMARY;
      import from tdqueue.csv  of del insert into _udbqual_.CIU_TDQUEUE_DETAIL;
      import from transid.csv  of del insert into _udbqual_.CIU_TRANSID_DETAIL;
      import from tsqueue.csv  of del insert into _udbqual_.CIU_TSQUEUE_DETAIL;
      import from webserv.csv  of del insert into _udbqual_.CIU_WEBSERV_DETAIL;
      COMMIT;
    2. Start of changeIf you are loading the scanner tables, then delete all of the records that are related to the scanned libraries by using the following SQL code:
      CONNECT TO _udbname_;
      SET SCHEMA _udbqual_;
      DELETE FROM _udbqual_.CIU_CSECT_INFO   WHERE DSNAME = 'DSNAME'; 
      DELETE FROM _udbqual_.CIU_PROGRAM_INFO WHERE DSNAME = 'DSNAME'; 
      DELETE FROM _udbqual_.CIU_SCAN_DETAIL  WHERE DSNAME = 'DSNAME'; 
      DELETE FROM _udbqual_.CIU_SCAN_SUMMARY WHERE DSNAME = 'DSNAME'; 
      COMMIT;
      End of change
    3. Use the DB2 command line processor: db2 -td; -vf load.in > load.out
  4. When some dependency tables are loaded, reload the CIU_RESOURCE table that is used by the CICS Explorer®.
    • Review and edit the sample CIUUDBT3.
    • Use the DB2 command line processor: db2 -td; -vf CIUUDBT3 > CIUUDBT3.out
  5. For affinity collection, run the CIUSPAFF stored procedure to load the affinity tables that are used by the CICS Explorer.
    • Review and edit the sample CIUUDBT4.
    • Use the DB2 command line processor: db2 -td; -vf CIUUDBT4 > CIUUDBT4.out
  6. To provide the relationships between file resources, the regions that own these resources, and correspondent data sets, run the CIUSPRMF stored procedure.
    • Review and edit the sample CIUUDBT5. The parameter _collid_ must be the actual value of collection ID.
    • Use the DB2 command line processor: db2 -td; -vf CIUUDBT5 > CIUUDBT5.out
  7. To identify Application entry points, run the CIUSPPCP stored procedure to reload the CIU_CICS_CHAINP table by collection ID.
    • Review and edit the sample CIUUDBT6. The parameter _collid_ must be the actual value of collection ID.
    • Use the DB2 command line processor: db2 -td; -vf CIUUDBT6 > CIUUDBT6.out.
End of change