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 Start of change hlq.SCIUSAMP.DB2 End of change(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 Start of change hlq.SCIUSAMP.CICS End of change3(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 Start of change hlq.SCIUSAMP.DB2 End of change(CIUUDBT1).
  6. Before connecting to the Explorer, load the CIU_VERSION table. A sample LOAD task is provided in Start of change hlq.SCIUSAMP.DB2 End of change(CIUUDBT2).

Concept Concept

Feedback


Timestamp icon Last updated: Friday, 22 November 2013


http://pic.dhe.ibm.com/infocenter/cicsts/v5r1/topic///ciuug10.html