PM92512: GET_CONFIG SQLCODE -805

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• GET_CONFIG SQLCODE -805
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 11 for z/OS users of the             *
  *                 DB2-supplied stored procedure                *
  *                 SYSPROC.GET_CONFIG                           *
  ****************************************************************
  * PROBLEM DESCRIPTION: Calls to the stored procedure           *
  *                      SYSPROC.GET_CONFIG fail with the        *
  *                      following message:                      *
  *                                                              *
  *                        DSNA618I  DSNADMGC SQL ERROR DURING   *
  *                        SQL STATEMENT CALL, PROCEDURE=        *
  *                        SYSPROC.ADMIN_INFO_SSID  DSNT408I     *
  *                        SQLCODE = -805, ERROR: DBRM OR        *
  *                        PACKAGE NAME xxxx.DSNADM.DSNADMGW.    *
  *                        0E5F1F1D09F1D4F0 NOT FOUND IN PLAN    *
  *                        yyyy. ...                             *
  *                                                              *
  *                        where:                                *
  *                          xxxx is the location name           *
  *                          yyyy is the plan name               *
  ****************************************************************
  * RECOMMENDATION: APPLY PTF                                    *
  ****************************************************************
  The DBRM for DSNADMGW was not shipped with the object
  module in PM91348/UK95424, resulting in SQLCODE -805
  when GET_CONFIG is called.
  

Problem conclusion

• In response, this APAR ships DSNADMGW with its DBRM.
  

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:

  UK96585

Modules/Macros

• DSN@DMGW DSNADMGW
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RB10 PSY UK96585

     UP13/09/24 P F309

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.