PI78959: ABEND0C4 RC0000003B DSNXOKEX OFFSET1830 WITH QUERY CONTAINING MULTIPLE LEFT OUTER JOIN AND SUBSELECT WITH GROUPBY

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ABEND0C4 RC003B can occur at DSNXOKEX+1830 when running a query
  that has multiple left outer joins and a subselect with a group
  by clause.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All DB2 12 for z/OS users of                                 *
  *  an SQL statement using index on                             *
  *  expression and GROUP BY clause.                             *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * ABEND0C4 RC0000003B DSNXOKEX OFFSET1830                      *
  * for a complex SQL statement that                             *
  * using index on expression and GROUP BY                       *
  * clause.                                                      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTF when available                          *
  ****************************************************************
  An abend may occur for a complex SQL statement that uses
  index on expression and GROUP BY clause because DB2 did not
  handle index on expression and GROUP BY clause correctly.
  

Problem conclusion

• DB2 has been modified to correctly process the complex SQL
  statement that uses index on expression and GROUP BY clause.
  
   Additional Keywords: SQLINDEX SQLGROUPBY
  

Temporary fix

Comments

APAR Information

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

  PI76791

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

  UI46616

Modules/Macros

• DSNXOKEX
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI46616

     UP17/05/05 P F705

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.