PI64320: ABEND04E RC00E70006 AT DSNXISB6 P380 PROCESSING ALTER INDEX 16/06/16 PTF PECHANGE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ABEND04E RC00E70006 at DSNXISB6 P380 occurred while processing
  an ALTER INDEX statement.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 10 and 11 for z/OS users who have    *
  *                 PI36213 applied (UI29092 on V10 or UI29093   *
  *                 on V11) and are executing DDL that results   *
  *                 in conversion from index-controlled          *
  *                 partitioning to table-controlled             *
  *                 partitioning.                                *
  ****************************************************************
  * PROBLEM DESCRIPTION: An ALTER INDEX with NOT CLUSTER option  *
  *                      that results in conversion from index-  *
  *                      controlled partitioning to table-       *
  *                      controlled partitioning results in      *
  *                      ABEND04E RC00E70006 at location         *
  *                      DSNXIDDL.DSNXISB6:P380                  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  DB2 incorrectly abends with ABEND04E RC00E70006 at location
  DSNXIDDL.DSNXISB6:P380 instead of issuing an SQLCODE when an
  error is encountered during invalidation of packages dependent
  on a table that is implicitly converted from index-controlled
  to table-controlled partitioning during execution of one of the
  following DDL statements:
  - CREATE INDEX with PARTITIONED option
  - CREATE INDEX with PART VALUES clause and without CLUSTER
  - ALTER INDEX with NOT CLUSTER option of partitioning index
  - DROP INDEX of partitioning index
  - ALTER TABLE ADD CLONE
  

Problem conclusion

• DB2 has been corrected to issue an appropriate SQLCODE rather
  than abending when an error is encountered during package
  invalidation for a table undergoing conversion from index-
  controlled to table-controlled partitioning.
  

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:

  UI39660 UI39661

Modules/Macros

• DSNXIAIX DSNXICIX DSNXICLN DSNXIDIX DSNXISB6
  DSNXONZC DSNXONZO DSNXORFN
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UI39660

     UP16/08/12 P F608 Ø

• RB10 PSY UI39661

     UP16/08/11 P F608 Ø

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.