Start of change

Creating and updating a CICS IA UDB database

CICS® IA provides jobs to unload CICS IA data into CSV files. These files can be used to populate the IBM® supported UDB databases.

CICS IA also provides the Definition Data Language (DDL) sample to create a UDB on Windows NT. This DDL is provided only as a sample. CICS IA also supplies sample tasks to run in your UDB environment. These sample tasks help you to load the tables from the CSV files. The process of creating a UDB CICS IA database usually comprises the following steps:
  1. Review and edit a sample DDL provided in hlq.SCIUSMP2(CIUUDBC).
  2. Run the DDL to create your UDB CICS IA database objects:
    • TABLES
    • VIEWS
    • Stored Procedures
When you have created a UDB IA database, perform the following steps to load the data:
  1. Run the supplied sample jobs to unload the data from the VSAM files into CSV files. See Preparing CSV files.
  2. After you have created your CSV files, transfer them in ASCII to your DB2® Windows NT Server workstation.
  3. Load the CSV files by using a UDB load utility. At this point, you can choose either to use a standard load utility or to write a custom update program. If you use a UDB IMPORT facility to load the CSV files, do the following:
    1. Select the INSERT option.
    2. Select the DELIMITER options as follows:
      1. The column delimiter is a comma (,).
      2. The character string delimiter is a double quote (").
  4. For affinity collection, run the CIUSPAFF stored procedure to load the affinity tables used by the Explorer. A sample task is provided in hlq.SCIUSMP1(CIUUDBT3).
  5. After you have loaded any of the dependency tables, reload the CIU_RESOURCE table used by the Explorer. A sample task is provided in hlq.SCIUSMP2(CIUUDBT1).
  6. Before connecting to the Explorer, load the CIU_VERSION table. A sample LOAD task is provided in hlq.SCIUSMP2(CIUUDBT2).
End of change