Troubleshooting
Problem
Documentation for adding new, optional DB2 indexes for WDI 3.3 management reporting PERFORM TRADING PARTNER CAPABILITY DATA EXTRACT.
Symptom
Performance of PERFORM TRADING PARTNER CAPABILITY DATA EXTRACT has degraded as between WDI 3.3 and 3.2.1.
Cause
Changes made on 3.3 for support of Management reporting for Data Transformation has degraded performance.
Resolving The Problem
Add the following new DB2 indexes via SPUFI:
- SET CURRENT SQLID='EDIENU33';
CREATE INDEX EDIENU33.EDIMRRTZ
ON EDIENU33.EDIMRRT
(TPTID ASC,
TPNICKNM ASC,
SNDRCVFL ASC,
APSNDRCV ASC,
MEASID ASC)
USING STOGROUP WDISG3
PRIQTY 1000
SECQTY 250
ERASE NO
BUFFERPOOL BP0
CLOSE NO;
CREATE INDEX EDIENU33.EDIMRSTZ
ON EDIENU33.EDIMRST
(TPTID ASC,
TPNICKNM ASC,
MEASID ASC)
USING STOGROUP WDISG3
PRIQTY 1000
SECQTY 250
ERASE NO
BUFFERPOOL BP0
CLOSE NO;
Note: Also, apply PTF UK53696 as code changes were made to provide additional relief.
[{"Product":{"code":"SSFKTZ","label":"WebSphere Data Interchange"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"WDI 3.3 z\/OS","Platform":[{"code":"PF035","label":"z\/OS"}],"Version":"3.3","Edition":"All Editions","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]
Was this topic helpful?
Document Information
Modified date:
01 August 2018
UID
swg21421813