IBM Support

PI48991: DB2 ADMINISTRATION TOOL FOR Z/OS DURING CUSTOMIZATION PROCESS THE GRANT FOR PROCEDURE ADB2RCP FAILS WITH UNQUALIFIED NAME

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • DB2 Administration Tool for z/OS during customization process
    the GRANT for procedure ADB2RCP fails with unqualified name
    when running job with ADBBIND template
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of the DB2 Administration Tool for     *
    *                 z/OS and IBM Tools Customizer for z/OS.      *
    ****************************************************************
    * PROBLEM DESCRIPTION: Upon submitting the generated job       *
    *                      template ADBBIND 'Binds', the           *
    *                      following statement is not qualified    *
    *                      with the value specified for Stored     *
    *                      Procedure ADB2RCP's parameter           *
    *                      'SET CURRENT SCHEMA' from panel         *
    *                      CCQPPRD 'Product Parameters':           *
    *                                                              *
    *                      GRANT EXECUTE ON PROCEDURE              *
    *                      ADB2RCP TO PUBLIC;                      *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    Upon submitting the generated job template ADBBIND 'Binds', the
    following statement is not qualified with the value specified
    for Stored Procedure ADB2RCP's parameter 'SET CURRENT SCHEMA'
    from panel CCQPPRD 'Product Parameters':
    
    GRANT EXECUTE ON PROCEDURE ADB2RCP TO PUBLIC;
    

Problem conclusion

  • Problem has been resolved.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI48991

  • Reported component name

    DB2 ADMIN TOOL

  • Reported component ID

    568851500

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2015-09-17

  • Closed date

    2015-10-20

  • Last modified date

    2015-11-03

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

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

Modules/Macros

  •    ADB$$DSC ADB$$PRM ADB$$SEQ ADBBIND  ADBCUST
    

Fix information

  • Fixed component name

    DB2 ADMIN TOOL

  • Fixed component ID

    568851500

Applicable component levels

  • RB10 PSY UI32238

       UP15/10/23 P F510

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.

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCVQTD","label":"IBM Db2 Administration Tool for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
03 November 2015