Interim fix JR47728 improves the performance of Promotion Code Generation by using the
Oracle DML Error Log feature that is found in Oracle 10.2 or higher. This APAR requires the creation
of a new table that must be run on Oracle only. If the table does not exist, WebSphere Commerce uses
the generic method for generating promotion codes. Run this procedure on the staging environment
only, as that is where promotion codes are generated.
Before you begin
Install the cumulative interim fix for Feature Pack 5, JR53048.fep.For information about
how to install an interim fix, see
Procedure
-
Locate the database table creation file. The file might reside in one of the following
paths:
- WC_installdir/schema/oracle/apar/wcs.schema.px_cdpool_error.sql
or
WC_installdir/components/foundation/schema/fep5/apar/wcs.schema.px_cdpool_error.sql
- WCDE_installdir/schema/oracle/apar/wcs.schema.px_cdpool_error.sql
or
WCDE_installdir/components/foundation/schema/fep5/apar/wcs.schema.px_cdpool_error.sql
-
Run the file to create the database table.
For example, enter the following commands
- sqlplus -S
[username]/[password]@[connection-spec]
- @[WC_installdir]/schema/oracle/apar/wcs.schema.px_cdpool_error.sql;
- quit;
- [username] refers to the username that is authorized to create objects on the
appropriate schema
- [password] refers to the password for [username]
- [connection-spec] refers to the SID or TNS service-name or expanded
service-name of the WebSphere Commerce Oracle instance
- If the schema that is associated with tables in the database is not the default ([username]) in
most cases, you might need to invoke a schema change. For example, to change the schema name