PM68353: DB2 ADMINISTRATION TOOL FOR Z/OS DOES NOT UPGRADE UID.PLAN_TABLE VERSION COL TO 122 CHAR DB2 9 NFM UT FUNCTION,FFA20 PM71813

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Administration Tool for z/OS does not upgrade uid.PLAN_TABLE
  VERSION column to 122 char in DB2 V9 NFM when using UT function
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use the 'UT - Upgrade a table to    *
  *                 current DB2 version' option on panel ADB2E   *
  *                 'Explain' to upgrade PLAN_TABLE from DB2     *
  *                 R810 to DB2 9 Compatibility Mode (CM),       *
  *                 and DB2 10 Compatibility Mode 8 (CM8).       *
  ****************************************************************
  * PROBLEM DESCRIPTION: While upgrading a PLAN_TABLE to the     *
  *                      current version (DB2 9 Compatibility    *
  *                      Mode / CM) via the 'UT - Upgrade a      *
  *                      table to current DB2 version' option    *
  *                      on panel ADB2E 'Explain', the version   *
  *                      column can not be upgraded to           *
  *                      VARCHAR(122).                           *
  *                                                              *
  *                      While upgrading a PLAN_TABLE from       *
  *                      DB2 R810 to the current version (DB2    *
  *                      10 Compatibility Mode 8 / CM8) with     *
  *                      option 'UT - Upgrade a table to current *
  *                      DB2 version' on panel ADB2E 'EXPLAIN',  *
  *                      the following informational message     *
  *                      ADB274I is displayed:                   *
  *                                                              *
  *                      ADB274I No upgrade done.                *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When upgrading the PLAN_TABLE to the current version (DB2 9
  Compatibility Mode / CM), the program is missing logic to
  update the version column to VARCHAR(122).
  
  When upgrading PLAN_TABLE from DB2 R810 to the current version
  (DB2 10 Compatibility Mode 8 / CM8), the program is failing to
  upgrade the PLAN_TABLE.
  

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:

  UK81364

Modules/Macros

•    ADB2EU
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK81364

     UP12/08/30 P F208

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.