Home
User Guide
The information contained in this section applies to IBM WebSphere Commerce Version 7.0.0.9 and Feautre Pack 8. The documentation also applies to all subsequent releases and modifications until otherwise indicated in new editions.
Installing
Review this section for information about installing the WebSphere Commerce product, associated maintenance, and WebSphere Commerce enhancements.
Installing maintenance
WebSphere Commerce maintenance includes installing fix packs, interim fixes (APARs), and cumulative interim fixes.
Interim fixes and cumulative interim fixes
A WebSphere Commerce interim fix (iFix) is a software patch that contains fixes for one or more APARs. A WebSphere Commerce cumulative iFix is a comprehensive collection of interim fixes for a specific release. Both types of fixes are installed with the WebSphere Commerce Update Installer (UPDI).
Additional steps for authoring or staging-related interim fixes
Some interim fixes include changes that affect your authoring or staging environments. After you install the fix, you might need to complete additional steps to enable the fix on your environment.
Enabling interim fix JR47235
Interim fix JR47235 enhances the stagingprop utility to avoid database connection timeouts in the consolidation phase for large STAGLOG tables.

WebSphere Commerce Version 7.0.0.6

WebSphere Commerce Version 7.0.0.7

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

WCDE_installdir/schema/db2/apar/wcs.cyclic.staging.schema.sql
WCDE_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.

Fix Pack 6, JR53048.fp
Fix Pack 7, JR53048.fp.

For information about how to install an interim fix, see

Procedure

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
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