WebSphere Commerce Version Commerce Version

Enabling interim fix JR47235

Interim fix JR47235 enhances the stagingprop utility to avoid database connection timeouts in the consolidation phase for large STAGLOG tables.

Two SQL files are included for different databases.
  • WC_installdir/schema/db2/apar/wcs.cyclic.staging.schema.sql
  • WC_installdirschema/oracle/apar/wcs.cyclic.staging.schema.sql
For WebSphere Commerce Developer interim fixes, the files are in the following directory
  • WebSphere Commerce DeveloperWCDE_installdir/schema/db2/apar/wcs.cyclic.staging.schema.sql
  • WebSphere Commerce DeveloperWCDE_installdir/schema/oracle/apar/wcs.cyclic.staging.schema.sql

Before you begin

Install the cumulative interim fix for your fix pack level. JR47235 is included in the cumulative.


  1. If you are using a DB2 database, connect to the database and then run the /schema/db2/apar/wcs.cyclic.staging.schema.sql SQL file.
    For example,
    • db2 connect to mall user wcs using password
    • db2 -td# -vf wcs.cyclic.staging.schema.sql > wcs.cyclic.staging.schema.sql.log
  2. If you are using an Oracle database, run the /schema/oracle/apar/wcs.cyclic.staging.schema.sql SQL file.
    For example,
    • sqlplus -s wcs/password@orcl < wcs.cyclic.staging.schema.sql > wcs.cyclic.staging.schema.sql.log