Enabling interim fix JR49401

Interim fix JR49401 fixes an issue where records in the CATGRPTPC table cannot be updated by using the stagingprop utility.

Seven SQL files are included:

schema/dbtype/apar/wcs.identify.dup.recs.catgrptpc.sql
schema/dbtype/apar/wcs.update.catgrptpc.storeid.trigger.sql
schema/dbtype/apar/wcs.drop.catgrptpc.storeid.trigger.sql
schema/dbtype/apar/wcs.create.stage.trigger.catgrptpc.sql
schema/dbtype/apar/wcs.drop.stage.trigger.catgrptpc.sql
schema/dbtype/apar/wcs.addcolumn.catgrptpc.sql
schema/dbtype/apar/wcs.update.staglog.catgrptpc.sql

Before you begin

Install the cumulative interim fix for Fix Pack 7, JR53048.fp.

For information about how to install an interim fix, see

Procedure

Complete the following steps in the staging environment:

Run the schema/dbtype/apar/wcs.identify.dup.recs.catgrptpc.sql SQL file.
This file gathers information about records in the CATGRPTPC table that might be incorrectly identified as duplicate records during staging propagation. By identifying these records, you can determine which records might be a source of error during staging propagation of the CATGRPTPC table.
Note: After you apply this fix, any NEW records that are added to the CATGRPTPC table will not be incorrectly identified as a duplicate record during staging propagation.
Run the schema/dbtype/apar/wcs.drop.stage.trigger.catgrptpc.sql SQL file.
This file drops the staging triggers for the CATGRPTPC table that were created by default when you set up the staging environment.
Run the schema/dbtype/apar/wcs.addcolumn.catgrptpc.sql SQL file.
This file alters the CATGRPTPC table by adding a STORE_ID_CHAR column, which holds the character value of the STORE_ID column. This file also updates existing CATGRPTPC records by populating the new column.
Run the schema/dbtype/apar/wcs.update.staglog.catgrptpc.sql SQL file.
This file updates the existing STAGLOG entries, which pertain to the CATGRPTPC table. The file populates the STAGLOG.STGKEY3NAME, STAGLOG.STGOKEY3, and STAGLOG.STGNKEY3 columns with values from the CATGRPTPC.STORE_ID_CHAR column.
Run the schema/dbtype/apar/wcs.update.catgrptpc.storeid.trigger.sql SQL file.
This file creates a trigger that populates the CATGRPTPC.STORE_ID_CHAR column whenever a new entry is added to the CATGRPTPC table.
Run the schema/dbtype/apar/wcs.create.stage.trigger.catgrptpc.sql SQL file.
This file re-creates the staging triggers for the CATGRPTPC table so that the triggers insert the value for the STORE_ID_CHAR column into the STAGLOG table.

Complete the following steps in the production environment:

Run the schema/dbtype/apar/wcs.addcolumn.catgrptpc.sql SQL file.
This file alters the CATGRPTPC table by adding a STORE_ID_CHAR column, which holds the character value of the STORE_ID column. This file also updates existing CATGRPTPC records by populating the new column.