PK65703: ALC ADDPART DOES NOT WARN THAT ALTER WILL RESULT IN SQLCODEN4701 PARTITIONING LIMIT KEY EXCEEDS THE SYSTEM LIMIT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool ALC command does not warn users
  that the ALTPART command on panel ADB27C and subsequent ADD
  command on panel ADB27CPV would result in a SQLCODE -4701
  DSNT408I SQLCODE = -4701, ERROR:  THE NUMBER OF PARTITIONS, OR
  THE COMBINATION OF THE NUMBER OF TABLE SPACE PARTITIONS AND THE
  CORRESPONDING LENGTH OF THE PARTITIONING LIMIT KEY EXCEEDS
  THE SYSTEM LIMIT.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool V7.2.       *
  ****************************************************************
  * PROBLEM DESCRIPTION: The  maximum number of the  partitions  *
  *                      allowed  depends  upon  how  the table  *
  *                      space  was  originally  created.   The  *
  *                      product  was  allowing an  ALTER TABLE  *
  *                      ADD  PARTITION  statement to be  built  *
  *                      which would exceed the maximum allowed  *
  *                      number of partitions.                   *
  *                                                              *
  *                      Additional problems fixed by this APAR: *
  *                       1. Panel ADB21TAV  was allowing  the   *
  *                          disabled  ADD and ROTATE  primary   *
  *                          commands to be used under certain   *
  *                          conditions.                         *
  *                       2. Panel  ADB27CPV   was  using  the   *
  *                          incorrect  next partition  number   *
  *                          under certain conditions, causing   *
  *                          gaps  in  the  partition  numbers   *
  *                          displayed.                          *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  SQLCODE4701 may occur when attempting to add a partition to a
  table space using the AL or ALC line commands on a table.
  

Problem conclusion

• The code has been corrected. Message ADB273E will be issued when
  an attempt  to add a partition beyond the maximum has been made.
  To add  a partition beyond the maximum allowed,  the table space
  needs to be redefined.
  

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:

Modules/Macros

•    ADB21TA  ADB21TAV ADB27    ADB27C   ADB27CA
  ADB27CAA ADB27CPV ADB27CX
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R720 PSY UK38969

     UP08/08/30 P F808

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.