IBM Support

PI94862: ABEND04E RC00E2000C DSNSVSVB OFFSET0B06 OCCURS WHEN TOO MANY CASE EXPRESSIONS WITH NUMBER LITERALS IN THE ORDER BY CLAUSE

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • ABEND04E RC00E2000C DSNSVSVB OFFSET0B06 ( CALLER DSNXOEM ->
    DSNXEAB ) occurs on a query when there are huge number of CASE
    expressions with number literals in the ORDER BY clause
    Additional keywords:
    SQLCASE SQLORDERBY DB2STGLK/K
    

Local fix

  • N/A
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All Db2 11 for z/OS users of an SQL          *
    *                 statement that contains large number of      *
    *                 numeric constants in expressions.            *
    ****************************************************************
    * PROBLEM DESCRIPTION: ABEND04E RC00E2000C at the location     *
    *                      DSNXEAB DSNSVSVB OFFSET0B06 may occur   *
    *                      for an SQL statement that contains      *
    *                      large number of numeric constants in    *
    *                      expressions.                            *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    An example is shown below:
    
    SELECT *
    FROM T1
    ORDER BY CASE WHEN C1 = 1
                    THEN 1
                  ELSE C1
             END,
             CASE WHEN C1 = 2
                    THEN 2
                  ELSE 2
             END,
    ...
             CASE WHEN C1 = 10000
                    THEN 10000
                  ELSE 10000
             END
    ;
    
    The abend may occur for the statement above because Db2 ran out
    of storage when matching the CASE expressions.
    

Problem conclusion

  • Db2 has been modified to remove the abend for the aforementioned
    SQL statement.
    
    Additional keywords: SQLSTOR SQLSTORAGE
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI94862

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2018-03-08

  • Closed date

    2018-05-22

  • Last modified date

    2018-07-02

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

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

    UI56369

Modules/Macros

  •    DSNXOEM
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RB10 PSY UI56369

       UP18/06/23 P F806

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.



Document information

More support for: DB2 for z/OS

Software version: B10

Reference #: PI94862

Modified date: 02 July 2018


Translate this page: