|
Problem IT07268
|
Status: Closed |
INCORRECT RUNTIME STQ STATISTICS WITH DB2TRC -M CDE_PERF_TRACE |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
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) |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 UDB Version 10.5 Fix Pack 6 *
**************************************************************** |
| Local Fix: |
|
| Solution |
First fix in DB2 UDB Version 10.5 Fix Pack 6 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 19.02.2015
26.08.2015
26.08.2015 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.6
|
 |
