PI22232: ALTPART ON PANEL ADB27C GENERATES ERROR LIMIT KEY VALUES ARE NOT IN PROPER ASCENDING OR DESCENDING ORDER

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Administration Tool for z/OS issues error message
  Limit key values are not in proper ascending or descending order
  when issuing ALTPART on Panel ADB27C
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who make a change to the limit key      *
  *                 values of a partitioned table space.         *
  ****************************************************************
  * PROBLEM DESCRIPTION: When using the ALTPART line command     *
  *                      on panel ADB27C 'ALTER Table' to        *
  *                      alter a partition of a table-based      *
  *                      partitioned table, DB2 Admin issues     *
  *                      a warning message ADB448W / msgadb448w: *
  *                                                              *
  *                      "Limit key values are not in proper     *
  *                      ascending or descending order."         *
  *                                                              *
  *                      Problem may happen when the             *
  *                      partitioning column is either           *
  *                      DECIMAL, INTEGER, SMALLINT or BIGINT    *
  *                      and the limit key value of the          *
  *                      changed partition has less digits in    *
  *                      the integer part of the number than     *
  *                      the other partitions.                   *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When using the ALTPART line command on panel ADB27C 'ALTER
  Table' to alter a partition of a table-based partitioned
  table, DB2 Admin issues a warning message ADB448W /
  msgadb448w:
  
  "Limit key values are not in proper ascending or descending
  order."
  
  Problem may happen when the partitioning column is either
  DECIMAL, INTEGER, SMALLINT or BIGINT and the limit key value
  of the changed partition has less digits in the integer
  part of the number than the other partitions.
  

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:

  UI20900 UI20901

Modules/Macros

•    ADB27AP
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UI20900

     UP14/08/29 P F408

• RB10 PSY UI20901

     UP14/08/29 P F408

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.