WebSphere Commerce Version 7.0.0.8

Enabling interim fix JR54071

Interim fix JR54071 provides a faster catalog service to return specific attributes instead of all attributes for a catalog entry.

Before you begin

Currently, this fix is available for Fix Pack 8 only. Ensure that the latest cumulative interim fix is installed:

Install the interim fix for JR54071.

About this task

Interim fix JR54071 provides a new command, InsertMoreCatalogEntryClassicAttributesDataCmdImpl. To use the command, you must update your access control policies.

Procedure

  1. Ensure that the following files are in your WC_installdir\xml\policies\xml folder.
    • JR54071CatalogAccessControlPolicies.xml
    • JR54071CatalogAccessControlPolicies_en_US.xml
  2. Run the acpload utility on the JR54071CatalogAccessControlPolicies.xml file.
    For example, from the WC_installdir\bin directory, run the following command.
    Platform Command
    SolarisLinuxAIXFor IBM i OS operating system ./acpload.sh mall dbuser dbusrpwd JR54071CatalogAccessControlPolicies.xml
    WindowsDB2 database acpload mall dbuser dbusrpwd JR54071CatalogAccessControlPolicies.xml
    WindowsOracle database acpload mall dbuser dbusrpwd JR54071CatalogAccessControlPolicies.xml schema
    WebSphere Commerce DeveloperDerby database acpload JR54071CatalogAccessControlPolicies.xml
    For more information about the acpload utility, see acpload utility.
  3. Run the acpnlsload utility on the JR54071CatalogAccessControlPolicies_en_US.xml file.
    For example, from the WC_installdir\bin directory, run the following command.
    Platform Command
    SolarisLinuxAIXFor IBM i OS operating system ./acpnlsload.sh mall dbuser dbusrpwd JR54071CatalogAccessControlPolicies_en_US.xml
    WindowsDB2 database acpnlsload mall dbuser dbusrpwd JR54071CatalogAccessControlPolicies_en_US.xml
    WindowsOracle database acpnlsload mall dbuser dbusrpwd JR54071CatalogAccessControlPolicies_en_US.xml schema
    WebSphere Commerce DeveloperDerby database acpnlsload JR54071CatalogAccessControlPolicies_en_US.xml
    For more information about the acpnlsload utility, see acpnlsload utility.
  4. Insert a new row in the CMDREG table.
    1. Connect to your database.
    2. Run the SQL commands that are in the WC_installdir/schema/common/apar/wcs.insert.classic.attributes.command.sql file.