PM82595: ABEND04E RC00E2000F DSNXOAF OFFSET0858 WITH PARALLLELISM WHEN PARTITIONING INDEX THAT HAS INCLUDE COLUMNS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The problem can happen for paralllelism if a table in the query
  has a partitioning index that has INCLUDE columns.
  
  Keywords:  DB2OVRLAY/K  SMCOVERLAY  sqlparallelism
  

Local fix

• disable parallelism
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 10 for z/OS users of parallelism     *
  *                 who have queries on a table with an index    *
  *                 defined with INCLUDE columns.                *
  ****************************************************************
  * PROBLEM DESCRIPTION: ABEND04E RC00E2000F in DSNXOAF +0858    *
  *                      on a query in parallelism when the      *
  *                      partitioning index is defined with      *
  *                      INCLUDE columns                         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  ABEND04E RC00E2000F in DSNXOAF +0858 can occur on a query in
  parallelism when the partitioning index is defined with INCLUDE
  columns.  A storage overlay may happen where PCAC blocks can
  go beyond the allocated space.  This will result in the abend
  when DB2 attempts to free storage.
  
  Additional Keywords:
  SQLSTORAGE DB2OVRLAY/K SMCOVERLAY SQLINCLUDE DB2PARALL/K
  OFFSET0858
  

Problem conclusion

• Code is changed so that the correct amount of storage will be
  allocated for PCAC blocks.
  

Temporary fix

• *********
  * HIPER *
  *********
  

Comments

APAR Information

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

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

  UK92625

Modules/Macros

•    DSNXOLCM DSNXOLM1
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UK92625

     UP13/04/03 P F304

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.