PI81829: DB2 ADMIN TOOL - IMPROVE MESSAGE ADB8052E A CHANGE WAS FOUND FOR <OBJECT> BUT NO BASE DEFINITION WAS FOUND

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• CM BATCH IMPORT/ANALYZE a DDL :
  
  RENAME TABLE DB2IVP0.VIEW TO REN_VIEW
  
  This results in a MERGE error :
  MERGE REPORT
  ============
  ADB8052E A change was found for DB2IVP0."VIEW" but no base
           definition was found.
  
  ADB8057I Object details at the time of error:
  Operation : 120
  Row type : ID
  Object qualifier: DB2IVP0
  Object name : VIEW
  Procedure : merge_files
  
  The underlying object exists in the catalog. So the message is
  wrong and misleading.
  
  However - RENAME attempt is for a VIEW - and that is not
  possible. The SQL error is :
  SQLCODE : -156 DSNTIAR CODE : 0
  DSNT408I SQLCODE = -156, ERROR: THE STATEMENT DOES NOT
           IDENTIFY A TABLE
  
  Nevertheless - the error message thrown is misleading and
  requires a better meaningful message pointing the enduser
  to the cause of the problem.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool or DB2      *
  *                 Object Comparison Tool for z/OS who          *
  *                 analyze a change.                            *
  ****************************************************************
  * PROBLEM DESCRIPTION: When a user analyzes a change with      *
  *                      a RENAME TABLE statement that           *
  *                      contains the name of a VIEW, Merge      *
  *                      fails with an error ADB8052E /          *
  *                      msgadb8052e:                            *
  *                                                              *
  *                      ADB8052E A change was found for         *
  *                      obj_name but no base definition was     *
  *                      found.                                  *
  *                                                              *
  *                      Specifying a VIEW as a table            *
  *                      name is allowed; thus, Merge tries      *
  *                      to find a specified table object.       *
  *                      However, the VIEW with the              *
  *                      specified name may exist on a target    *
  *                      system. The error message is            *
  *                      misleading in such case.                *
  *                      To resolve the issue, a new message     *
  *                      ADB8059E is introduced.                 *
  *                                                              *
  *                      ADB8059E                                *
  *                      A RENAME change was found for a         *
  *                      object_type obj_name but no base        *
  *                      definition was found.                   *
  *                      Explanation:                            *
  *                      A rename change exists for an           *
  *                      object type and name that is            *
  *                      not found.                              *
  *                      User Response:                          *
  *                      Ensure that object being renamed is     *
  *                      specified correctly, correct the        *
  *                      appropriate statements, and run the     *
  *                      job again. Details about the object     *
  *                      that caused the error are provided      *
  *                      in message ADB8057I.                    *
  *                      System Action:                          *
  *                      Processing stops.                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When a user analyzes a change with RENAME TABLE statement that
  contains a VIEW name, Merge fails with an error ADB8052E /
  msgadb8052e.
  

Problem conclusion

• Problem has been resolved.
  New message ADB8059E / msgadb8059e has been created.
  

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

•    ADB8000
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB10 PSY UI48497

     UP17/07/07 P F707

• RB20 PSY UI48498

     UP17/07/07 P F707

• RC10 PSY UI48499

     UP17/07/07 P F707

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.