PH66865: MIG GENERATES INCORRECT DROP STATEMENTS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• MIG with the option 'DROP on target before CREATE' generates
  DROP TABLESPACE statement for implicit tablespace. This
  statement can fail on the target subsystem if implicit
  tablespace has a unique generated name. So MIG should generate
  DROP TABLE statement instead.
  If the optional job for redefining MIG scope is used to define a
  table list, generated DROP statements contain DROP TABLE
  statements for LOB tables.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
  ****************************************************************
  * PROBLEM DESCRIPTION: The MIG function generates incorrect    *
  *                      DROP statements for LOB tables and      *
  *                      implicit table spaces.                  *
  ****************************************************************
  When MIG is run with the option 'DROP on target before CREATE',
  a DROP TABLESPACE statement is generated for the implicit table
  space. This statement can fail on the target system if the
  implicit table space has a unique generated name. MIG should
  generate a DROP TABLE statement instead.
  If the optional job for redefining the MIG scope is used to
  define a table list, generated DROP statements contain DROP
  TABLE statements for LOB tables.
  

Problem conclusion

• The problem has been resolved.
  

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:

  UO03987

Modules/Macros

• ADB21S   ADB21T   ADB28ASD ADB28M   ADB28M2  ADB28MM  ADB28S
  ADB28SC
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RD10 PSY UO03987

     UP25/07/08 P F507

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.