Interim fix JR47901 stages the INVCNFREL and INVCNF database tables for DOM inventory
systems. After you complete this procedure, you can see the inventory count from the storefront.
Before you begin
Install the cumulative interim fix for Fix Pack 6, JR53048.fp.For information about
how to install an interim fix, see
Procedure
-
Create staging triggers. Complete this step on the staging server only.
- For DB2 or OS400: Connect to the WebSphere Commerce database, and then
run the following SQL
file:
db2 -td# -vf WC_installdir\schema\db2\apar\wcs.create.stage.trigger.invcnf.sql >> createTriggers.log
- For Oracle: Run the following SQL file:
sqlplus -s %user%/%password%@%database% < WC_installdir\schema\oracle\apar\wcs.create.stage.trigger.invcnf.sql>> createTriggers.log
- %user%: The Oracle user name, for example wcs1
- %password%: The Oracle user password, for example wcs1
- %database%: The database name, for example ORCL
-
Check the log files to ensure that the SQL commands executed successfully.
-
Create the staging table record on both staging and production servers.
- For DB2 or OS400: Connect to the WebSphere Commerce database, and then
run the following SQL
file:
db2 -tvf WC_installdir\schema\db2\apar\wcs.insert.stgmertab.invcnf.sql >> insertStgmertab.log
- For Oracle: Run the following SQL file:
sqlplus -s %user%/%password%@%database% < WC_installdir\schema\oracle\apar\wcs.insert.stgmertab.invcnf.sql >> insertStgmertab.log
- %user%: The Oracle user name, for example wcs1
- %password%: The Oracle user password, for example wcs1
- %database%: The database name, for example ORCL
-
Check log files to ensure that the SQL commands executed successfully.