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:
- Review and edit a sample DDL provided in hlq.SCIUSMP2(CIUUDBC).
- 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:
- Run the supplied sample jobs to unload the data from the VSAM
files into CSV files. See Preparing CSV files.
- After you have created your CSV files, transfer them in ASCII
to your DB2® Windows NT Server workstation.
- 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:
- Select the INSERT option.
- Select the DELIMITER options as follows:
- The column delimiter is a comma (,).
- The character string delimiter is a double quote (").
- 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).
- 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).
- Before connecting to the Explorer, load the CIU_VERSION table.
A sample LOAD task is provided in hlq.SCIUSMP2(CIUUDBT2).