A fix is available
APAR status
Closed as program error.
Error description
This APAR provides a better-performing StagingProp utility that will reduce the number of database connections, execute better optimized SQL and provide faster consolidation of records in the STAGLOG table. A new summary report is also added to indicate the number of records, by table, that were processed, with breakdowns by type of transaction (Insert/Update/Delete). This new report will help the IT staff to better understand the impact of the business user traffic on the staging processes.
Local fix
Problem summary
USERS AFFECTED: IT staff who run StagingProp to propagate data from staging database to production database who are either unable to complete the staging propagation within their maintenance window or perform adequate problem determination using just the StagingProp log information. PROBLEM ABSTRACT: StagingProp requires some additional performance enhancements and better error handling. BUSINESS IMPACT: Staging propagation (copying from the staging database to the production database) operates on the STAGLOG table, which tracks the Create/Update/Delete activity against the database tables. This operation consists of consolidation of records to reduce volume of activity, and the propagation of those changes. When there are a large number of changes being made, leading to a large number of records in the STAGLOG table, the StagingProp utility takes a long time to complete each of theses phases. RECOMMENDATION:
Problem conclusion
This update is focused on 3 main areas within StagingProp. 1. Performance improvement - Reduced number of database I/O operations by increasing the number of records fetched at a time - Added a database index on the STAGLOG table to improve fetch performance 2. Better error toleration for consolidation with Action On Error support for operations on the same record: - Deletion followed by Update - Deletion followed by Deletion - Insertion followed by Insertion - Update followed by Insertion 3. Provide support for cyclic reuse of unique keys by adding support through additional column UPDATABLE_UK_COL in tables STGSITETAB and STGMERTAB. 4. Additionally, to ease problem determination, distinct-value exit codes from invocation of the utility are being made available. These exit codes may be used to categorize severity of error(s) in question and to determine the phase of the utility at which error(s) were encountered. An exit code of 0 indicates a successful execution. An exit code other than 0 is an indication of an error encountered by the utility. Refer to the log file generated by the utility for more diagnostic information if a non-zero exit code is issued by the utility. ------------------------------------------------------------- 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
JR42158
Reported component name
WC BUS EDITION
Reported component ID
5724I3800
Reported release
700
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
YesSpecatt / New Function
Submitted date
2012-03-06
Closed date
2012-07-27
Last modified date
2012-08-01
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:
01 August 2012