PK59593: USING MIG WITH VIEW CREATED WITH AN ALIAS CREATES THE VIEW WITH THE SAME TBOWNER AS THE ALIAS INSTEAD 08/04/15 PTF PEREMOVE

Obtain the fix for this APAR.

APAR status

• Closed as unreproducible in next release.

Error description

• When using DB2 Administration Tool and MIG (migrate) and
  performing a MIGRATE on a view created on an alias, the
  old alias is used instead of the new alias.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Admin Tool or Object Comparison *
  *                 who specify a new object owner in one of the *
  *                 following functions:                         *
  *                  - DDL line command                          *
  *                  - GEN                                       *
  *                  - Migrate                                   *
  *                  - Object Comparison                         *
  *                                                              *
  *                 to generate,  migrate, or  compare a  set of *
  *                 objects that contains a view that references *
  *                 an alias.                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: When a new owner is specified,the alias *
  *                      creator is  not changed when referenced *
  *                      in a View text. The DDL might fail when *
  *                      applied in DB2.                         *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  When a new owner is specified, the alias creator is not changed
  when referenced in a View text. The DDL might fail when applied
  in DB2.
  

Problem conclusion

Temporary fix

Comments

• The problem has been fixed.
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Modules/Macros

•    ADB2DEP  ADB2RE   ADB2REE  ADB2REG  ADB2REP
  ADB2REZ  ADB2WCL
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R720 PSY UK38992

     UP08/08/30 P F808

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.