PI50737: DB2 ADMIN TOOL COLUMN RE-ORDER DEACTIVATES COLUMN ACCESS CONTROL

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• A Work Statement List to re-order columns on a table where the
  table had DB2 Column Access Control defined and activated.
  The job that was generated to change the table, which required
  a Drop/Create of the table had every step it should have
  including the Drop and Create of the Mask for column
  security. However, it did not the Alter to Activate Column
  Access Control.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool         *
  *                 for z/OS who alter a table.                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: A table has Column Access Control       *
  *                      defined and activated. When the         *
  *                      table is dropped and recreated,         *
  *                      DB2 Admin Tool does not activate        *
  *                      the Column Access Control.              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  A table has Column Access Control defined and activated.
  When the table is dropped and recreated, DB2 Admin Tool
  does not activate the Column Access Control.
  

Problem conclusion

• Problem has been resolved.
  

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:

  UI37468 UI37469

Modules/Macros

•    ADB2CMT
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB10 PSY UI37468

     UP16/05/05 P F605

• RB20 PSY UI37469

     UP16/05/05 P F605

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.