PM79464: ABEND04E RC00E70005 AT DSNXOSR:P014 WHEN PARALLELISM IS ON AND MERGC = YES & SORTN_JOIN = YES & PRIMARY_ACCESSTYPE = 'T'

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Abend04e rc00e70005 at DSNXOSR:P014 may happen when explain
  query which is in parallelism and explain shows row with MERGC =
  YES & SORTN_JOIN = YES & PRIMARY_ACCESSTYPE = 'T'.
  Abend04e rc00e72048 at DSNXSORI OFFSET 56C6 may also happen
  while running the query.
  

Local fix

• Disable parallelism
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 10 for z/OS users of parallelism.    *
  ****************************************************************
  * PROBLEM DESCRIPTION: An ABEND04E RC00E70005 DSNXOSR:P014     *
  *                      may occur when a query has one miniplan *
  *                      with PARALLELISM ON and MERGC = YES     *
  *                      and SORTN_JOIN = YES and                *
  *                      PRIMARY_ACCESSTYPE = 'T' and the query  *
  *                      contains a GROUP BY clause.             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  An ABEND04E RC00E70005 DSNXOSR:P014 may occur when a query has
  one miniplan with PARALLELISM ON and MERGC = YES and
  SORTN_JOIN = YES and PRIMARY_ACCESSTYPE = 'T' and the query
  contains a GROUP BY clause.
  The following is an example of such failing SQL:
  SELECT T1.C1, T1.C2, T1.C3
    FROM T1, T2
   WHERE T2.C1 ...
     AND T1.C4 ..
  GROUP BY T1.C1, T1.C2, T1,C3
  Note:
  T1 NLJ T2, T2 miniplan shows MERGC = YES, parallel join,
  SORTN_JOIN = YES and PRIMARY_ACCESSTYPE = 'T'.
  

Problem conclusion

• The bindtime code in DB2 is modified to correct the sort key
  set up for a query with a GROUP BY clause that has
  SORTN_JOIN = YES and PRIMARY_ACCESSTYPE = 'T' and MERGC = YES
  and parallelism is ON.
  
  Additional Keywords: ABEND04E RC00E70005 SQLGROUPBY SQLNLJ NLJ
                       SQLPARALLELISM SQLCPUP DEGREEANY
                       DB2PARALL/K PARALLELISM
                       SQLSPARSEINDEX SPARSEINDEX MERGC
  

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:

  UK92492

Modules/Macros

•    DSNXOSR
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UK92492

     UP13/03/28 P F303

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.