PK68069: USING MIG WITH VIEW CREATED WITH AN ALIAS CREATES THE VIEW WITH THE SAME TBOWNER AS THE ALIAS.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• USING MIG WITH VIEW CREATED WITH AN ALIAS CREATES THE VIEW WITH
  THE SAME TBOWNER AS THE ALIAS.
  

Local fix

• APPLY PTF.
  

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

• The problem has been fixed.
  

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

•    GOC2CMF  GOC2CMP  GOC2CMR  GOC2CMS
  

Fix information

• Fixed component name

  DB2 OBJECT COMP

• Fixed component ID

  5697G6400

Applicable component levels

• R720 PSY UK39002

     UP08/08/30 P F809

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.