PH39286: ABEND0C4 RC003B AT DSNXODN OFFSET00600 AND ABEND04E RC00E2000D DSNLXDAL DSNSVSFB OFFSET00A18 LEAD TO DB2 ABTERM RC00E50702

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ABEND0C4 RC003B at DSNXODN OFFSET00600 and ABEND04E RC00E2000D
  at DSNLXDAL DSNSVSFB OFFSET00A18 occurred due to a storage
  overlay and led to Db2 abnormal termination with RC00E50702.
  
  The abend can occur on queries which contain
  1. Left outer join, and
  2. The ON-clause of left outer join has predicates under an
     'OR', and
  3. The outer table of left outer join uses page range screening
  .
  Additional keywords: DB2OVRLAY/K SQLLEFTJOIN SQLLEFT
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * For all Db2 for z/OS users who have SQLs                     *
  * with left outer join using page range                        *
  * screening.                                                   *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * When a query with left outer join uses                       *
  * page range screening, abend with                             *
  * various offsets in                                           *
  * LOC=DSNXGRDS.DSNXODN may occur, and                          *
  * Db2 may come down.                                           *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTF when available                          *
  ****************************************************************
  The abend occurs when a table eligible for page range
  screening uses the wrong predicate. This occurs when the query
  contains left outer join and the ON-clause contains an 'OR'
  predicate.
  Additional Keywords:
  ABEND0C4 PAGERANGE SQLLEFTJOIN
  

Problem conclusion

• The described problem is fixed.
  

Temporary fix

• *********
  * HIPER *
  *********
  

Comments

APAR Information

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

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

  UI76886

Modules/Macros

• DSNXOPPD
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI76886

     UP21/08/31 P F108 ¢

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.