A fix is available
APAR status
Closed as program error.
Error description
The PTF for this APAR has also been successful in resolving a failure to display locks when the holder (owner) and waiter are both on the same LPAR running in the same DB2. The locking conflicts screen (ZLOCKC - Option L.) does not show a conflict when the thread is waiting for a global lock. Thou global lock wait info is available on screen ZLOCKW. Screenshots while the locking conflict exists : ________________ ZALLT VTM O2 V410./C TB1B 07/27/07 8:33:53 2 > Help PF1 Back PF3 Up PF7 Down PF8 Sort PF10 Zoom PF11 > T.A > THREAD ACTIVITY: Enter a selection letter on the top line. > *-ALL B-TSO C-CICS D-IMS E-BACKGROUND F- DIST ALLIED > G-DIST DBAC H-UTIL I-INACT J-FILTER K-FUNCTIONS L- STORED PROC > M-TRIGGERS N-SYSPLEX O-ENCLAVES P- WORKSTA ================================================================ ==== =========== > ALL THREADS CONNECTED TO DB2 THDA * Elapsed Planname CPU Status GetPg Update Commit CORRID ---------- -------- ----- ------------ ------ ------ ------ -- ---------- 00:01:36.1 KO2PLAN 00.0% NOT-IN-DB2 0 0 0 O2CI 00:00:12.8 DSNESPCS 00.5% WAIT-GLBLOCK 2611 0 0 TDMWS1 ================================================================ ==== =========== ________________ ZLOCKC VTM O2 V410./C TB1B 07/27/07 8:34:10 2 > Help PF1 Back PF3 Up PF7 Down PF8 Zoom PF11 > L. ================================================================ ==== =========== > LOCKING CONFLICTS XLOK No Locking Conflicts Detected ================================================================ ==== =========== ________________ ZLOCKW VTM O2 V410./C TB1B 07/27/07 8:34:27 2 > Help PF1 Back PF3 Up PF7 Down PF8 > THREAD INFORMATION: Enter a selection letter on the top line. > A-THREAD DETAIL B-LOCK COUNTS *-LOCK WAITS D-LOCKS OWNED E- GLOBAL LOCKS > F-CURRENT SQL G-SQL COUNTS H-DISTRIBUTED I-BUFFER POOL J- GROUP BP > K-PACKAGES L-RES LIMIT M-PARALLEL TASKS N-UTILITY O- OBJECTS > P-CANCEL THREAD Q-DB2 CONSOLE D-DSN ACTIVITY S-APPL TRACE T- ENCLAVE > U-LONG NAMES ================================================================ ==== =========== > LOCKS/CLAIMS CAUSING A THREAD TO WAIT PLAN Thread: Plan=DSNESPCS Connid=TSO Corrid=TDMWS1 Authid=TDM Original Authid=TDMWS1 Attach: TSO Userid=TDMWS1 Region asid= 16K Package: DSNESM68 Collection=DSNESPCS wait Thread Is Currently Suspended Waiting To Obtain The Following Lock Type=TABL Level=IS Resource = DB=TESTDB01 PS=TESTTS01 Wait For Lock Time = 45 Seconds # to repeat lock timeout = 1 IRLM Time Out Value = 60 Seconds The Lock Being Waited On Is Not Owned By User On This DB2 ================================================================ ==== ===========
Local fix
N/A
Problem summary
**************************************************************** * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM * * users of component: * * - Classic Interface * **************************************************************** * PROBLEM DESCRIPTION: ZLOCKC Panel does not show Global Locks * * where the lock owner is on a different * * member of a data sharing group. * **************************************************************** * RECOMMENDATION: Apply this PTF. * **************************************************************** On Panel ZLOCKC if owner of lock was not found the waiter for lock was not shown. For Global Locks the owner can be on another member of the data sharing group.
Problem conclusion
Show lock waiters when lock owners are not found. KEYWORDS :(ZLOCKC LOCK CONFLICT XLOK)
Temporary fix
Comments
APAR Information
APAR number
PK53662
Reported component name
OM XE DB2PE/PM
Reported component ID
5655OPE00
Reported release
410
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2007-09-27
Closed date
2007-10-16
Last modified date
2007-11-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK30306
Modules/Macros
KO2CTHBA KO2CTHBS KO2CTHB2
Fix information
Fixed component name
OM XE DB2PE/PM
Fixed component ID
5655OPE00
Applicable component levels
R410 PSY UK30306
UP07/10/17 P F710
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":"410","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":"410","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
02 November 2007