PI16851: ABEND04E RC00C90101 AT LOCATION DSNGDCID 5002 ERQUAL5002 ON CREATE DATABASE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Abend04e rc00c90101 at location dsngdcid 5002 erqual5002 on
  create database
  The problem is that dbid still being referenced is trying to be
  reused by create database
  Sanity check is not skiping it and finding the next available
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users who drop and then create a database in *
  *                 datasharing environment                      *
  ****************************************************************
  * PROBLEM DESCRIPTION: When creating a database, customer      *
  *                      could receive ABEND04E DSNGDCID         *
  *                      ERQUAL5002.                             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  In a datasharing environment, after drop database A and
  committing the drop on sub-system 1, the internal database id
  is marked as re-useable. When create database B on another
  sub-system 2, the internal database id is picked up and
  sub-system 2 has reference to database A, the above abend
  could be hit.
  

Problem conclusion

• DB2 has been changed to not reuse the internal database id
  if there is still a reference to the DBD associated with this
  internal database id to avoid the abend.
  
  If the abend is hit, try to create the database later on
  should be successful.
  

Temporary fix

Comments

• ž**** PE15/07/20 FIX IN ERROR. SEE APAR PI45224  FOR DESCRIPTION
  

APAR Information

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

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

  UI18155 UI18156

Modules/Macros

• DSNGDCID
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UI18155

     UP14/06/06 P F406

• RB10 PSY UI18156

     UP14/06/06 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.