A fix is available
APAR status
Closed as program error.
Error description
An abend occurred with the following title. DSN ,ABND=04E-00E2000F,U=uuuuuuu ,M=N ,C=101.LOCN=::FFFF:xx.xx.xx. ,LOC=DSNXEFB .DSNSVSFB+08EA Subsequently DB2 came down due to must complete, rc00E50702. The rc00E2000F indicates the block to be freed was already free. This was due to the block trailer 'TRLA' overlaid by data, zeros in this case. The zeroes were due to data from an invalid row overlaying the end of the block. DB2OVRLAY/K storage overlay
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All users of DB2 V10 and V11 for z/OS. * **************************************************************** * PROBLEM DESCRIPTION: The following ABENDs can occur after * * or during SELECT: * * ABEND0C4 RC38 PIC38 at DSNIRNXT+05FA * * ABEND0C7 at DSNXROHB+27B8 * * ABEND04E RC00E2000F at DSNSVSFB+08EA * * ABEND04E RC00E20005 at DSNSVBK +1AB6 * * Other ABENDs could also occur due to * * storage overlay. * * The storage overlay can cause DB2 to * * crash. * **************************************************************** * RECOMMENDATION: * **************************************************************** A query that attempts to retrieve data from a varying length column in a bad record with an incorrect record length can lead to a storage overlay and cause DB2 to crash when extracting data from the stored record.
Problem conclusion
In order to prevent a storage overlay, DB2 code is fixed to issue following ABENDs when retrieving a record and detecting an invalid record length. ABEND04E RC00C90101 DSNIMOFR ERQUAL5014 ABEND04E RC00C90101 DSNIMOFR ERQUAL5015
Temporary fix
********* * HIPER * *********
Comments
APAR Information
APAR number
PI38032
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
A10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2015-03-30
Closed date
2015-05-27
Last modified date
2015-07-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI28078 UI28079
Modules/Macros
DSNIMOFR
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
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.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
01 July 2015