PI16194: ABEND04E RC00E30072 AT DSNTLQRY WHEN ZPARM PKGREL_COMMIT IS ON

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ABEND04E RC00E30072 AT DSNTLQRY occurred when the zparm
  PKGREL_COMMIT is on.
  

Local fix

• Turn off zparm PKGREL_COMMIT
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 11 for z/OS users of packages bound  *
  *                 on DB2 9 with bind option                    *
  *                 RELEASE(INHERITFROMPLAN)                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: ABEND04E RC00E30072 at DSNTLQRY +0B02   *
  *                      occurred on DB2 11 when both of         *
  *                      the following were true:                *
  *                      - running package that was bound on     *
  *                        DB2 9 with bind option                *
  *                        RELEASE(INHERITFROMPLAN), and         *
  *                        its associated DB2 plan was bound     *
  *                        RELEASE(COMMIT)                       *
  *                      - DB2 11 subsystem parameter / zparm    *
  *                        PKGREL_COMMIT = YES                   *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  For a package bound with option RELEASE(INHERITFROMPLAN), when
  the package is run the RELEASE option behavior used by DB2 for
  the package is actually 'inherited' from the RELEASE behavior of
  the active DB2 plan that is associated with the package.
  The RELEASE bind option controls 'when' DB2 should release
  resources and locks that a program/package uses, either at each
  COMMIT point or when the DB2 thread/plan running the package
  terminates.
  .
  The reported DSNTLQRY ABEND04E occurred during a COMMIT or
  ROLLBACK on DB2 11 when the DB2 subsystem parameter/zparm
  PKGREL_COMMIT=YES (this is the DB2 default value) and the user
  was running a package that was bound on DB2 9 with option
  RELEASE(INHERITFROMPLAN) and its associated DB2 plan was
  bound RELEASE(COMMIT).
  The zparm PKGREL_COMMIT is DB2 11 new function enabled only for
  running packages that use RELEASE(DEALLOCATE) behavior.
  .
  The abend occurred because DB2 did not correctly 'inherit'
  the associated DB2 plan's RELEASE(COMMIT) value and apply it to
  the DB2 9 package when running it. This resulted in DB2
  using RELEASE(DEALLOCATE) behavior for the package at the COMMIT
  or ROLLBACK point which includes PKGREL_COMMIT behavior, which
  was not correct for this package so this DSNTLQRY ABEND04E then
  occurred. DB2 should have instead applied RELEASE(COMMIT)
  behavior 'inherited' from the associated DB2 plan.
  .
  To avoid the reported DSNTLQRY abend for this specific case
  of INHERITFROMPLAN and PKGREL_COMMIT=YES, you can do one of
  the following:
    - Reset zparm PKGREL_COMMIT=NO (PKGREL_COMMIT is an online
      changeable zparm without need to restart the DB2
      subsystem), or
    - REBIND the package on DB2 11
  .
  This problem with INHERITFROMPLAN does not occur for packages
  bound on DB2 10 or 11 later with RELEASE(INHERITFROMPLAN).
  .
  Note that other symptoms or errors are possible for this
  DB2 11 INHERITFROMPLAN problem with DB2 9 packages, even
  with PKGREL_COMMIT=NO.  For those cases, you need only REBIND
  the package on DB2 11 to avoid the problem.
  

Problem conclusion

• DB2 code for RELEASE(INHERITFROMPLAN) was modified to correctly
  'inherit' the associated DB2 plan's RELEASE(COMMIT) value and
  apply it to the DB2 9 package when running it.
  
  Additional search keywords: OFFSET0B02 AB04E 00E30072
  

Temporary fix

• *********
  * HIPER *
  *********
  

Comments

APAR Information

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

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

  UI18129

Modules/Macros

• DSNXEAAL DSNXELS1
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RB10 PSY UI18129

     UP14/06/04 P F406 ½

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.