
Update the CICS IA UDB database
When a CICS® IA UDB database is created, you can load the data.
To load the data to the database, follow these steps:
- Run the supplied sample jobs to unload the data from the VSAM files into CSV files. For more information about CSV files, see Preparing CSV files.
- When the CSV files are created, transfer them in ASCII to your DB2® Windows workstation.Note:
- The transfer of these files might create a blank line at the end of each file. If the blank line remains at the end of each file, a warning is issued during the create or load process. It is recommended that you edit and remove the last line if required.
- Depending on the method you use, you might need to uncomment the CONNECT statement in the following samples.
- The DB2 command IMPORT must be used to load data from CSV files into the tables.
- Load data from CSV files into the tables.
- Create and edit load.in file:
CONNECT TO _udbname_; SET SCHEMA _udbqual_; import from affinity.csv of del insert into _udbqual_.CIU_AFF_EVENTS; import from appl1.csv of del insert into _udbqual_.CIU_APPLS_DESC; import from appl2.csv of del insert into _udbqual_.CIU_APPLS_RESOURCE; import from cics.csv of del insert into _udbqual_.CIU_CICS_DATA; import from cmdflow.csv of del insert into _udbqual_.CIU_CMDFLOW_DATA; import from cmdindex.csv of del insert into _udbqual_.CIU_CMDFLOW_INDEX; import from conn.csv of del insert into _udbqual_.CIU_CONNECTIONS; import from csect.csv of del insert into _udbqual_.CIU_CSECT_INFO; import from csprog.csv of del insert into _udbqual_.CIU_PROGRAM_INFO; import from db2.csv of del insert into _udbqual_.CIU_DB2_DATA; import from event.csv of del insert into _udbqual_.CIU_EVENT_DETAIL; import from exit.csv of del insert into _udbqual_.CIU_EXIT_INFO; import from file.csv of del insert into _udbqual_.CIU_FILE_DETAIL; import from ims.csv of del insert into _udbqual_.CIU_IMS_DATA; import from mq.csv of del insert into _udbqual_.CIU_MQ_DATA; import from natural.csv of del insert into _udbqual_.CIU_NATURAL_DATA; import from program.csv of del insert into _udbqual_.CIU_PROGRAM_DETAIL; import from region.csv of del insert into _udbqual_.CIU_REGION_INFO; import from scandet.csv of del insert into _udbqual_.CIU_SCAN_DETAIL; import from scansum.csv of del insert into _udbqual_.CIU_SCAN_SUMMARY; import from tdqueue.csv of del insert into _udbqual_.CIU_TDQUEUE_DETAIL; import from transid.csv of del insert into _udbqual_.CIU_TRANSID_DETAIL; import from tsqueue.csv of del insert into _udbqual_.CIU_TSQUEUE_DETAIL; import from webserv.csv of del insert into _udbqual_.CIU_WEBSERV_DETAIL; COMMIT;
If you are loading the scanner tables, then delete all of the records that are related to the scanned libraries by using the following SQL code:
CONNECT TO _udbname_; SET SCHEMA _udbqual_; DELETE FROM _udbqual_.CIU_CSECT_INFO WHERE DSNAME = 'DSNAME'; DELETE FROM _udbqual_.CIU_PROGRAM_INFO WHERE DSNAME = 'DSNAME'; DELETE FROM _udbqual_.CIU_SCAN_DETAIL WHERE DSNAME = 'DSNAME'; DELETE FROM _udbqual_.CIU_SCAN_SUMMARY WHERE DSNAME = 'DSNAME'; COMMIT;
- Use the DB2 command line processor: db2 -td; -vf load.in > load.out
- Create and edit load.in file:
- When some dependency tables are loaded, reload the CIU_RESOURCE
table that is used by the CICS Explorer®.
- Review and edit the sample CIUUDBT3.
- Use the DB2 command line processor: db2 -td; -vf CIUUDBT3 > CIUUDBT3.out
- For affinity collection, run the CIUSPAFF stored procedure to
load the affinity tables that are used by the CICS Explorer.
- Review and edit the sample CIUUDBT4.
- Use the DB2 command line processor: db2 -td; -vf CIUUDBT4 > CIUUDBT4.out
- To provide the relationships between file resources, the regions that own these resources, and
correspondent data sets, run the CIUSPRMF stored procedure.
- Review and edit the sample CIUUDBT5. The parameter _collid_ must be the actual value of collection ID.
- Use the DB2 command line processor: db2 -td; -vf CIUUDBT5 > CIUUDBT5.out
- To identify Application entry points, run the CIUSPPCP stored procedure to reload
the CIU_CICS_CHAINP table by collection ID.
- Review and edit the sample CIUUDBT6. The parameter _collid_ must be the actual value of collection ID.
- Use the DB2 command line processor: db2 -td; -vf CIUUDBT6 > CIUUDBT6.out.
