PH17676: ADMIN TOOL ALTER PARTITION ADD PARTITION TABLE LIMIT KEY MINVALUE MAXVALUE SQLCODE = -20385 SQLCODEN20385

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• A run job which involves altering partition keys, and adding a
  partition (ending at MINVALUE or MAXVALUE) to a table that
  already contains MINVALUE or MAXVALUE as a limit key, may fail
  with the following error:
  
  DSNT408I SQLCODE = -20385, ERROR:THE STATEMENT CANNOT BE
  PROCESSED BECAUSE THERE ARE PENDING DEFINITION CHANGES FOR
  OBJECT >database name<.>tablespace name< OF TYPE TABLESPACE
  (REASON 2)
  
  Note:   It was discovered that the potential solution of adding
  a REORG before the ALTER ADD PARTITION that caused this error
  would result in data loss. With this APAR applied, therefore,
  Admin Tool will DROP/CREATE the tablespace instead of using
  ALTER to make these changes.
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: User of DB2 Administration Tool for Z/OS who *
  *                 alter and add partition keys to a Table when *
  *                 the Table already contains MAXVALUE or       *
  *                 MINVALUE as a key.                           *
  ****************************************************************
  * PROBLEM DESCRIPTION: When a compare of two tables results in *
  *                      altering and adding partition keys,     *
  *                      executing the resulting statements ends *
  *                      in error with SQLCODE = -20385.         *
  ****************************************************************
  In this scenario, instead of adding a reorg between the alter
  partition key statements and add partition key statements to a
  Table, the resulting Compare will be to drop/create the Table.
  If Alters are preferred in this scenario, the alter to the
  partition keys and the addition of partitions keys should occur
  in separate changes instead of being combined in a single
  change.
  

Problem conclusion

• This 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:

  UI67435

Modules/Macros

• ADB2CMT
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI67435

     UP20/02/04 P F001

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.