A fix is available
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 number
PK83397
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
910
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2009-03-25
Closed date
2009-10-09
Last modified date
2009-11-04
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
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.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.1","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
04 November 2009