PI95642: DB2 ADMIN TOOL - ADB8007E AN ATTEMPT WAS MADE TO CREATE A VIEW THAT ALREADY EXISTS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• A Compare fails with:
  ADB8007E An attempt was made to create a view that already
            exists.
   ADB8057I Object details at the time of error:
                Operation       : 120
                Row type        : ID
                Object qualifier: PDB2I
                Object name     : RP_TRP_DET_083_JV
                Procedure       : merge_views
  
  when the view is not included with the original DDL.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Object Comparison Tool          *
  *                 for z/OS who compare views dependent         *
  *                 on other views using Change Management       *
  *                 function.                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: Analyzing a change which contains       *
  *                      a change to the base view fails         *
  *                      in merge with error ADB8007E.           *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When comparing table, view and view on a view using Change
  Management, the updated base view and its dependent view are
  stored in the registered change. Analyzing the change fails
  because the dependent view already exists in the catalog:
  
  ADB8007E An attempt was made to create
           a view that already exists.
  ADB8057I Object details at the time of error:
         Operation : 120
         Row type : ID
         Object qualifier: xxxxx
         Object name : zzzzz
         Procedure : merge_views
  
  ADBCCME - Error(s) found. Please review output
  

Problem conclusion

• The problem has been resolved. Dependent view which is not
  updated will not be stored in the registered change.
  

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

•    ADB2CME  ADB2CMP
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI56654

     UP18/06/22 P F806

• RC10 PSY UI56655

     UP18/06/22 P F806

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.