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

Obtain the fix for this APAR.

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 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.