A fix is available
APAR status
Closed as program error.
Error description
INCORRECT THREAD HISTORY DISTRIBUTED ACTIVITY No DDF Location Statistics Located For This Thread Environment: DB2 V8 1. logon Classic 2. select D for Distributed Data 3. select H for Historical 4. zoom one of the intervals 5. M - Thread History 6. zoom one of the threads 7. select H - Thread 8. got "No DDF Location Statistics Located For This Thread" 1. logon Classic 2. select H for Historical 3. select B for Thread History 4. enter / enter (Relative-start 1H agao, Report-Interval= 15 minutes) 5. select A - BY PLAN 6. zoom one of the threads 7. select H 8. got "No DDF Location Statistics Located For This Thread" FYI. ________________ ZHARP VTM O2 V540./C D81D 11/21/05 18:21:50 2 > Help PF1 Back PF3 Up PF7 Down PF8 > > Type a selection letter next to an Interval and press Enter. > > A-BY PLAN B-BY AUTHID C-BY PLAN,AUTHID D-BY AUTHID,PLAN > E-THREAD SUMMARY F-BY SUBINTERVAL ================================================================ > THREAD HISTORY BY REPORT INTERVAL HARP + Report Interval: 15 mins Start: 11/21 17:20:00.000000 + Report Filtered: NO End: 11/21 18:19:59.999999 + + Dlk/ In-DB2 In-DB2 In-DB2 GetP/ + Time Thrds Commit Abort DML TOut Elap Tm CPU Tm Wait Tm Getpage RIO + ----- ----- ------ ----- ----- ---- ------- ------- ------- ------- ----- + 18:15 No Thread Activity : _ 18:00 2 1 1 352 0 47.8 5.24 41.4 168728 799.6 : _ 17:45 1 1 0 98 0 1.2 .71 .0 5601 5601 + 17:30-17:20 No Thread Activity ________________ ZHAGPL VTM O2 V540./C D81D 11/21/05 18:22:23 3 > Help PF1 Back PF3 Up PF7 Down PF8 Zoom PF11 > > Enter a selection letter on the top line. > > *-BY PLAN B-BY AUTHID C-BY PLAN,AUTHID D-BY AUTHID,PLAN > O-OPTIONS ================================================================ > THREAD HISTORY BY PLAN HAGP + Report Interval: 15 mins Start: 11/21 18:00:00.000000 + Report Filtered: NO End: 11/21 18:14:59.999999 plan + + DLk/ In-DB2 In-DB2 In-DB2 GetP/ + Plan Thrds Commit Abrt DML TOut Elap Tm CPU Tm Wait Tm Getpage RIO + -------- ----- ------ ---- ----- ---- ------- ------- ------- ------- ----- + DISTSERV 2 1 1 352 0 47.8 5.24 41.4 168728 799.6 ________________ ZHATACT VTM O2 V540./C D81D 11/21/05 18:22:36 3 > Help PF1 Back PF3 Up PF7 Down PF8 Zoom PF11 > > Enter a selection letter on the top line. > > *-SUMMARY B-BUFFER POOL C-DB2 TIME D-LOCK/SCAN/SORT > ================================================================ > THREAD HISTORY SUMMARY HATH + Report Interval: 15 mins Start: 11/21 18:00:00.000000 + Report Filtered: NO End: 11/21 18:14:59.999999 act + + Not all detail records for this interval are present on the data set + Elapsed CPU Term + End Time Plan Authid Time Time SQL Commit Abrt Pkg Status + ------------ -------- -------- ------- ------ ----- ------ ---- --- ------ + 18:10:10.115 DISTSERV HZHOU 829.45 4.717 254 0 1 1 ________________ ZHTACT VTM O2 V540./C D81D 11/21/05 18:23:01 2 > Help PF1 Back PF3 Up PF7 Down PF8 > THREAD HISTORY: Enter a selection letter on the top line. > *-THREAD DETAIL B-LOCK COUNTS C-LOCK WAITS D-GLOBAL LOCKS E-SORT/SCAN > F-DYNAMIC SQL G-SQL COUNTS H-DISTRIBUTED I-BUFFER POOL J-GROUP BP > K-PACKAGE SUMMARY L-RES LIMIT M-PARALLEL TASKS ================================================================ > THREAD HISTORY DETAIL HPLN + Thread: Plan=DISTSERV Connid=SERVER Corrid=DB2BP.EXE Authid=HZHOU + Attach: APPLDIR DB2=D81D MVS=SYS + Time : Start=11/21/2005 17:56:20.669037 End=11/21/2005 18:10:10.115432 act + Termination Status = DEALLOC Commits = 0 + Total Elapsed Time = 00:13:49.446 Aborts = 1 + Total CPU Time = 00:00:04.717 Parallel Tasks = 0 + Total Stored Proc CPU = 00:00:00.000 + Stored Proc Wait = 00:00:00.000 Stored Proc Wait Cnt = 0 + + In-DB2 Times Total + ------------------------------ ------------ + Elapsed Time 00:00:47.041 + CPU Time 00:00:04.551 + Stored Procedure CPU Time 00:00:00.000 + + Waits Count Total + ------------------------------ ---------- ------------ + Synchronous I/O Wait 211 00:00:00.263 + Asynchronous Read I/O Wait 8498 00:00:40.932 + Asynchronous Write I/O Wait 0 00:00:00.000 ________________ ZHTRSUM VTM O2 V540./C D81D 11/21/05 18:23:14 2 > Help PF1 Back PF3 Up PF7 Down PF8 > THREAD HISTORY: Enter a selection letter on the top line. > A-THREAD DETAIL B-LOCK COUNTS C-LOCK WAITS D-GLOBAL LOCKS E-SORT/SCAN > F-DYNAMIC SQL G-SQL COUNTS *-DISTRIBUTED I-BUFFER POOL J-GROUP BP > K-PACKAGE SUMMARY L-RES LIMIT M-PARALLEL TASKS ================================================================ > THREAD HISTORY DISTRIBUTED ACTIVITY HPLN + Thread: Plan=DISTSERV Connid=SERVER Corrid=DB2BP.EXE Authid=HZHOU + Attach: APPLDIR DB2=D81D MVS=SYS + Time : Start=11/21/2005 17:56:20.669037 End=11/21/2005 18:10:10.115432 rsum + No DDF Location Statistics Located For This Thread
Local fix
N/A
Problem summary
**************************************************************** * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM V310 * **************************************************************** * PROBLEM DESCRIPTION: DDF STATISTICS ARE NOT COLLECTED * * CORRECTLY BY NEAR TERM HISTORY FOR * * DB2 VERSION 8. * **************************************************************** * RECOMMENDATION: * ****************************************************************
Problem conclusion
COLLECT DDF STATISTICS CORRECTLY IN DB2 VERSION 8. SYSMOD Title: Various forward fits Keywords: INCORROUT NTH DDF STATS NEAR TERM HISTORY ZHTRSUM
Temporary fix
Comments
APAR Information
APAR number
PK19477
Reported component name
OM XE DB2PE/PM/
Reported component ID
5655OPE00
Reported release
310
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2006-02-08
Closed date
2006-03-23
Last modified date
2006-04-05
APAR is sysrouted FROM one or more of the following:
OA14372
APAR is sysrouted TO one or more of the following:
Modules/Macros
DUMM1KO2
Fix information
Fixed component name
OM XE DB2PE/PM/
Fixed component ID
5655OPE00
Applicable component levels
R310 PSN UK13001
UP06/03/29 P F603
Fix is available
Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSAV2B","label":"IBM Db2 Buffer Pool Analyzer for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"310","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCT4H5","label":"IBM Tivoli OMEGAMON XE for Db2 PE \/ PM \/ BPA"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"310","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
05 April 2006