PM96181: -ACCESS DATABASE(DSN8D11A) SPACENAM(DSN8S11P) MODE(NGBPDEP) COMPLETES NORMALLY, BUT GBP DEPENDENCE IS NOT REMOVED

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• -ACCESS DATABASE(DSN8D11A) SPACENAM(DSN8S11P) MODE(NGBPDEP)
  completes normally,  but GBP Dependance is not removed.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users of -ACCESS DB command on DB2 10    *
  *                 and 11 for z/OS                              *
  ****************************************************************
  * PROBLEM DESCRIPTION: There are 2 problems.                   *
  *                                                              *
  *                      1. DSNI048I message is missing when     *
  *                         -ACCESS DB is issued  with           *
  *                         MODE(NGBPDEP) and group bufferpool   *
  *                         dependency cannot be removed.        *
  *                                                              *
  *                      2. Subsystem termination may occur when *
  *                         -CANCEL THD is issued against a DB2  *
  *                         command executing -ACCESS DB         *
  *                         MODE(OPEN).                          *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  1. When -ACCESS DB MODE(NGBPDEP) is issued and a given
     internal request to remove the group bufferpool dependency
     fails with a RC4, DB2 will incorrectly interpret that code
     and fail to issue the required I048 message.
  
  2. When a -CANCEL THD command is issued agaist a DB2 command
     executing -ACCESS DB MODE(OPEN), there is a window where
     recovery may not be properly set up, causing a subsystem
     termination.
  

Problem conclusion

• 1. Correct DB2 code to externalize the DSNI048I message.
  
  2. Correct DB2 logic to properly reset the recovery environment
     for child tasks of the -ACCESS DB command after a cancel.
  

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:

  UI12197 UI12198

Modules/Macros

• DSNILSTS
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UI12197

     UP13/11/21 P F311 ½

• RB10 PSY UI12198

     UP13/11/21 P F311 ½

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.