PM29924: COMPARISON OF TABLE/INDEX CREATED PRIOR TO V9 WITH OWNER=BLANK (D)FIELD OWNER CHANGED FROM '' TO TARGET OWNER FFA10 PM20528.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When using DB2 Object Comparison Tool for z/OS, objects
  created prior to DB2 9 will have OWNER = ''.  Comparison
  will find the difference and will show message
  Compare table source(Source.xxxxx) and target(Target.xxxxx)
      (D)Field OWNER changed from '' to <Target>
  .
  Should be:
      (D)Field OWNER changed from '' to <Source>
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Object Comparison Tool for  *
  *                 z/OS who compare objects created prior to    *
  *                 DB2 9 with objects created with DB2 9 or     *
  *                 later.                                       *
  ****************************************************************
  * PROBLEM DESCRIPTION: Two issues have been reported:          *
  *                                                              *
  *                      1. DB2 Object Comparison Tool compares  *
  *                      a blank owner from objects created      *
  *                      prior to DB2 9, causing the drop and    *
  *                      recreate of the object.                 *
  *                                                              *
  *                      2. In the DB2 Object Comparison Report  *
  *                      the target owner is used instead of     *
  *                      the source owner when the difference    *
  *                      is being reported:                      *
  *                                                              *
  *                      (D)Field OWNER changed from '' to       *
  *                      xxx                                     *
  *                      ==> This is target tbcreator            *
  *                      NOT OWNER                               *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Two issues have been reported:
  
  1. DB2 Object Comparison Tool compares a blank owner from
  objects created prior to DB2 9, causing the drop and recreate
  of the object.
  
  2. In the DB2 Object Comparison Report the target owner is
  used instead of the source owner when the difference is being
  reported.
  

Problem conclusion

• 1. DB2 Object Comparison Tool has been updated to not compare a
  blank owner.
  
  2. The user specified masking for AUTHID which has the
  following hierarchy:
  
    AUTHID
      SQLID
      SCHEMA
        TBSCHEMA,IXSCHEMA
      OWNER
        DBOWNER,TSOWNER,TBOWNER,IXOWNER
  
  The DB2 Object Comparison Tool correctly applied the AUTHID
  mask to the source owner.  The mask had the same value as the
  owner from target.
  

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

•    ADB2CMF  ADB2CMT
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK66440

     UP11/04/08 P F104

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.