PM81154: COMPARE TWO SCHEMAS FROM CATALOG, CHANGE FILE IS NOT CONSISTENT WITH COMPARE JOBLOG.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Administration Tool for z/OS.
  Compare two schemas from catalog, change file is not consistent
  with compare joblog.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Object Comparison Tool      *
  *                 for z/OS who compare DB2 SQL Scalar          *
  *                 User-defined Functions (UDFs) and Native     *
  *                 Stored Procedures (NSPs).                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: Various problems with dependent         *
  *                      functions and procedures with versions. *
  *                      Versions have been dropped but not      *
  *                      created or new versions were not added  *
  *                      resulting in a SQLCODE =-478 /          *
  *                      SQLCODEN478 /  or SQLCODE=-204 /        *
  *                      SQLCODEN204:                            *
  *                                                              *
  *                      DSNT408I SQLCODE = -478, ERROR:         *
  *                      DROP OR REVOKE ON OBJECT                *
  *                      TYPE >object-type< CANNOT BE            *
  *                      PROCESSED BECAUSE OBJECT                *
  *                      >dependent-object< OF TYPE              *
  *                      >dependent-type< IS DEPENDENT           *
  *                      ON IT                                   *
  *                      DSNT418I SQLSTATE   = 42893             *
  *                      SQLSTATE RETURN CODE                    *
  *                      Additional keyword:  sqlcoden478        *
  *                                                              *
  *                      DSNT408I SQLCODE = -204, ERROR:         *
  *                      >schema.storprocedure< IS AN            *
  *                      UNDEFINED NAME                          *
  *                      DSNT418I SQLSTATE   = 42704             *
  *                      SQLSTATE RETURN CODE                    *
  *                      Additional keyword:  sqlcoden204        *
  *                                                              *
  *                      Versions that should have been          *
  *                      dropped were not dropped                *
  *                      causing SQLCODE=-601 /                  *
  *                      SQLCODEN601:                            *
  *                                                              *
  *                      DSNT408I SQLCODE = -601, ERROR          *
  *                      THE NAME >version_name< OF THE          *
  *                      OBJECT TO BE DEFINED OR THE             *
  *                      TARGET OF A RENAME STATEMENT            *
  *                      IS IDENTICAL TO THE EXISTING            *
  *                      NAME >version_name< >object-name<       *
  *                      OF THE OBJECT TYPE >object-type<        *
  *                      DSNT418I SQLSTATE   = 46002             *
  *                      SQLSTATE RETURN CODE                    *
  *                                                              *
  *                      Additional keyword:  sqlcoden601        *
  *                                                              *
  *                      Functions and Procedures with           *
  *                      multiple versions are listed in the     *
  *                      Object Compare Summary                  *
  *                      Reports without version names.          *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Functions and Procedures with multiple versions are listed in
  the summary reports without version names.
  

Problem conclusion

• Problem has been resolved.
  

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  ADB2CMP  ADB2CMR  ADB2CMS  ADB2CMT
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UK92243

     UP13/03/07 P F303

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.