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.

CICS® IA provides the following batch jobs that you can use for managing dependency tables:
CIUUDB
Start of change Prepares QSAM CSV files for all Dependency tables including DETAILED tables. End of change
CIUUDB4
Prepares QSAM CSV files for the CIU_CMDFLOW_DATA table.
CIUUDBAF
Prepares QSAM CSV file for the CIU_AFF_EVENTS table.
CIUUDBAP
Prepares QSAM CSV files for the CIU_APPLS_RESOURCE and CIU_APPLS_DESC tables.

When creating a new CSV file for the Dependency tables, you can associate the collection by using a new column, COLLECTION_ID, in the tables. You can use the same COLLECTION_ID for each load or select a new one (recommended in case of major changes in your application or environment). The CICS IA Explorer plug-in enables you to compare resources across COLLECTION_IDs. You can also manage your CICS IA data by COLLECTION_ID: for example, delete it from a table.


Concept Concept

Feedback


Timestamp icon Last updated: Friday, 7 February 2014


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