PH51359: NEW FUNCTION

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• New function
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Db2 13 for z/OS users of ALTER                           *
  * TABLE SPACE, ALTER TABLE, ALTER INDEX                        *
  * statements.                                                  *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * This APAR provides support for                               *
  * stacking other pending definition                            *
  * changes with a partition-by-                                 *
  * growth (PBG) to partition-by-range                           *
  * (PBR) pending definition change.                             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When a PBG-to-PBR pending change is issued, all subsequent
  pending changes are restricted (SQLCODE -20385 RC40) if
  referencing the table space, the table it contains, or indexes
  on the table.
  If any schema definition changes are pending for the table
  space, the table it contains, or the indexes on the table, the
  PBG-to-PBR pending change is restricted (SQLCODE -20385 RC39).
  

Problem conclusion

Temporary fix

Comments

• Db2 has been enhanced to allow the following pending definition
  options to be stacked with PBG-to-PBR pending change:
  - Table space level: BUFFERPOOL, DSSIZE, SEGSIZE (excluding
    conversion to UTS), MEMBER CLUSTER.
  - Table level: ALTER COLUMN, DROP COLUMN.
  - Index level: BUFFERPOOL, COMPRESS.
  Additional keywords
  SQLALTER
  SQLCODE20385
  Ref: E19048
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UI83886

Modules/Macros

• DSNXIATB DSNXIAIX DSNXIATS
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RD10 PSY UI83886

     UP23/01/05 P F301

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.