PI22379: 04E ABEND RC00E70005 AT DSNXOLDE:M010 when query involves DPSI parallel access for the inner table

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• 04E abend RC00E70005 at DSNXOLDE:M010
  the abend only occurs when query involves DPSI parallel access
  for the inner table
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 11 for z/OS users of queries that    *
  *                 involves DPSI parallel access for the inner  *
  *                 table.                                       *
  ****************************************************************
  * PROBLEM DESCRIPTION: An ABEND04E RC00E70005 AT DSNXOLDE:M010 *
  *                      may occur when CPU parallelism is       *
  *                      chosen and inner table of the join is   *
  *                      partitioned on DPSI index.              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  An ABEND04E RC00E70005 AT DSNXOLDE:M010 may occur when CPU
  parallelism is chosen and inner table of the join is
  partitioned on DPSI index.
  
  The following query presents such an example.
  
     CREATE  INDEX "CB"."IX1"
       ON  "CB"."TB3"  (
        "C1" ASC,
        "C2" ASC)
            NOT CLUSTER
            PARTITIONED
            DEFINE  NO
            COMPRESS NO
            BUFFERPOOL BP1 CLOSE YES
     ;
  
  
  
  
    SELECT A.C1 , SUM(A.C3), A.C2,
           SUM(B.C4), B.C1, B.C2,
           C.C4
    FROM CO.TB1 A, CO.TB2 B, CB.TB3  C
    WHERE      A.C3 > -14
      AND      A.C4 = '9301'
      AND      B.C3 = '019'
      AND      B.C1 = '9310'
      AND      B.C2 =  2
      AND      C.C1 = '021'
      AND      C.C4 = 3
      AND      A.C5 = C.C3
      AND      B.C5 = C.C3
    GROUP BY  A.C1, A.C2, B.C1, B.C2, C.C4
  
  
   CB.TB3 is the last table of the join, and DPSI index
   CB.IX1 is chosen to the parallelism.
  

Problem conclusion

• The bindtime code in DB2 has been modified to correct the
  conditions leading to the ABEND.
  
  Additional Keywords: SQLPARALLELISM SQLDPSI SQLJOIN
                       ABEND04E DB2PARALL/K
  

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:

  UI21513

Modules/Macros

• DSNXOLL
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RB10 PSY UI21513

     UP14/10/07 P F410

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.