Direct links to fixes
APAR status
Closed as program error.
Error description
Propagation of staged data from a Staging (or Authoring) environment database to a Production environment database may suffer from poor performance if the source table of data being propagated contains BLOB or CLOB column(s). Presence of LOB-type columns in a table causes the StagingProp utility to not use the JDBC batch method of data propagation when Oracle database instances are being used. This can be verified by searching the diagnostics generated by the StagingProp utility for the line: "JDBC batch won't be used by INSERT and UPDATE SQLs because of BLOB/CLOB field(s)" An example of such a table is the CATENTDESC table. This limitation has been removed for WebSphere Commerce Version 7.0 environments with Oracle 11g databases.
Local fix
Problem summary
USERS AFFECTED: WebSphere Commerce Version 7.0 StagingProp Users with Oracle 11g or Higher Databases PROBLEM ABSTRACT: Enablement of JDBC batch for LOB-type columns, i.e., BLOB, CLOB, on Oracle databases BUSINESS IMPACT: StagingProp performance (without iFix) is slower for tables with BLOB or CLOB columns RECOMMENDATION:
Problem conclusion
StagingProp code was updated to allow tables with BLOB or CLOB columns to run in JDBC batch mode to improve performance ------------------------------------------------------------- The latest available maintenance information can be obtained from the Recommended Fixes for WebSphere Commerce technote: http://www.ibm.com/support/docview.wss?rs=3046&uid=swg21261296
Temporary fix
Comments
APAR Information
APAR number
JR40347
Reported component name
WC BUS EDITION
Reported component ID
5724I3800
Reported release
700
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2011-08-10
Closed date
2011-10-28
Last modified date
2011-10-28
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
WC BUS EDITION
Fixed component ID
5724I3800
Applicable component levels
R700 PSY
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSYSYL","label":"WebSphere Commerce Enterprise"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.0","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
28 October 2011