PK62007: REORG OF A DATA PARTITIONED TABLESPACE WITH SORTDATA NO CAUSES ALL ROWS TO BE PLACE IN FIRST PARTITION - 00E40304 POSSIBLE

Obtain the fix for this APAR.

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 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

• R810 PSY UK35673

     UP08/05/03 P F805

• R910 PSY UK35674

     UP08/05/03 P F805

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.