PI46755: DB2 ADMIN TOOL MAKEPBR ON AN INDEX-CONTROLLED PARTITIONED TABLESPACE FAILS WITH SQLCODE -662

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• MAKEPBR on an index-controlled partitioned tablespace fails
  with SQLCODE -662.
  
  Job output shows:
  Compare index source(>schema<.>tablename<) and
     target(>schema<.>tablename<)
     Index>schema<.>indexname< will be dropped by dropping the
     tablespace
  ADB7139E The CREATE INDEX statement can lead to error
  SQLCODEN662/SQLCODE -662, because a partitioned
  index cannot be created on a table which is in a
  partition-by-range table space. Index will be recreated
  because the base table will be dropped and recreated.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool         *
  *                 for z/OS who use 'ALT Redefine a table       *
  *                 space (ALT)' to alter a partitioned table    *
  *                 space from index-controlled partitioning     *
  *                 to a Partition-by-Range (PBR) table          *
  *                 space.                                       *
  ****************************************************************
  * PROBLEM DESCRIPTION: When using DB2 Admin to alter a         *
  *                      partitioned table space from            *
  *                      index-controlled partitioning           *
  *                      to a Partition-by-Range (PBR) table     *
  *                      space by issuing the primary command    *
  *                      'MAKEPBR' on panel ADB21SAR 'Redefine   *
  *                      Table Space', the Analyze job failed    *
  *                      with error message ADB7139E /           *
  *                      msgadb7139e:                            *
  *                                                              *
  *                      ADB7139E The CREATE INDEX statement     *
  *                      may lead to error SQLCODEN662/          *
  *                      SQLCODE -662 because the table          *
  *                      >table_schema<.>table_name< on which    *
  *                      the index is being created is in the    *
  *                      table space >database_name<.            *
  *                      >tablespace_name<.  The table space     *
  *                      is defined as partition-by-range.       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When using DB2 Admin to alter a partitioned table space
  from index-controlled partitioning to a Partition-by-Range
  (PBR) table space by issuing the primary command 'MAKEPBR'
  on panel ADB21SAR 'Redefine Table Space', the Analyze job
  failed with error message ADB7139E / msgadb7139e:
  
  ADB7139E The CREATE INDEX statement may lead to
  error SQLCODEN662/SQLCODE -662 because the table
  >table_schema<.>table_name< on which the index is
  being created is in the table space
  >database_name<.>tablespace_name<.
  The table space is defined as partition-by-range.
  

Problem conclusion

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

Modules/Macros

•    ADB21SAR
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UI33958

     UP15/12/23 P F512

• RB10 PSY UI33959

     UP15/12/23 P F512

• RB20 PSY UI33960

     UP15/12/23 P F512

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.