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.