IBM Support

PH31186: ALLOW REGISTERING CHANGES TO COLUMN MASKS & ROW PERMISSIONS

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as new function.

Error description

  • Allow registering a change with CREATE/ALTER statement with
    MASK/PERMISSIONS
    CREATE MASK
    ALTER MASK
    CREATE PERMISSIONS
    ALTER PERMISSIONS
    Allow registering a change with ALTER TABLE ...
    ACTIVATE/DEACTIVATE ROW/COLUMN ACCESS CONTROL
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of the Db2 Administration Tool for     *
    *                 z/OS and Db2 Object Comparison Tool for      *
    *                 z/OS.                                        *
    ****************************************************************
    * PROBLEM DESCRIPTION: Changes to column masks and row         *
    *                      permissions are not allowed to be       *
    *                      registered in Change Management (CM).   *
    ****************************************************************
    This APAR provides enhancements to allow the following changes
    to be registered in CM:
    
    CREATE and ALTER statements for MASK and PERMISSION
    ALTER TABLE ACTIVATE and DEACTIVATE ROW and COLUMN ACCESS
    CM ignores are also added for the SYSCONTROLS catalog table.
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PH31186

  • Reported component name

    DB2 ADMIN TOOL

  • Reported component ID

    568851500

  • Reported release

    C10

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2020-11-02

  • Closed date

    2020-11-23

  • Last modified date

    2020-12-01

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

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

    UI72738

Modules/Macros

  • ADB2CM3  ADB2CMS  ADB2IGN  ADBCRCR  ADBMAIN
    

Fix information

  • Fixed component name

    DB2 ADMIN TOOL

  • Fixed component ID

    568851500

Applicable component levels

  • RC10 PSY UI72738

       UP20/11/26 P F011

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.

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

Document Information

Modified date:
12 February 2021