A fix is available
APAR status
Closed as program error.
Error description
abend04e rc00c90101 in DSNIRSET erqual5007 because of a zero page. The zero page was brought into the member 2 because the index page knows about the rids that were inserted on member 1. Index scan code tolerates zero page for UR We scanned the pages using the index for the subquery we bypassed the zero data pages but still kept the last scanned page in buffer. When we tried to read the next record from workfile for the update, we wanted to release any page that was held in buffer. However the page held in the buffer happened to be a zero page, DSNIRSET does not tolerate zero page in the sanity check, so we took the ERQUAL5007 abend.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: DB2 V10 and V11 SQL users. * **************************************************************** * PROBLEM DESCRIPTION: ABEND04E RC00C90101 in DSNIRSET * * erqual5007 because DB2 does not * * expect to encounter a zero page. * **************************************************************** * RECOMMENDATION: * **************************************************************** In DB2 Data Sharing environment, an index page may contain data rids that are not committed and the data page is not known to another data sharing member. During index scan, DB2 tolerates zero page due to the above condition. When the last page read in was done by Index Scan on a data page that is not in its buffer pool, a zero page was given. When table space scan is called to process a data page, any unreleased page from previous accesses need to be released, zero page is not expected. So the abend04E rc00c90101 erqual5007 is generated.
Problem conclusion
DB2 code is changed to allow zero page to be released.
Temporary fix
Comments
APAR Information
APAR number
PI26379
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
A10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2014-09-24
Closed date
2014-12-03
Last modified date
2015-01-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI23584 UI23585
Modules/Macros
DSNIRSET
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"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"A10","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
15 March 2024