PH65062: AN ABEND0C4 FOR DSNXGRDS.DSNXOSOB+01A00 OR AN INCORRECT OUTPUT MAY HAPPEN WHEN AN IN-SUBQUERY ACCESS AND AN OLAP FUNCTION.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• An ABEND0C4 for DSNXGRDS.DSNXOSOB+01A00 or an incorrect output
  may happen when following conditions are met:
  - IN-subquery access is picked for the first table of the top
  query block,
  - there is an OLAP function (like RANK or DENSE_RANK or
  ROW_NUMBER or other) in the select list.
  ADDITIONAL SYMPTOMS:
  ABEND0C4 DSNXOSOB 01A00 OFFSET01A00 SQLINSUBQ
  

Local fix

• BYPASS/CIRCUMVENTION:
  Please try to rewrite the query by rewriting IN-subquery to
  equivalent form avoiding IN-subquery use. If the issue persists,
  please consult with IBM Client Support for further assistance.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Db2 12 for z/OS and Db2 13 for z/OS      *
  *                 users of OALP function and in-subquery       *
  *                 predicate.                                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: An ABEND0C4 for DSNXGRDS.DSNXOSOB       *
  *                      +01A00 or an incorrect output may       *
  *                      happen when following conditions are    *
  *                      met:                                    *
  *                                                              *
  *                      - IN-subquery access is picked for the  *
  *                      first table of the top query block      *
  *                      - there is an OLAP function (like       *
  *                      RANK or DENSE_RANK or ROW_NUMBER or     *
  *                      other) in the select list.              *
  ****************************************************************
  * RECOMMENDATION: Apply corrective PTF when available          *
  ****************************************************************
  An ABEND0C4 for DSNXGRDS.DSNXOSOB+01A00 or an incorrect output
  may happen when following conditions are met:
  - IN-subquery access is picked for the first table of the top
  query block,
  - there is an OLAP function (like RANK or DENSE_RANK or
  ROW_NUMBER or other) in the select list.
  

Problem conclusion

• DB2 has been modified to fix the in-subquery related problem
  when OLAP function is involved.
  
  Additional Keywords: ABEND0C4 SQLOLAP SQLIN SQLSUBQUERY
                       SQLINCORROUT SQLINCORR DB2INCORR/K
                       SQLRANK SQLDENSERANK SQLROWNUMBER
  

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:

  UO02789 UO02790

Modules/Macros

• DSNXOGA  DSNXOWIN
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UO02789

     UP25/04/18 P F504 ¢

• RD10 PSY UO02790

     UP25/04/18 P F504 ¢

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.