PH12240: REORG FORCE ENHANCEMENT TO CANCEL IDLE THREADS.

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• REORG FORCE enhancement to cancel idle threads
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Db2 12 for z/OS users.                                   *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * When running REORG with the FORCE(ALL)                       *
  * option specified, the utility could                          *
  * fail to cancel the claimer threads                           *
  * when requesting a drain, causing a                           *
  * hang to occur.                                               *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When REORG FORCE(ALL) is specified, it will try to cancel read
  and write claimers in order to get a drain. However, if the
  claimer thread is running outside of Db2 address space, the
  cancel will not be processed until the agent is back inside Db2
  address space.
  

Problem conclusion

Temporary fix

Comments

• The fix is to modify the REORG FORCE(ALL) option to issue a
  dummy commit for idle claimer threads to allow a rebind
  request to break in, driving a hard cancel of the agent
  similar to how the -CANCEL THREAD command currently works.
  It is important to note that agents terminated in this manner
  may now abend with reason code 00C50109 instead of 00E50013.
  

APAR Information

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

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

  UI68539

Modules/Macros

• DSNB1LDN DSNB1PCK DSNB1LDA DSNVBRP  DSNB1DRA
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI68539

     UP20/03/27 P F003

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.