PM84790: ABEND04E RC00E70005 IN DSNXSING :M103 FOR A SQL STATEMENT WITH A SET FUNCTION

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ABEND04E RC00E70005 IN DSNXSING :M103 FOR A SQL STATEMENT WITH
  A SET FUNCTION
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 10 for z/OS users of queries which   *
  *                 involve a non-cursor select with a set       *
  *                 function and hybrid join.                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: An ABEND04E RC00E70005 can occur at     *
  *                      location DSNXSING :M103 when executing  *
  *                      a query that involves hybrid join and   *
  *                      contains a non-cursor select with a set *
  *                      function.                               *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  An ABEND04E RC00E70005 can occur at location DSNXSING M103 when
  executing a query that involves hybrid join and contains a non-
  cursor select with a set function.
  
  The failure occurs when DB2 processes an incorrect internal
  operation code.
  
  Please note that the reported failing case was a query using a
  hybrid join access path and contained a non-cursor select with a
  set function.  However, the failure is not limited to this case.
  

Problem conclusion

• The code in DB2 has been modified to process an internal runtime
  structure correctly to prevent the reported SORT abend.
  
  Additional keywords: SQLSETFUNCTION SQLHBJ SQLHYBRID
                       SQLHYBRIDJOIN HYBRIDJOIN SQLSORT
  

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:

  UK93811

Modules/Macros

•    DSNXSBUC DSNXSIFF DSNXSIFG DSNXSIND DSNXSINE
  DSNXSING DSNXSZK
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UK93811

     UP13/05/15 I 1000

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.