PH26292: DB2 ADMIN TOOL: THE SEQUENCE OF TWO DEPENDING RENAME COLUMN STATEMENTS IS SWITCHED IN AOC, EXECUTION FAILS WITH A -601

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Db2 Administration Tool:
  
  The sequence of two dependent rename column statements,
  referring to the same table, is switched during generation of
  the WSL.  The execution of the change then fails with a -601
  SQLCODE due to the wrong sequence of the statements. The
  statements are originally provided in a way that would allow
  execution of the dependent rename first.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Object Comparison Tool for  *
  *                 Z/OS who save their compare results.         *
  ****************************************************************
  * PROBLEM DESCRIPTION: When user specifies change statements   *
  *                      for renaming dependent columns          *
  *                      correctly, Admin Tool switches the      *
  *                      statements to be processed in order of  *
  *                      columns in the table. Thereby not       *
  *                      renaming dependent columns first.       *
  *                                                              *
  *                      For example, the two alters are added   *
  *                      in this order:                          *
  *                                                              *
  *                      ALTER TABLE T1                          *
  *                      RENAME COLUMN C1 to C1_NEW;             *
  *                      ALTER TABLE T1                          *
  *                      RENAME COLUMN C1_OLD TO C1;             *
  *                      The order of the alters ends up         *
  *                      switched, so when                       *
  *                      ALTER TABLE T1                          *
  *                      RENAME COLUMN C1_OLD TO C1;             *
  *                      is run first, it fails with an          *
  *                      sqlcode -601 as column C1               *
  *                      still exists.                           *
  ****************************************************************
  Admin Tool processes rename statements in the incorrect order
  when analyzing rename statements provided in the correct order.
  

Problem conclusion

• The issue 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:

  UI71454

Modules/Macros

• ADB2CMT
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI71454

     UP20/10/01 P F009

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.