Preparing CSV files

Before you can update a CICS® IA® UDB database with new data, you need to convert the VSAM files that are 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 tables:
hlq.SCIUSAMP.UDB(CIUUDB)
Prepares QSAM CSV files for all Dependency tables, including the DETAILED tables.
Note:

If you are not collecting DB2® data, you can remove step STEP050 through STEP074.

If you are not collecting MQ data, you can remove step STEP075 through STEP094.

If you are not collecting IMS™ data, you can remove step STEP095 through STEP112.

hlq.SCIUSAMP.UDB(CIUUDB4)
Prepares QSAM CSV files for the CIU_CMDFLOW_DATA and CIU_CMDFLOW_INDEX tables.
hlq.SCIUSAMP.UDB(CIUUDBAF)
Prepares QSAM CSV files for the CIU_REGION_INFO and CIU_AFF_EVENTS tables.
hlq.SCIUSAMP.UDB(CIUUDBAP)
Prepares QSAM CSV files for the CIU_APPLS_RESOURCE and CIU_APPLS_DESC tables.
hlq.SCIUSAMP.UDB(CIUUDBCS)
Prepares QSAM CSV files for the CIU_CSECT_INFO and CIU_PROGRAM_INFO tables.
hlq.SCIUSAMP.UDB(CIUUDBSD)
Prepares QSAM CSV file for the CIU_SCAN_DETAIL table.
hlq.SCIUSAMP.UDB(CIUUDBSS)
Prepares QSAM CSV file for the CIU_SCAN_SUMMARY table.

When you create CSV files by using CIUUDB, CIUUDB4 and CIUUDBAF jobs you should set the variable UDBPARM before jobs starts. The possible values are:

When you create a new CSV file for the Dependency tables, you can associate the collection by using the COLLECTION_ID column in the tables. You can use the same COLLECTION_ID for each load or select a new one, which is recommended in case of major changes in your application or environment. The CICS IA Explorer plug-in allows 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.
Note: Do not change the length of the collection ID in these samples. It must be 16 characters long.
Table 1. Relationships between the CSV files and the corresponding DB2 tables and the sample jobs that create the CSV files.
Sample Job CSV file DB2 table Comment
CIUUDB CICS.CSV CIU_CICS_DATA  
  DB2.CSV CIU_DB2_DATA  
  MQ.CSV CIU_MQ_DATA  
  IMS.CSV CIU_IMS_DATA  
  WEBSERV.CSV CIU_WEBSERV_DETAIL  
  FILE.CSV CIU_FILE_DETAIL  
  PROGRAM.CSV CIU_PROGRAM_DETAIL  
  TRANSID.CSV CIU_TRANSID_DETAIL  
  TDQUEUE.CSV CIU_TDQUEUE_DETAIL  
  TSQUEUE.CSV CIU_TSQUEUE_DETAIL  
  EXIT.CSV CIU_EXIT_INFO  
  EVENT.CSV CIU_EVENT_DETAIL  
  NATURAL.CSV CIU_NATURAL_DATA  
  REGION.CSV CIU_REGION_INFO  
  CONN.CSV CIU_CONNECTIONS  
       
CIUUDBAF REGION.CSV CIU_REGION_INFO  
  AFFINITY.CSV CIU_AFF_EVENTS  
       
CIUUDBAP APPL1.CSV CIU_APPLS_DESC  
  APPL2.CSV CIU_APPLS_RESOURCE  
       
CIUUDB4 CMDFLOW.CSV CIU_CMDFLOW_DATA  
  CMDINDEX.CSV CIU_CMDFLOW_INDEX  
       
CIUUDBCS CSPROG.CSV CIU_PROGRAM_INFO  
  CSECT.CSV CIU_CSECT_INFO  
       
CIUUDBSD SCANDET.CSV CIU_SCAN_DETAIL  
       
CIUUDBSS SCANSUM.CSV CIU_SCAN_SUMMARY