APAR status
Closed as program error.
Error description
Sharding uses two types of shards, vertical and horizontal shards. Each horizontal shard processes a subset of the catalog (for example, catentry_id 1 - 100,000), all together making up the entire catalog. A vertical shard contains the entire catalog, and is needed for catalog data that has dependencies on other catalog data (for example, catalog hierarchy data). If only horizontal shards are used, then the data included in the vertical shard needs to also be generated within each horizontal shard. As of v9.0.0.6, only using horizontal shards will allow sharding to complete successfully. If you include a vertical shard, the indexing part of sharding process fails as it's incorrectly looking for this dependency data (that is in the vertical shard) inside of the horizontal shards.
Local fix
Problem summary
USERS AFFECTED: 9.0.0.3 ~ 9.0.0.6 PROBLEM ABSTRACT: Parallel processing (sharding) failing when using vertical shard BUSINESS IMPACT: Customers who have migrated from V8 with Vertical sharding will not be able to use this feature without this fix. RECOMMENDATION:
Problem conclusion
Brought back V8's capability and leveraged newly added Global Initial to avoid duplicate preprocessing of temporary tables.
Temporary fix
Comments
APAR Information
APAR number
JR59872
Reported component name
WC BUS EDITION
Reported component ID
5724I3800
Reported release
900
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2018-08-08
Closed date
2018-10-29
Last modified date
2018-10-29
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
[{"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":"9.0","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
29 October 2018