PM31545: ABEND04E RC00E20017 AT DSNSLD1 .DSNSTACK+036E OFFSET36E

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DAI2,ABND=04E-00E20017,U=S0871485,M=(N),C=910.LOCN=::7.242.9
  2.61      ,LOC=DSNSLD1 .DSNSTACK+036E
  
  occurred for complex query.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 8, DB2 9 and DB2 10 for z/OS users   *
  *                 of complex SQL statement.                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: ABEND04E RC00E20017 in DSNSTACK +036E   *
  *                      could occur for a complex SQL statement *
  *                      which satisfies the following           *
  *                      conditions:                             *
  *                      1. It references a view;                *
  *                      2. DB2 generates workfile contains      *
  *                         large number of columns.             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  ABEND04E RC00E20017 in DSNSTACK +036E could occur for a
  complex SQL statement which satisfies the following conditions:
  1. It references a view;
  2. DB2 generates workfile contains large number of columns.
  

Problem conclusion

• DB2 is updated to handle the complex sql statement as
  above correctly.
  Additional Keywords: SQLOUTERJOIN SQLFULLJOIN SQLOUTER
                       SQLFULL SQLJOIN SQLLEFTJOIN SQLLEFT
                       SQLRIGHTJOIN SQLRIGHT SQLVIEW
  

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:

  UK65467 UK65468 UK65469

Modules/Macros

• DSNXOADJ
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UK65467

     UP11/03/22 P F103

• R810 PSY UK65468

     UP11/03/22 P F103

• R910 PSY UK65469

     UP11/03/22 P F103

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.