PK16037: MIG OF A PARTITIONED TS, WITH HPU USED AS THE UNLOAD TASK, GENERATES UNLOAD OF ENTIRE TS FOR EACH PARTITION.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Administration Tool unloads entire Partitioned TableSpace
  for each partition, during MIGration processing when HPU is used
  as the unload task.
  .*
  DB2 Administration Tool builds an incorrect "DROP TABLE"
  statement  during  migration processing when migrating a
  table, which may cause SQLCODE204 or a DROP of the wrong
  table to occur.
  .*
  

Local fix

• Select Parallel HPU unloads
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool, who use    *
  *                 the Migrate function, may be affected.       *
  ****************************************************************
  * PROBLEM DESCRIPTION: The following items are addressed:      *
  *                      .*                                      *
  *                      Using  DB2 Admin V7 and HPU to migrate  *
  *                      a  Partitioned Tablespace,  the entire  *
  *                      Tablespace  may  be  unloaded once for  *
  *                      each Partition.  NOTE: In other words,  *
  *                      MIG of a Partitioned TS, with HPU used  *
  *                      as the UNLOAD task, generated UNLOAD    *
  *                      of entire TS for each Partition.        *
  *                      .*                                      *
  *                      Using DB2 Admin V7 Migrate, SQLCODE204  *
  *                      may occur when dropping the objects on  *
  *                      on  the  target  system,  or the wrong  *
  *                      object may be dropped.                  *
  *                      .*                                      *
  *                      Using  DB2  Admin  V5,  looping may be  *
  *                      encountered  when  attempting to build  *
  *                      the migrate JCL.                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  See Problem Description.
  

Problem conclusion

• Apply the fixes.
  

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:

  UK10430 UK10431

Modules/Macros

•    ADB28M   ADB28SUB
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R510 PSY UK10430

     UP05/12/31 P F512

• R710 PSY UK10431

     UP05/12/31 P F512

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.