PK83397: ABEND04E RC00E40318 DURING REORG PART X OF A PARTITION BY GROWTHTABLE SPACE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ABEND04E RC00E40318 during REORG PART x of a Partition By Growth
  table space
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 9 for z/OS users of the REORG        *
  *                 TABLESPACE utility on Partitioned By Growth  *
  *                 table space                                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: REORG TABLEPSACE encountered ABEND04E   *
  *                      RC00E40318 against Partitioned By       *
  *                      Growth table space.                     *
  ****************************************************************
  * RECOMMENDATION: Apply PTF when available.                    *
  ****************************************************************
  User ran a REORG TABLESPACE against a single partition of a
  Partitioned By Growth (PBG) table space, which has non-zero
  PCTFREE and/or FREEPAGE value defined.  The utility failed in
  the RELOAD phase with ABEND04E RC00E400318 due to an out of
  space condition on the partition being reloaded into.
  
  The problem is caused by the REORG utility not being able to
  reload back all the data rows unloaded from the PBG partition,
  which was full prior to REORG due to SQL inserts/updates using
  up all the free space reserved by the PCTFREE and FREEPAGE
  region.  REORG tried to reserve the empty space indicated by
  the non-zero PCTFREE and FREEPAGE value, and by doing so
  resulted in the out-of-space condition.
  
  A similar problem can happen when running REORG against a
  PBG table space with LOB columns defined.
  
  To partially address this problem, this apar adds a new system
  parameter called REORG_IGNORE_FREESPACE, which specifies whether
  the REORG TABLESPACE utility will ignore the PCTFRE and FREEPAGE
  values when reloading data rows into a PBG table space in the
  following scenarios:
  - When reorganizing a subset of the PBG partition(s)
  - When the table in the PBG table space has LOB column(s)
  
  Valid settings for REORG_IGNORE_FREESPACE are NO and YES.
  The default is NO, meaning that the PCTFREE and FREEPAGE values
  will be honored by the REORG TABLESPACE utility.
  

Problem conclusion

• Code has been modified to provide a new system parameter for
  user to specify whether REORG should ignore the free space
  established by the non-zero PCTFREE and FREEPAGE value.
  

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:

  UK50931 UK50932

Modules/Macros

• DSNDMSI  DSNDQWPZ DSNDSPRM DSNDUSU  DSNIRLPG
  DSNTIDXA DSNTIJUZ DSNTINST DSNURFIT DSNURWBF DSNWZIF9 DSN6SPRM
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• R810 PSY UK50931

     UP09/10/28 P F910

• R910 PSY UK50932

     UP09/10/27 P F910

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.