A fix is available
APAR status
Closed as program error.
Error description
NTH SHOWING INCORRECT PACKAGE INFO Near Term history shows incorrect package information when two packages with the same name, contoken and version (but different collid) are executed by a plan. ________________ ZHAFL VTM O2 V540./I DB28 09/20/07 12:51:34 2 > Help PF1 Back PF3 > H.B > Specify filter options then press ENTER to continue ================================================================ > NEAR-TERM THREAD HISTORY FILTER OPTIONS HAFL + Time of oldest available record: 09/19/2007 18:18:33.047903 + Time of latest record: 09/20/2007 12:51:31.904567 + Total number of records: 2614372 + : START-DATE/TIME = __________ _____ (mm/dd/yyyy or dd.mm.yyyy, hh:mm) : END-DATE/TIME = __________ _____ (mm/dd/yyyy or dd.mm.yyyy, hh:mm) : RELATIVE-START = 1 HOUR ago (1-nn, MINS or HOURS) : RELATIVE-END = ___ _____ from start (1-nn, MINS or HOURS) : REPORT-INTERVAL = 15 minutes ( 5-60 mins, in 5 min increments) + + Specify the values to be used to filter the Thread History displays. Wildcard + values * (multiple characters) or ? (single character) can be specified. + + The values to be used to filter at interval display level : PLAN = YCACICS : AUTHID = : CONNID = : CONNTYPE = + + The values to be used to filter only at thread detail display level : PACKAGE = : CORRID = : GETPAGES > : DEADLK/TIMEOUT > : LOCK-ESCAL > : COMMIT > : DB2-CPU-TIME > __________ ( seconds ) : DB2-ELAP-TIME > __________ ( seconds ) : IO-ELAP-TIME > __________ ( seconds ) ================================================================ ________________ ZHARP VTM O2 V540./I DB28 09/20/07 12:51:18 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: 09/20 11:50:00.000000 + Report Filtered: YES End: 09/20 12:49:59.999999 + + Dlk/ In-DB2 In-DB2 In-DB2 GetP/ + Time Thrds Commit Abort DML TOut Elap Tm CPU Tm Wait Tm Getpage RIO + ----- ----- ------ ----- ----- ---- ------- ------- ------- : _ 12:45 1444 1733 2 46K 1 107.2 17.27 86.9 540684 19.1 : _ 12:30 4687 5646 12 147K 3 365.4 55.19 300.9 1714576 19.9 : _ 12:15 5344 6207 11 159K 0 313.6 60.46 241.0 1887609 18.8 : _ 12:00 4602 5418 10 148K 0 259.7 54.68 195.2 1681120 17.8 : _ 11:50 3531 4099 8 108K 1 210.8 40.20 163.5 1249903 18.6 ================================================================ ________________ ZHAGPL VTM O2 V540./I DB28 09/20/07 12:50:55 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: 09/20 12:30:00.000000 + Report Filtered: YES End: 09/20 12:44: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 + -------- ----- ------ ---- ----- ---- ------- ------- ------- + YCACICS 4687 5646 12 147K 3 365.4 55.19 300.9 1714576 19.9 ================================================================ ________________ ZHATACT VTM O2 V540./I DB28 09/20/07 12:50:46 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: 09/20 12:30:00.000000 + Report Filtered: YES End: 09/20 12:44:59.999999 act + + Elapsed CPU Term + End Time Plan Authid Time Time SQL Commit Abrt Pkg Status + ------------ -------- -------- ------- ------ ----- ------ + 12:33:10.918 YCACICS FCZZZ20 2.79 .035 128 1 0 4 + 12:33:10.506 YCACICS FCMMG13 6.98 .062 1269 1 0 6 + 12:33:10.391 YCACICS FCPRX97 3.64 .007 64 4 0 4 + 12:33:08.231 YCACICS FCZZZ20 4.83 .057 217 1 0 4 + 12:33:08.102 YCACICS FCZZZ20 .40 .172 529 3 0 5 + 12:33:07.701 YCACICS FCZZZ20 .90 .065 197 1 0 4 + 12:33:07.331 YCACICS FCZZZ07 3.30 .027 463 1 0 1 + 12:33:06.916 YCACICS FCZZZ20 2.52 .058 212 2 0 5 + 12:33:06.748 YCACICS FCZZZ07 .25 .005 28 1 0 2 + 12:33:04.150 YCACICS FCJXH49 .05 .002 18 1 0 2 + 12:33:04.097 YCACICS FCZZZ07 7.14 .036 508 4 0 8 + 12:33:04.028 YCACICS FCZZZ07 .46 .004 26 1 0 2 + 12:33:03.569 YCACICS FCZZZ07 .00 .000 1 1 0 1 + 12:33:03.569 YCACICS FCZZZ07 4.49 .057 1067 2 0 9 + 12:33:03.527 YCACICS FCJAA04 7.39 .035 786 1 0 4 + 12:33:03.400 YCACICS FCMMG13 .00 .002 17 1 0 2 + 12:33:03.396 YCACICS FCZZZ20 2.90 .032 129 1 0 4 + 12:33:03.071 YCACICS FCPRX97 16.66 .056 1041 4 0 9 + 12:33:03.059 YCACICS FCMXH13 .24 .007 3 1 0 1 + 12:33:02.814 YCACICS FCGFC01 2.52 .038 534 1 0 2 + 12:33:00.565 YCACICS FCJBW14 6.60 .058 1137 1 0 4 + 12:33:00.495 YCACICS FCMGM09 .00 .002 17 1 0 2 + 12:33:00.492 YCACICS FCZZZ20 .18 .071 168 1 0 4 + 12:33:00.478 YCACICS FCOJS01 5.76 .072 1671 1 0 6 + 12:33:00.307 YCACICS FCMAR27 .02 .002 18 1 0 2 + 12:33:00.292 YCACICS FCMGM09 .12 .003 23 1 0 2 ________________ ZHTPKG VTM O2 V540./I DB28 09/20/07 12:49:56 2 > Help PF1 Back PF3 Up PF7 Down PF8 Zoom PF11 > 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 H-DISTRIBUTED I-BUFFER POOL J-GROUP BP > *-PACKAGE SUMMARY L-RES LIMIT M-PARALLEL TASKS ================================================================ > THREAD HISTORY PACKAGE SUMMARY HPLN + Thread: Plan=YCACICS Connid=CICS8C Corrid=ENTRKAW70022 Authid=FCMMG13 + Attach: CICS DB2=DB28 MVS=SYH1 + Time : Start=09/20/2007 12:33:03.527153 End=09/20/2007 12:33:10.506103 pkg + + Package/ SQL In-DB2 In-DB2 In-DB2 + DBRM Requests Elapsed Time CPU Time Waits Wait Time + -------- ---------- ------------ ------------ -------- ------------ + YCA705CS 3 00:00:00.008 00:00:00.001 1 00:00:00.007 + YKBV44CS 4 00:00:00.006 00:00:00.000 3 00:00:00.006 + YKBV44CS 2 00:00:00.000 00:00:00.000 0 00:00:00.000 + YKB046CS 553 00:00:00.022 00:00:00.016 8 00:00:00.003 + YCA704CS 705 00:00:00.102 00:00:00.017 3 00:00:00.082 + YCA703CS 4 00:00:00.000 00:00:00.000 0 00:00:00.000 ================================================================ ________________ ZHTPKD VTM O2 V540./I DB28 09/20/07 12:50:14 2 > Help PF1 Back PF3 Up PF7 Down PF8 ================================================================ > THREAD HISTORY PACKAGE DETAIL HPLN + Thread: Plan=YCACICS Connid=CICS8C Corrid=ENTRKAW70022 Authid=FCMMG13 + Attach: CICS DB2=DB28 MVS=SYH1 + Time : Start=09/20/2007 12:33:03.527153 End=09/20/2007 12:33:10.506103 pkd YKBV44CS + Program = YKBV44CS Type = PACKAGE Location = DB28 + Token = 1823C20700002B32 Collection = FCMAINA + + SQL Request Count = 4 + + In-DB2 Times Total + ------------------------------ ------------ + Elapsed Time 00:00:00.006 + CPU Time 00:00:00.000 + + Waits Count Total + ------------------------------ ---------- ------------ + Synchronous I/O Wait 3 00:00:00.006 + Asynchronous Read I/O Wait 0 00:00:00.000 + Asynchronous Write I/O Wait 0 00:00:00.000 + Local Lock/Latch Wait 0 00:00:00.000 + Page Latch Wait 0 00:00:00.000 + Drain Lock Wait 0 00:00:00.000 + Drain of Claims Wait 0 00:00:00.000 + DB2 Service Task Wait 0 00:00:00.000 + Archive Log Mode(Quiesce) Wait 0 00:00:00.000 + Archive Read from Tape Wait 0 00:00:00.000 + Stored Procedure Schedule Wait 0 00:00:00.000 + ------------------------------ ---------- ------------ + 3 00:00:00.006 ================================================================ . . . See pmr87253,422,000
Local fix
N/A
Problem summary
**************************************************************** * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM * * users of component: * * - Classic Interface * * - CUA Interface * **************************************************************** * PROBLEM DESCRIPTION: 1.NTH SHOWING INCORRECT PACKAGE INFO on * * ZHTPKD * * 2.NTH package name, location and collid * * show unreadable characters in UNICODE * * subsystems * **************************************************************** * RECOMMENDATION: Apply this PTF * **************************************************************** PROBLEM SUMMARY: 1.Package detail record was retrieved using package name only. 2.UNICODE package name, location and collection id are not converted correctly. PROBLEM CONCLUSION: 1.Retrieve correct package detail record using package name, collection id and connection token. 2.Display converted package name, location,collection id for UNICODE subsystem
Problem conclusion
1.Retrieve correct package detail record using package name, collection id and connection token. 2.Display converted package name, location,collection id for UNICODE subsystem KEYWORDS : INCORROUT NTH PACKAGE DETAIL ZHTPKD ZHTPKS COLLID LOCATION PKGNAME ZHPPKD
Temporary fix
Comments
APAR Information
APAR number
PK55521
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
2007-10-26
Closed date
2008-02-20
Last modified date
2008-03-03
APAR is sysrouted FROM one or more of the following:
OA22636
APAR is sysrouted TO one or more of the following:
UK33832 UK33833
Modules/Macros
KD2UTDPD KD2UTSPD KO2CNADB KO2CTHIS KO2CTHI2 KO2CTHSA KO2CTHSS KO2CTHS2 KO2CTH5A KO2CTH5S KO2CTH52 KO2CT2IA KO2CT2IS KO2CT2I2 KO2CT2SA KO2CT2SS KO2CT2S2 KO2ODINB KO2OEVCB KO2OSUBB KO2OTHDB KO2OTH3B KO2OZM2B KO2WGETB
Fix information
Fixed component name
OM XE DB2PE/PM
Fixed component ID
5655OPE00
Applicable component levels
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:
03 March 2008