PK87606: MIG PANEL ADB28M DROP ISSUES WHEN "DDL N" AND "CATALOG STATISTIC S Y" SPECIFIED SQLCODE100 FOR UPDATE SQL ON TARGET

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS MIG function panel ADB28M
  allowed users to specify:
  Scope of migrate:
      DDL . . . . . . . . . . . . . . :  N
      Data  . . . . . . . . . . . . . :  Y
      Catalog statistics  . . . . . . :  Y
  and:
  DROP on target before CREATE . . : YES
  which results in a DROP being issued with no subsequent CREATE.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2  Administration Tool  that use  *
  *                 the Migrate function and do not include DDL  *
  *                 in the scope of migrate,  but choose Yes to  *
  *                 'DROP on target before CREATE' option.       *
  ****************************************************************
  * PROBLEM DESCRIPTION: Migration  panel ADB28M  allows 'DROP   *
  *                      on target before CREATE' = Yes option   *
  *                      without DDL in the migrate scope.       *
  *                                                              *
  *                      Scope of migrate:                       *
  *                      DDL . . . . . . . . . . . . .. : N      *
  *                      Data . . . . . . . . . . . . . : Y      *
  *                      Catalog statistics . . . . . . : Y      *
  *                                                              *
  *                      and:                                    *
  *                      DROP on target before CREATE . . : YES  *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  Panel ADB28M does not check for the case when DROP on target is
  YES before CREATE is YES and the Scope of migrate DDL is NO.
  

Problem conclusion

• Panel ADB28M no longer allows drop table option without the DDL
  being dropped.
  

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:

Modules/Macros

•    ADB28M
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R720 PSY UK49451

     UP09/08/27 P F908

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.