Direct links to fixes
APAR status
Closed as program error.
Error description
The dataload utility and catalog upload feature make use of the ID resolver cache. When the ID resolver cache is full, the logic resolves the ID directly from the database. However, the Oracle database may not rebuild the table's index automatically after loading many rows into the table, so it becomes very slow until the index is rebuilt.
Local fix
Problem summary
USERS AFFECTED: WebSphere Commerce users with Oracle database using the dataload utility or catalog upload feature. PROBLEM ABSTRACT: The dataload utility and catalog upload feature slow down dramatically when the ID resolver cache is full when using an Oracle database. The index is not rebuilt automatically by the database, so the queries are slower. BUSINESS IMPACT: The dataload utility and catalog upload feature may become slow when a large number of entries are being loaded, exceeding the allocated size for the ID resolver cache, causing delays in loading the data. The storefront performance is not affected by this issue. RECOMMENDATION:
Problem conclusion
The ID resolver logic is updated to issue statements to update the table index statistics (analyze table xxx compute statistics) when the cache becomes full, so that the performance for the direct queries will be faster. ------------------------------------------------------------- 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
JR45717
Reported component name
WC BUS EDITION
Reported component ID
5724I3800
Reported release
700
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
YesSpecatt / Installability
Submitted date
2013-02-12
Closed date
2013-05-13
Last modified date
2013-05-13
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:
13 May 2013