PH28693: IMPROVED TRANSACTION EXECUTION TIMES AND CONCURRENCY FOR REBIND PACKAGE

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• A DBA cannot issue REBIND of application because that could
  cause later transaction waiting and timeout on package lock.
  Even with function level 505, transactions that start slightly
  after REBIND of the package could experience performance slow
  down and even timeout on the package lock.
  Transactions can get SQLCODE -913|-911 REASON CODE 00C9008E
  TYPE OF RESOURCE 801
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Db2 12 for z/OS users of REBIND PACKAGE                      *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * A DBA cannot issue REBIND of an application package          *
  * because that could cause later transaction waiting           *
  * and timeout on the package lock.                             *
  * Even with function level 505, transactions that start        *
  * slightly after REBIND of the package could experience        *
  * performance slow down and even timeout on the package        *
  * lock.                                                        *
  * Transactions can get SQLCODE -913|-911 REASON CODE           *
  * 00C9008E TYPE OF RESOURCE 801                                *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  A DBA cannot issue REBIND of an application package because
  that could cause later transaction waiting and timeout on the
  package lock.
  Even with function level 505, transactions that start slightly
  after REBIND of the package could experience performance slow
  down and even timeout on the package lock.
  This is because REBIND requests an SIX lock on the package,
  which is incompatible with transactions requesting an S lock
  on the package.
  

Problem conclusion

Temporary fix

Comments

• A new concurrency improvement for REBIND phase-in is
  introduced.
  A REBIND of a package which can take advantage of the phase-in
  enhancement, will not attempt to acquire an SIX package lock.
  Instead it will only obtain a U lock on the package.
  This allows subsequent transactions that are executing that
  package to run in parallel because the U lock is compatible
  with a transaction's S lock.
  

APAR Information

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

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

  UI73874

Modules/Macros

• DSNGEPDL DSNTBFO1 DSNTLSUS DSNTBRB2
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI73874

     UP21/02/17 P F102

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.