PK41904: ABEND0C4 RC38 AT DSNXOD8+16CA OR ABEND0C4 RC38 AT DSNXOSOB+1268 ABEND04E RC00E70005 AT DSNXOSOC:M100

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ABEND0C4 RC38 at DSNXOD8+16CA if DSN_SORT_TABLE or
  DSN_SORT_KEY_TABLE are defined.
  .
  or
  .
  ABEND0C4 RC38 at DSNXOSOB+1268 if DSN_PREDICAT_TABLE is
  defined but DSN_SORT_TABLE and DSN_SORT_KEY_TABLE are not
  defined.
  .
  Alternate symptom:
  ABEND0C4 RC38 at DSNXGRDS.DSNXOSR+480E
  ABEND0C4 RC38 at DSNXGRDS.DSNXOSOB+11EC or +110E
  ABEND04E RC00E70005 at DSNXGRTM:M300
  ABEND0C4 RC00000004 at DSNXOGA1+1A74
  ABEND0C4 RC38 at DSNXOIN +326C
  ABEND0C4 RC38 DSNXOSR +24AE
  ABEND0C4 RC38 DSNXOSOB +07DE
  

Local fix

• Drop the extended explain tables identified in the error
  description.
  The apar is recommended. However, a possible
  workaround is not to run EXPLAIN or the following.
  
  A workaround would be to set the bind option to EXPLAIN(NO).
  If the customer needs plan table output, then they can
  drop the following EXPLAIN tables under the SQLID (which
  are used for Visual Explain):
  DSN_PREDICAT_TABLE, DSN_SORT_TABLE, and DSN_SORTKEY_TABLE.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users of DB2 SQL Explain.                *
  ****************************************************************
  * PROBLEM DESCRIPTION: Abends may occur at the following       *
  *                      locations when executing EXPLAIN for    *
  *                      SELECT statements that involve a sort.  *
  *                                                              *
  *                      ABEND0C4 RC38 at DSNXOD8+16CA           *
  *                      ABEND0C4 RC38 at DSNXOSOB+1268          *
  *                      ABENDOC4 RC38 at DSNXOSR+480E           *
  *                      ABEND04E RC00E70005 at DSNXOGA:P002     *
  *                      ABEND04E RC00E70005 at DSNXGRTM:M300    *
  *                      ABEND0C4 RC00000004 at DSNXOGA1+1A74    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Abends may occur at the following locations when executing
  EXPLAIN for SELECT statements that involve a sort.
  
  ABEND0C4 RC00000038 at DSNXOD8+16CA
  ABEND0C4 RC00000038 at DSNXOSOB+1268
  ABENDOC4 RC00000038 at DSNXOSR +480E
  ABEND04E RC00E70005 at DSNXOGA:P002
  ABEND04E RC00E70005 at DSNXGRTM:M300
  ABEND0C4 RC00000004 at DSNXOGA1+1A74
  Also, looping may occur when running Explain, especially for
  Explain on queries with multiple query blocks.
  Additional Keywords:
  SQLEXPLAIN INFINITE LOOP ENDLESS LOOP
  

Problem conclusion

• Code is changed to correct the abend situation during
  SQL Explain for Explain table DSN_PREDICAT_TABLE or
  various hidden Explain tables.
  

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:

Modules/Macros

• DSNXOD13 DSNXOD2  DSNXOD8  DSNXOGP
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• R810 PSY UK24432

     UP07/05/11 P F705

• R910 PSY UK24433

     UP07/05/11 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.