PM80387: ABEND04E RC00E2000E BECAUSE A STORAGE BLOCK TRAILER EYECATCHER 'TRLF'S 'L' WAS MODIFIED TO LOWER CASE.

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Dump Title: DPA1 ABND 04E 00E2000E U=DPRA1A M=N C=101
    LOCN :190.200.71.20 LOC DSNXEDC3 DSNSVSFB OFFSET0834
    ABEND04E RC00E2000E was issued because a free block trailer's
    eyecatcher 'TRLF' was modified to 'TRlF'.
    Example
    address 200_CE92FF00
       E3D993C6 27C27546 CA987410 2F553724   | TRlF.B...q...... |
           ** should be x'D3'                    * should be 'L'
    The overlaid eyecatcher is always at xxxx_xxxxFF00.
    The overlay was x'40' bit at xxxx_xxxxFF02 was turned off.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 10 users who use queries containing  *
    *                 the following combination:                   *
    *                                                              *
    *                   1. a CASE expression in a select list      *
    *                   2. an EXISTS predicate in the WHEN clause  *
    *                   3. a correlated reference inside the       *
    *                      EXISTS predicate                        *
    ****************************************************************
    * PROBLEM DESCRIPTION: The following combination causes a      *
    *                      storage overlay:                        *
    *                                                              *
    *                      1. a CASE expression in a select list   *
    *                      2. an EXISTS predicate in the WHEN      *
    *                         clause                               *
    *                      3. a correlated reference inside the    *
    *                         EXISTS predicate                     *
    *                                                              *
    *                      The known symptoms are:                 *
    *                                                              *
    *                      04E-00E2000E at DSNIBCTD.DSNSVSFB+0834  *
    *                      0C4-00000004 at DSNXGRDS.DSNXOEXB+103A  *
    *                      04E-00E2000E at DSNHCORE.DSNSVSFB+0844  *
    *                      04E-00E2000F at DSNIDALC.DSNSVSFB+0854  *
    *                      04E-00E2000E at DSNXEDC4.DSNSVSFB+0810  *
    *                                                              *
    *                      The storage overlay is a single bit     *
    *                      alteration. The known occurrences are:  *
    *                                                              *
    *                        1. eyecatcher 'TRLF' was modified to  *
    *                           'TRlF'                             *
    *                        2. around offset '190'X before the    *
    *                           eyecatcher 'PDA'                   *
    *                                                              *
    *                      There is a slim chance of an incorrect  *
    *                      output as the result of this storage    *
    *                      overlay.                                *
    *                                                              *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    The following combination causes a storage overlay:
    
      1. a CASE expression in a select list
      2. an EXISTS predicate in the WHEN clause
      3. a correlated reference inside the EXISTS predicate
    
    The known symptoms are:
    
      1. 04E-00E2000E at DSNIBCTD.DSNSVSFB+0834
      2. 0C4-00000004 at DSNXGRDS.DSNXOEXB+103A
      3. 04E-00E2000E at DSNHCORE.DSNSVSFB+0844
      4. 04E-00E2000F at DSNIDALC.DSNSVSFB+0854
      5. 04E-00E2000E at DSNXEDC4.DSNSVSFB+0810
    
    The storage overlay is a single bit alteration. The known
    occurrences are:
    
      1. eyecatcher 'TRLF' was modified to 'TRlF'
      2. around offset '190'X before the eyecatcher 'PDA'
    
    There is a small chance of an incorrect output as the result
    of this storage overlay.
    
    The following example causes the storage overlay:
    
       SELECT CASE WHEN EXISTS(SELECT 1 FROM T2
                                 WHERE T1.C1 = T2.C1) THEN T1.C1
                                                      ELSE NULL
              END
         FROM T1;
    
    When DB2 processes the correlated reference T1.C1 inside
    the EXISTS predicate, it causes the storage overlay.
    

Problem conclusion

  • DB2 has been modified to ensure the above example will not
    run into a storage overlay.
    
    Additional keywords: DB2OVRLAY/K SMCOVERLAY SQLSTORAGE
                         SQLOVERLAY SQLCASEWHEN SQLEXISTS
                         SQLCORRELATED SQLSELECT
                         ABEND0C4 RC04
                         ABEND04E RC00E2000E RC00E2000F
                         INCORROUT SQLINCORR SQLINCORROUT
                         DB2INCORR/K
    

Temporary fix

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

Comments

APAR Information

  • APAR number

    PM80387

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    YesHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-01-11

  • Closed date

    2013-02-15

  • Last modified date

    2013-04-02

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

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

    UK91718

Modules/Macros

  •    DSNXOB2  DSNXODTX DSNXOEXB DSNXOGA1 DSNXOSL
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UK91718

       UP13/03/05 P F303

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.



Rate this page:

(0 users)Average rating

Document information


More support for:

DB2 for z/OS

Software version:

A10

Reference #:

PM80387

Modified date:

2013-04-02

Translate my page

Machine Translation

Content navigation