
Upgrade DB2 tables
You upgrade DB2 tables when you upgrade your CICS® system or change the template in the HDB, and you want to retain data in the new table format.
Before you begin
If the table that is to be upgraded contains statistics data, CICS PA needs to know which version of CICS TS or CICS TG the existing data in the table was based on. You can specify these "old" VRMs on the Export HDB Data Set panel. CICS PA will upgrade the data in the table to the current version of CICS TS or CICS TG, which it obtains from the CICS versions (VRM) fields on the Historical Database Menu.
About this task
New releases of CICS might include the addition or deletion of CICS TS and CICS TG Performance (CMF) and Statistics fields. As you migrate to a new release of CICS TS or CICS TG, you might want to redefine the DB2® tables that are loaded by CICS PA to make them compatible with the new CICS version. You might also upgrade a DB2 table if you have modified the custom HDB template that was used to export the data to DB2 and you want the table to reflect the new template definition.
This topic describes how to upgrade a DB2 table using the Export HDBs dialog. Alternatively you can use the T line action in the HDB Maintenance dialog.
Only perform this task if you want to migrate the data in the old version of the table to the new format. If you don't want to retain the old data, drop the table and then redefine it using the Export HDBs or HDB Maintenance function.
If you want to keep an existing table containing obsolete fields, instead of upgrading the table, create a new table using a template that is based on the new release.
For details of the Upgrade settings fields, see "Data Set Allocation Settings" in Define a Performance HDB. The DB2 settings fields are described in DB2 settings.
- For performance fields, refer to CMF Field IDs by CICS version.
- For statistics fields, refer to Deleted statistics fields by CICS version.
Procedure
