IBM Support

PI74538: DB2 ADMIN TOOL TA (AND VA) OPTION IS NOT ACCEPTED ON THE CM MANAGE EXCLUDE SPECIFICATIONS PANEL ADBPC7L

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • According to the DB2 Admin User's Guide and Help panel, the
    exclude option TA (Table Authorization) may be used to exclude
    table authorizations from being processed by CM. This option
    is not accepted on the exclude spedification panel and returns
       Invalid value
    
    The same is true for VA (View authorization).
    
    This APAR will provide support for TA & VA.
    

Local fix

  • n/a
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of the DB2 Administration Tool         *
    *                 for z/OS.                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION: Panel ADBPC7L, 'Exclude Objects',       *
    *                      is missing support for authorizations   *
    *                      types for table and view.               *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    Panel ADBPC7L, 'Exclude Objects', has limited support for
    authorizations. When TA is specified as an object type, an
    message is displayed:
    
    ADB338E Valid values are AL, CA, DB,
    DT, FU, GV, IX, PK, PL, RL, SC, SG,
    SP, SQ, SY, TB, TG, TS, VW
    
    This APAR adds support for authorization types on panel
    ADBPC7L:
    
     TA - Table authorization
     VA - View authorization
    
    msgADB338E
    

Problem conclusion

  • Panel ADBPC7L, 'Exclude Objects', is enhanced to support
    authorizations types for table and view.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI74538

  • Reported component name

    DB2 ADMIN TOOL

  • Reported component ID

    568851500

  • Reported release

    B20

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-01-09

  • Closed date

    2017-12-12

  • Last modified date

    2018-01-03

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

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

    UI52631 UI52632

Modules/Macros

  •    ADBEC7E  ADBEC7L  ADBHC7AT ADBHC7L  ADBHC7RL
    ADBPC7AT ADBPC7L  ADBPC71
    

Fix information

  • Fixed component name

    DB2 ADMIN TOOL

  • Fixed component ID

    568851500

Applicable component levels

  • RB20 PSY UI52631

       UP17/12/14 P F712

  • RC10 PSY UI52632

       UP17/12/14 P F712

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.2.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
03 January 2018