PH06873: IFCID 172 CONTAINS INCORRECT PROGNAME, COLLID AND CONTOKEN FOR HOLDER

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Deadlock trace IFCID 172 contains incorrect holder information.
  

Local fix

• STMTID is correct to identify the deadlock holder.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Db2 for z/OS users.                                      *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Db2 IFCID 172 records may contain                            *
  * wrong information for holder's                               *
  * PLANNAME,CORRID,CONNNAME,LUWID                               *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTF when available                          *
  ****************************************************************
  Db2 deadlock trace record in IFCID 172 may show information
  for the holder which does not match correctly with the
  actual holder's data. This may happen during a timing
  window when the holder has changed when the Deadlock Exit
  was called.
  

Problem conclusion

• This APAR changes the code in Db2 Deadlock Exit to correctly
  record the lock holder's information when it is available
  on the local member. In a situation when Db2 cannot find the
  matching information for the lock holder, it will fill the
  ifcid 172 fields QW0172HP(PLAN NAME), QW0172HR(CORRID),
  QW0172HN(CONN NAME), QW0172HL(LUWID) plus others
  with '*' meaning information not available.
  

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:

  UI70199 UI70200

Modules/Macros

• DSNTLDEA
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI70200

     UP20/07/01 P F006

• RB10 PSY UI70199

     UP20/07/01 P F006

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.