PM85966: ALT DOES NOT ALLOW GENERATING INDEX CONTROLLED PARTITIONING

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Users of DB2 Administration Tool for z/OS request a method for
  ALT to generate index controlled partitioning.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use the 'Alter Table ALT' (ALT)     *
  *                 function to convert a table space from       *
  *                 segmented to partitioned and redefine        *
  *                 an existing non-partitioning index that      *
  *                 was created on a table in the table space    *
  *                 to a partitioning index.                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: When using the ALT function to          *
  *                      convert a table space from segmented    *
  *                      to partitioned, DB2 Admin does not      *
  *                      redefine an existing index that was     *
  *                      created on a table in the table space   *
  *                      to a partitioning index.                *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  DB2 Admin does not convert a segmented table space to an index-
  controlled partitioned table space when using the ALT function
  because there is no entry to define a partitioning index after
  the table space conversion.
  

Problem conclusion

• Problem has been resolved.
  A new panel ADB2CONF Alter tablespace - Partitioning methods'
  is added which will pop up when coverting a segmented table
  space to a partitioned table space on panel ADB21SAR 'Table
  Space'.  Choose Option 2 'Use index-controlled partitioning' to
  define a partitioning index, resulting in the table space using
  index-controlled partitioning.
  

Temporary fix

Comments

• ž**** PE13/11/04 PTF IN ERROR. SEE APAR PI05441  FOR DESCRIPTION
  ž**** PE13/11/01 PTF IN ERROR. SEE APAR PI05317  FOR DESCRIPTION
  

APAR Information

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

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

  UK98549 UK98550

Modules/Macros

• ADBH1XAP ADB21SAR ADB21SAX ADB21XAP ADB44
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK98549

     UP13/10/22 P F310

• RA20 PSY UK98550

     UP13/10/22 P F310

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.