PK71234: CONCURRENT INSERTS DURING GROW A NEW PARTITION FOR A PBG WILL CORRUPT DICTIONARY PAGE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• "BBP2,ABND=04E-00C90219,U=BBPDB2  ,M=(N),C=910.LOCN
  =::10.168.1.145     ,LOC=DSNIDM  .DSNISGSC:5002"
  the problem caused by multiple concurrent inserts at the time we
  grow a new partition for a PBG.
  
  This problem will occur in DB2 V9 with a Partition by Growth
  tablespace with compression.  If the last physical partition
  contains dictionary pages, and growth causes a new partition to
  be created, then this problem may occur.
  DB2OVRLAY/K
  

Local fix

• 1) Disable Compression
  2) Reorg the last physical partition after compression is
  disabled.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of compressed Partition by Growth      *
  *                 table space.                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: Abend4E RC00C90219 DSNISGSC ERQUAL5002  *
  *                      The problem is caused by multiple       *
  *                      concurrent inserts during growing a new *
  *                      partition to the PBG table space.       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  During the growing of a new partition to the PBG table space,
  if the prior partition has dictionary pages, the dictionary
  pages are copied to the new partition. During this process,
  there is not enough serialization to block other threads from
  inserting into the newly created partition. Therefore, the
  dictionary pages overlay the records inserted by the other
  threads.
  

Problem conclusion

• Modified the code as follows :
  1. Check the compression attributes first before copying the
     dictionary pages from prior partition. This is to allow
     changing of the compression attributes to take effect
     during the growing of new partition before the next REORG.
  2. Ensured holding the serialization that blocks other
     threads to insert into newly added partition until
     dictionary pages are copied.
  

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:

  UK42656

Modules/Macros

• DSNDCT   DSNIFOD  DSNIOPNP DSNISUPI DSNIZLDL
  DSNXISTK
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• R910 PSY UK42656

     UP09/01/06 P F901

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.