PH19720: ABEND04E RC00C90101 AT DSNIDM DSNIBNRF ERQUAL5007

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ABEND04E RC00C90101 at DSNIDM DSNIBNRF ERQUAL5007
  when the package owner is a role and the catalog
  level is at V12R1M505 or higher. It also happens
  for BIND/REBIND package.
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Db2 12 for z/OS users of BIND, REBIND                    *
  * and AUTOBIND PACKAGE                                         *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Under catalog level V12R1M505 or                             *
  * higher, when the package owner was a                         *
  * role,                                                        *
  * (1) ABEND04E RC00C90101 at DSNIBNRF                          *
  * ERQUAL5007 occurred during an AUTOBIND                       *
  * PACKAGE.                                                     *
  * (2) A record with BTYPE ='L' was                             *
  * inserted into SYSIBM.SYSPACKDEP table                        *
  * with incorrect COPYID value during                           *
  * a BIND PACKAGE or REBIND PACKAGE                             *
  * command.                                                     *
  * (3) ABEND04E RC00E70005 at DSNXIDPM                          *
  * P112 occurred during a DROP ROLE                             *
  * statement.                                                   *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTF when available                          *
  ****************************************************************
  When Db2 catalog level was at V12R1M505 or higher and
  the package owner was a role,
  
  (1) An AUTOBIND PACKAGE failed with ABEND04E RC00C90101 at
  DSNIBNRF:5007.
  (2) A BIND or REBIND PACKAGE command may insert a BTYPE='L'
  record into SYSPACKDEP table with an incorrect COPYID value.
  
  (3) ABEND04E RC00E70005 at DSNXIDPM P112 occurred
  during a DROP ROLE statement.
  The above problems happened because COPYID in SYSIBM.SYSPACKDEP
  table was not set correctly when inserting a record for the
  role owner.
  

Problem conclusion

• Db2 code has been changed to correct the aforementioned
  problems.
  

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:

  UI67900

Modules/Macros

• DSNTBCM2 DSNTBAB2 DSNTBRB2
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI67900

     UP20/02/22 P F002

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.