PM85939: SYSTEM PAGE CORRUPTION AFTER REORG OR LOAD RESUME FOR A MEMBER CLUSTER PAGESET WITH PM76363 & UK90660/UK90661 PTFS APPLIED

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• System page corruption after REORG or LOAD RESUME for a member
  cluster pageset with PM76363 & UK90660/UK90661 ptfs applied,
  which are now marked PE
  
  Symptoms include:
  
  ABEND04E RC00C90101 ERQUAL2003 in DSNIPPS
  ABEND04E RC00C90101 ERQUAL500B in DSNIBMCL
  ABEND04E RC00E20001 DSNIROBD.DSNSVBK +297E (OFFSET297E)
  ABEND04E RC00E20001 DSNIROBD.DSNSVBK +2A10 (OFFSET2A10)
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: DB2 9 for z/OS or DB2 10 for z/OS users of   *
  *                 REORG and LOAD RESUME utilities against      *
  *                 classic partitioned table space with Member  *
  *                 Cluster, who have applied APAR PM76363 and   *
  *                 PTF UK90660/UK90661.                         *
  ****************************************************************
  * PROBLEM DESCRIPTION: Following problems could occur during   *
  *                      or after REORG or LOAD RESUME utility   *
  *                      when PM76363 has been applied:          *
  *                      -ABEND04E RC00C90101 DSNIPPS ERQUAL2003 *
  *                      -ABEND04E RC00C90101 DSNIBMCL           *
  *                                ERQUAL500B                    *
  *                      -ABEND04E RC00E20001 DSNIROBD.DSNSVBK   *
  *                      -Data loss                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Before PM76363/UK90660(UK90661), LOAD RESUME utility against
  classic partitioned TS with Member Cluster could fail with
  abend ABEND04E RC00C90101 at DSNIDLOD ERQUAL500A. This issue
  only happens when there are zero data pages between the last two
  space map pages, and data pages covered by the last space map
  page are empty. PM76363 is to let LOAD RESUME tolerate the zero
  data pages.
  
  After PM76363/UK90660(UK90661) is applied, REORG utility or LOAD
  RESUME utility against classic partitioned table space with
  Member Cluster might corrupt system page. As a consequence,
  later access to down level records could fail with
  aforementioned abends. For LOAD RESUME utility, data covered by
  the space map page second to the last one could be overwritten
  if all data pages covered by the last space map page happen to
  be empty pages.
  

Problem conclusion

• DB2 code is modified to prevent the system page or data page
  corruption by REORG or LOAD RESUME utility against classic
  partitioned table space with Member Cluster.
  

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:

  UK94465 UK94466

Modules/Macros

• DSNIDLOD
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UK94466

     UP13/06/05 P F306 ®

• R910 PSY UK94465

     UP13/06/05 P F306 ®

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.