DB2 FOR LUW / DB2FORLUW / A50 - DB2

Collecting performance trace for CDE queries with db2trc -M 
CDE_PERF_TRACE generates incorrect runtime STQ statistics. The 
problem exists in V10.5FP5 only. 
 
For example this query takes 99s total to execute, these STQs 
are collected: 
 
        STQ: "CQWCOL"."DATE_DIM":262148:A2 
        RuntimeStats: SCAN:4929.00/72(19) SCAN-POST:2.00/0(1) 
PREF:30955.00/72(27) PREF_SUCCESS:30237.00/1(1) 
CKRS:1742.00/72(2) PREF:83.00/72(27) LEAF.RI4:309483.00/72(2) 
LEAF_PRED.RI4:67.00/72(3) WHER:57.00/72(2) PREF:30.00/72(27) 
LEAF.RI4:14121.00/72(2) LEAF_PRED.RI4:18.00/72(3) 
WHER:13.00/72(2) PREF:22.00/45(27) LCOV.I8:129708.00/45(2) 
LCOV_UNK.I8:50656.00/45(3) LCOV_SLOAD.I8:50696.00/48(3) 
PREF:28.00/45(27) LCOV.I8:144.00/45(2) LCOV_UNK.I8:58.00/45(3) 
LCOV_SLOAD.I8:66.00/48(3) BTSN:3344177.00/45(2798) 
PREF:8094.00/46080(2799) PREF_SUCCESS:103.00/1(1) 
CKRS:52505.00/46080(13) PREF:4945.00/46080(2800) 
PREF_SUCCESS:92.00/1(1) LEAF.RI4:116566.00/46080(13) 
LEAF_PRED.RI4:905.00/46080(15) WHER:276.00/46080(13) 
PREF:4305.00/46079(2800) LEAF.RI4:3994.00/46079(13) 
LEAF_PRED.RI4:689.00/46080(15) WHER:174.00/46079(13) 
PREF:3872.00/36523(2812) PREF_SUCCESS:67.00/1(1) 
LCOV.I4:242978.00/36523(12) LCOV_SLOAD.I4:1176.00/36568(30) 
ENPK:17682.00/36523(12) CCAT:15655.00/36523(12) 
HASH:921.00/36523(12) BJF.18:622.00/36523(12) 
BJF-POST.18:537.00/0(17) SURR:15.00/36523(12) 
PREF:4799.00/36523(2828) LCOG.I4:6762.00/36523(12) 
LCOG_SLOAD.I4:86.00/1832(4) ENAX.I4:511.00/36523(12) 
CCAT:7064.00/36523(12) PART:109189.00/36523(2828) 
BHT.630KB:48.00/36523(12) BHT-POST.630KB:513895.00/36523(17) 
EvalOther:77445.00/72(16) Eval:5128743.00/72(16) 
BOUNDARY:100395.00/0(32) FormEval:75110.00/0(1) 
CloneEval:39991.00/0(16) PostProc:954485.00/72(16) 
WallClock:748991.00/0(1) 
 
        STQ: "CQWCOL"."STORE_SALES":917508:A1 
        RuntimeStats: SCAN:9432.00/1687478(841) 
SCAN-POST:2.00/0(1) PREF:195385.00/1687478(950) 
PREF_SUCCESS:7829726.00/175(122) CKRS:245414.00/1687478(462) 
PREF:21994.00/1687478(971) PREF_SUCCESS:1895864.00/46(33) 
LEAF.RI4:516021.00/1687478(362) 
LEAF_PRED.RI4:3698.00/1687478(825) WHER:6136.00/1687478(362) 
PREF:15159.00/1687478(985) PREF_SUCCESS:933193.00/191(38) 
LEAF.RI4:294880.00/1687478(238) 
LEAF_PRED.RI4:50962.00/1687478(871) WHER:7397.00/1687478(264) 
PREF:22024.00/1687478(1101) PREF_SUCCESS:5410355.00/686(80) 
LCOV.I8:662774.00/1687478(78) LCOV_UNK.I8:14.00/607(1) 
LCOV_SLOAD.I8:46390.00/1688476(1156) PREF:1852.00/1687478(1101) 
LCOV.I8:94560.00/1687478(78) LCOV_UNK.I8:78.00/607(1) 
LCOV_SLOAD.I8:34380.00/1688476(1156) 
BTSN:490549.00/1687478(52801) 
PREF:112785275.00/1727976454(136573) 
PREF_SUCCESS:251616313.00/40571(13148) 
PREF_TIMEOUT:1214985.00/54(17) CKRS:8356431.00/1727976454(11457) 
PREF:2031456.00/1727976454(136976) 
PREF_SUCCESS:249757684.00/84102(4160) 
PREF_TIMEOUT:200466.00/105(7) 
LEAF.RI4:16228239.00/1727976454(13236) 
LEAF_PRED.RI4:9180573.00/1727976454(129774) 
WHER:551351.00/1727976454(52735) 
PREF:290629.00/656460434(185761) 
LCOG.I4:14570292.00/656460434(52735) 
LCOG_SLOAD.I4:6370889.00/519646424(102737) 
CCAT:366245.00/656460434(52735) HASH:6446965.00/656460434(52735) 
JFLT.18:211371.00/35118154(2821)[621342280] 
WHER:23719.00/35118154(2821)[621342280] 
SURR:71716.00/656460434(52735) GJP:38892890.00/656460434(52735) 
PREF:3835025.00/656460434(186256) 
PREF_SUCCESS:589808817.00/183565(13077) 
PREF_TIMEOUT:636651.00/234(16) 
LCOG.I4:41412092.00/656460434(11266) 
LCOG_SLOAD.I4:8465399.00/546764184(406577) 
EXTR:11887447.00/656460434(26542) 
CCAT:20381344.00/656460434(26542) 
HASH:8469974.00/656460434(26542) 
PREF:1889866.00/656460434(202472) 
PREF_SUCCESS:187487768.00/63903(6569) 
PREF_TIMEOUT:435207.00/39(4) LCOV.I4:30382498.00/656460434(6727) 
LCOV_SLOAD.I4:7409439.00/520485480(83769) 
CAST:14817141.00/656460434(26395) 
LGHT.E1U1P1:255687513.00/656460434(222393) 
LGHT-POST.E1U1P1:133498632.00/15564108(1002) 
LGHT_EMERGE:53236654.00/429680640(243707) 
LGHT_VECT:10854895.00/15564108(64) 
SUM.D2:18288721.00/656460434(42239) 
EvalOther:12273832.00/1687478(16) Eval:852139943.00/1687478(16) 
BOUNDARY:95905700.00/0(16) FormEval:8016.00/0(1) 
CloneEval:18613.00/0(16) ConsumeWait:74013785.00/0(56) 
PostProc:236766145.00/1687478(16) WallClock:55575004.00/0(1)

**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 UDB Version 10.5 Fix Pack 6                   * 
****************************************************************

First fix in DB2 UDB Version 10.5 Fix Pack 6

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

19.02.2015
26.08.2015
26.08.2015