PM57463: 1. Lock types X'2E' and X'34' not translated. 2. Missing NTH SQL text for allied threads on panel ZHTCALL.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The lock type and locked resources are not translated for lock
  types
  x'2E' - Buffer Manager Pageset RR P-LOCK
  RESID=1000002E000002D100F9002D
  
  x'34' - Point in Time Recovery Lock
  RESID=0C000034E2E8E26DD7C9E3D9
  In the above resid E2E8E26DD7C9E3D9 translates to SYS_PITR for a
  Point In Time Recovery lock
  
  The lock type is the 2 characters located in positions 7 and 8
  of the RESID
  
  ZLOCKW ZHTWAIT
  

Local fix

• apply PTF when available
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
  *                 users of component                           *
  *                 - Classic Interface                          *
  *                 - CUA Interface                              *
  *                 - TEP                                        *
  *                 - NTH - Near Term History                    *
  *                 - ATF - Application Trace Facility           *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1.                                      *
  *                      DB2 Lock types Buf. Mgr Pageset RR      *
  *                      P-lock and Sys Level PIT Recovery lock  *
  *                      are not translated correctly.           *
  *                      2.                                      *
  *                      Missing NTH SQL text for allied         *
  *                      threads on panel ZHTCALL.               *
  ****************************************************************
  * RECOMMENDATION: Apply this PTF                               *
  ****************************************************************
  PROBLEM SUMMARY:
  1. 2 new locks types are introduced by DB2: x'2E' - Buf. Mgr
  Pageset RR P-lock and x'34' - Sys Level PIT Recovery lock. The
  lock type and locked resources are not translated for these
  locks.
  2. NTH doesn't display NTH SQL text for allied threads on panel
  ZHTCALL.
  
  PROBLEM CONCLUSION:
  1. Code changed to translate lock type and locked resources for
  Buf. Mgr Pageset RR P-lock and Sys Level PIT Recovery lock.
  2. NTH code is changed to display SQL text for allied threads
  on panel ZHTCALL.
  
  KEYWORDS:
  LOCK TYPES BPPS SPRC
  NTH SQL ZHTCALL
  

Problem conclusion

• 1. Code changed to translate lock type and locked resources for
  Buf. Mgr Pageset RR P-lock and Sys Level PIT Recovery lock.
  2. NTH code is changed to display SQL text for allied threads
  on panel ZHTCALL.
  
  KEYWORDS:
  LOCK TYPES BPPS SPRC
  NTH SQL ZHTCALL
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  PM68650 UK81955

Modules/Macros

• KD2@LKRS KD2@LKTY KD2TATDD KO2APC9A KO2APC9K
  KO2APC92 KO2ARSBA KO2ARSBK KO2ARSB2 KO2ARS3A KO2ARS3K KO2ARS32
  KO2ARS5A KO2ARS5K KO2ARS52 KO2ARS8A KO2ARS8K KO2ARS82 KO2ASPFB
  KO2ASUAA KO2ASUAK KO2ASUA2 KO2ASUBA KO2ASUBK KO2ASUB2 KO2ASUDA
  KO2ASUDK KO2ASUD2 KO2ASU7A KO2ASU7K KO2ASU72 KO2ATD2B KO2ATD2H
  KO2ATD3H KO2ATVPB KO2CLKDA KO2CLKDK KO2CLKD2 KO2CNTPA KO2CNTPK
  KO2CNTP2 KO2OCKCH KO2OCKWH KO2OLOKB KO2OTHLB KO2OXTHB KO2WAITH
  KO2ZHPWA KO2ZLOCC KO2ZLOCH
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R510 PSY UK81955

     UP12/09/23 P F209

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.