PI96777: DB2 ADMIN TOOL - CM BATCH INCORRECTLY GENERATES ALTER TABLE ADD COLUMN ON GTT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When importing an ALTER TABLE ADD COLUMN statement on a global
  temporary table, AOC applies the overwrite mask "RESTRICT ON
  DROP" even though it is not valid for a GTT. Execution of the
  ALTER returns:
     SQLCODE = -526, ERROR:  THE REQUESTED OPERATION OR USAGE DOES
               NOT APPLY TO CREATED TEMPORARY TABLE table-name
  
  SQLCODEN526
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS or DB2 Object Comparison Tool for       *
  *                 z/OS.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: RESONDROP Mask causes a GTT             *
  *                      table to be altered to add RESTRICT     *
  *                      ON DROP attribute and that is not       *
  *                      valid in DB2.                           *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When analyzing a change which alters a global temp table
  (GTT) with a RESONDROP YES mask, the ALTER TABLE
  RESTRICT ON DROP statement is added to the change
  incorrectly as GTT tables can not have RESTRICT ON DROP
  attribute.
  
  Run job will result in SQLCODE -526 / SQLCODEN526:
  
  DSNT408I SQLCODE = -526, ERROR: THE REQUESTED
    OPERATION OR USAGE DOES NOT APPLY TO
    CREATED TEMPORARY TABLE >gtt_tablename<.
  

Problem conclusion

• The problem has been resolved by skipping RESONDROP
  masking for GTT tables. A new informational message will
  be issued:
  
  ADB3355I The overwrite mask RESONDROP is ignored
  because >tbname< is a global temporary table, and RESTRICT
  ON DROP is not allowed.
  Explanation: The use of masking was specified, and overwrite
  of RESTRICT ON DROP was specified but the object can not
  have this attribute because DB2 does not allow global temporary
  tables to have this attribute.
  System Action: Processing continues.
  

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:

Modules/Macros

•    ADB2MSK  ADB3000
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI56654

     UP18/06/22 P F806

• RC10 PSY UI56655

     UP18/06/22 P F806

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.