PI26379: ABEND04E RC00C90101 IN DSNIRSET ERQUAL5007 USING A ZERO PAGE.

Obtain the fix for this APAR.

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

• RA10 PSY UI23584

     UP14/12/19 P F412

• RB10 PSY UI23585

     UP14/12/19 P F412

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.