A fix is available
APAR status
Closed as program error.
Error description
on a Reorg of a data partitioned tablespace ie (Create table ...partition by...) with SORTDATA NO will move data to the first partition. 00E40304 could result or 00C90099 if the partition fills
Local fix
use SORTDATA YES
Problem summary
**************************************************************** * USERS AFFECTED: All DB2 for z/OS V8 and DB2 9 for z/OS users * * who execute REORG TABLESPACE utility with * * SORTDATA NO * **************************************************************** * PROBLEM DESCRIPTION: REORG TABLESPACE SORTDATA NO on a * * table controlled partitioned table * * space incorrectly reloaded all rows * * into a wrong data partition * **************************************************************** * RECOMMENDATION: Apply corrective PTF when available * **************************************************************** User ran a REORG TABLESPACE SORTDATA NO against a partitioned table space, which has either no indexes defined or has a non- partitioned index (NPI) as its clustering index. The utility completed successfully, but rows from all partitions were incorrectly reloaded into physical partition 1, resulting in data integrity problem. For the same scenario above, if PART is specified in the REORG statement then rows from all partitions can be incorrectly reloaded into one of the partition being reorganized. This problem is caused by incorrect program logic in determining which partition the unloaded rows need to be reloaded back into, and it will only happen when SORTDATA NO is specified. Additional symptom: - REORG gets ABEND04E RC00E40304 in DSNURBXA + x'8FB0'
Problem conclusion
Code has been modified to ensure data rows are reloaded back to the correct partition for REORG TABLESPACE SORTDATA NO.
Temporary fix
********* * HIPER * *********
Comments
APAR Information
APAR number
PK62007
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
810
Status
CLOSED PER
PE
NoPE
HIPER
YesHIPER
Special Attention
NoSpecatt
Submitted date
2008-02-29
Closed date
2008-04-17
Last modified date
2008-06-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK35673 UK35674
Modules/Macros
DSNURFBR DSNURFIT DSNURULD
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":"8.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":"8.1","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
02 June 2008