PH45170: AN ALTER PARTITION FOR A PAGENUM RELATIVE TABLESPACE WITH 256 PARTS FAILS WHEN TRYING TO ADD 257TH PART

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• An ALTER PARTITION for a PAGENUM RELATIVE tablespace with
  256 parts fails when trying to add 257th part
  
  DECRIPTION:  Change Management DROPs the tablespace instead of
  ALTER when attempting to add the 257th part.  However, if there
  are already 257 partitions, it will allow additional partitions
  to be added with an alter.
  
  The panel display this message
  
  DB2 Admin --------------- DSNI Alter Partitioned Table - Row 245
  Command ===>
  Cannot add new partition
  Commands: NEXT      COLUMNS  ORIGINAL  ADD  ROTATE
  Line commands:  INS - Insert Partition
  

Local fix

• na
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
  *                 who add partitions to a table space defined  *
  *                 with PAGENUM RELATIVE                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: Change management analyze to add more   *
  *                      than 256 partitions to a table in       *
  *                      a table space defined with PAGENUM      *
  *                      RELATIVE, results in a drop and         *
  *                      create of the table space when          *
  *                      an ALTER can be used to do the          *
  *                      same. The Compare function should       *
  *                      also issue an error if more than        *
  *                      4096 partitions are specified in        *
  *                      total.                                  *
  ****************************************************************
  When analyzing a change that adds partitions to a table in a
  table space with the PAGENUM RELATIVE attribute, Db2 Admin Tool
  decides to drop and create the table space when trying to add
  the 257th partition. Db2 allows this partition to be added by
  using an ALTER operation, because PAGENUM is set to RELATIVE.
  Db2 Admin Tool should also add this partition by using an ALTER
  statement. If partitions over 4096 are added, the following
  message is displayed:
  ADB7397E The number of partitions exceeds the limit of 4096 for
  PAGENUM RELATIVE table spaces.
  Ensure that the number of partitions in the source does not
  exceed this maximum value.
  

Problem conclusion

• The problem has been resolved.
  Search Keywords: PAGENUM_RELATIVE
  

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:

  UI81117

Modules/Macros

• ADB2CME  ADB7000
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI81117

     UP22/06/23 P F206

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.