PM92512: GET_CONFIG SQLCODE -805

A fix is available

Subscribe

You can track all active APARs for this component.

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 number

    PM92512

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-07-08

  • Closed date

    2013-08-09

  • Last modified date

    2013-10-03

  • 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.



Rate this page:

(0 users)Average rating

Document information


More support for:

DB2 for z/OS

Software version:

B10

Reference #:

PM92512

Modified date:

2013-10-03

Translate my page

Machine Translation

Content navigation