Start of change

Migrating the DB2 tables

CICS® IA Version 5.1 provides sample jobs to migrate your CICS IA Version 3.1, or CICS IA Version 3.2 DB2® tables to CICS IA Version 5.1 tables.

There are two methods to migrate the DB2 tables.
  1. Migrate all the old CICS IA DB2 tables to a new database.
    1. You must have created the new CICS IA V5.1 tables as described in Defining the database.
      • CICS, DB2, WebSphere MQ, IMS™, Natural, and Region tables.
      • Load Module and CSECT Scanner tables.
      • Affinity tables.
      • Detailed CICS resource tables.
    2. To migrate these tables from CICS IA V3.1 or CICS IA V3.2, review and run:
      • hlq.SCIUSAMP.DB2(CIUMIG31) for CICS IA 3.1 migration.
      • hlq.SCIUSAMP.DB2(CIUMIG32) for CICS IA 3.2 migration.
  2. Migrate only the tables that have a different structure from the tables in your previous CICS IA version. This method is a single database migration method.
    1. Do not run any CICS IA 5.1 definition jobs for DB2 before you use this migration method. This migration empties your CIU_CMDFLOW_DATA table and does not use the CICS IA configurator migration settings.
    2. Ensure that your old CICS IA DB2 settings remain unchanged.
      • DB2 database for table spaces.
      • DB2 schema name, (table qualifier).
      • DB2 table owner.
    3. To migrate these tables from CICS IA V3.1 or CICS IA V3.2, review and run:
      • hlq.SCIUSAMP.DB2(CIUNMG31) for CICS IA 3.1 migration.
      • hlq.SCIUSAMP.DB2(CIUNMG32) for CICS IA 3.2 migration.
Note:

Concept Concept

Feedback


Timestamp icon Last updated: Friday, 22 November 2013


http://pic.dhe.ibm.com/infocenter/cicsts/v5r1/topic///ciuug5r.html
End of change