PH09317: NEW PART WAS ADDED TO PBG AND LEFT IN RW WHEN STOP DB TS COMMAND COMPLETED.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ERROR DESCRIPTION:Ø
  Customer has a PBG object with N parts.   and they use stop
  command to stop the entire tablespace.  When stop completed,
  they found that all exsiting parts were in stop status, while a
  new part(N+1) was added and left in RW status.
  stop command used.
  --
  STOP DATABASE(D1ANC01) SPACENAM(S1ANC250) AT(COMMIT)
  --
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 11 for z/OS customers using          *
  *                 Partition By Growth (PBG) table space.       *
  ****************************************************************
  * PROBLEM DESCRIPTION: A new partition was added mistakenly    *
  *                      when any prior partition was stopped.   *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  There were total 15 existing parts in a PBG table space, which
  can grow more partitions later.  At one point, the entire
  PBG table space was stopped by Db2 STOP DATABASE command. At
  the same time, an insert job was trying to insert more rows
  to the same table space, it ignored the table space being
  stopped, mistakenly added a new partition (#16 in this case).
  

Problem conclusion

• Db2 code is modified to prevent the growth of the PBG table
  space when any or entire PBG table space partition are
  stopped.
  

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:

  UI62992

Modules/Macros

•    DSNISUPI
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RB10 PSY UI62992

     UP19/05/29 P F905

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.