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.SCIUSAMP.DB2(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.SCIUSAMP.CICS3(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.SCIUSAMP.DB2(CIUUDBT1).
Before connecting to the Explorer, load the CIU_VERSION table.
A sample LOAD task is provided in hlq.SCIUSAMP.DB2(CIUUDBT2).
Preparing CSV files
Before you can update a non-DB2 database with new data,
you need to convert the VSAM files created by the Collector to the
QSAM flat files or, in other words, Comma Separated Values (CSV) files.