PI19748: DB2 OBJECT COMPARISON TOOL FOR Z/OS, MISCELLANEOUS ENHANCEMENTS.

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• DB2 OBJECT COMPARISON TOOL FOR Z/OS, MISCELLANEOUS ENHANCEMENTS.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Object Comparison Tool for  *
  *                 z/OS.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: The following enhancements are          *
  *                      delivered:                              *
  *                                                              *
  *                      - DB2 Object Compare supports           *
  *                      wildcards when renaming global          *
  *                      variables using RENAMEGV to allow       *
  *                      the user the ability to rename          *
  *                      multiple global variables at one time.  *
  *                                                              *
  *                      - DB2 Object Compare now has            *
  *                      the ability to override attributes      *
  *                      TRACKMOD and DATA CAPTURE for           *
  *                      objects tablespaces and tables.         *
  *                                                              *
  *                      - Support added to ignore changes       *
  *                      to Materialzed Query Table (MQT)        *
  *                      text and MQT options ENABLE /           *
  *                      DISABLE.                                *
  *                                                              *
  *                      - Before DB2 10, when an index's        *
  *                      bufferpool is altered, this index is    *
  *                      placed into REBUILD-pending state.      *
  *                      In DB2 10, this index is placed in      *
  *                      an Advisory REORG-pending state.        *
  *                      A REORG INDEX statement should be       *
  *                      generated to resolve the pending        *
  *                      state.                                  *
  *                                                              *
  *                      - In DB2 11 a new default path level    *
  *                      SYSIBMADM was added.  Support has       *
  *                      been added to recognize the new         *
  *                      default path level SYSIBMADM.           *
  *                                                              *
  *                      - DB2 Object Compare does not allow     *
  *                      a user to modify REORG INDEX            *
  *                      parameters during a Compare.            *
  *                                                              *
  *                      - The MERGE module uses hard coded      *
  *                      messages without error numbers.         *
  *                                                              *
  *                      - DDL to Catalog Compare results in     *
  *                      the following error ADB1664E /          *
  *                      msgadb1664e and ADB7380E /              *
  *                      msgadb7380e when encountering a         *
  *                      GRANT statement on a database,          *
  *                      table space or table:                   *
  *                                                              *
  *                      ADB1664E An internal error occurred.    *
  *                      Diagnostic text=ADB2REG.GRANT_          *
  *                      DATABASE(14897):                        *
  *                      INTERR00000003DA.                       *
  *                      ADB7380E Module ADB2CMP - Severe        *
  *                      error Compare has been stopped.         *
  *                                                              *
  *                      OR                                      *
  *                                                              *
  *                      ADB1664E An internal error occurred.    *
  *                      Diagnostic text=ADB2REG.GRANT_          *
  *                      TABLESPACE(15384):                      *
  *                      INTERR00000003RA.                       *
  *                      ADB7380E Module ADB2CMP - Severe        *
  *                      error Compare has been stopped          *
  *                                                              *
  *                      OR                                      *
  *                                                              *
  *                      ADB1664E An internal error occurred.    *
  *                      Diagnostic text=ADB2REG.GRANT_          *
  *                      TABLE(15059):                           *
  *                      INTERR00000003TA.                       *
  *                      ADB7380E Module ADB2CMP - Severe        *
  *                      error Compare has been stopped.         *
  *                                                              *
  *                      - Support added for new FUNCTION and    *
  *                      PROCEDURE options BUSINESS_TIME         *
  *                      SENSITIVE and SYSTEM_TIME SENSITIVE.    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The following enhancements are delivered:
  
  - DB2 Object Compare supports wildcards when renaming global
  variables using RENAMEGV to allow the user the ability to
  rename multiple global variables at one time.
  
  - DB2 Object Compare now has the ability to override attributes
  TRACKMOD and DATA CAPTURE for objects tablespaces and tables.
  
  - When comparing PATH settings, DB2 Object Compare removes
  all default schema levels before comparing the resulting PATHs.
  Current code does not recognize SYSIBMADM as a default level.
  This causes an invalid PATH difference.
  
  - Added support for ignoring changes to MQT text and MQT
  options ENABLE/DISABLE.
  
  - In DB2 10, when an index's bufferpool is altered, this index
  is placed in an Advisory REORG-pending state. A REORG INDEX
  statement will now be generated to resolve the pending state.
  
  - Users are allowed to go to the utility parameter option panel
  and are now allowed to modify REORG INDEX parameters during the
  Compare process.
  
  - The MERGE module uses messages with error numbers.
  
  - GRANT statements in DDL to Catalog Compare are now
  supported.
  
  - FUNCTION and PROCEDURE options BUSINESS_TIME SENSITIVE and
  SYSTEM_TIME SENSITIVE are now supported by the DB2 Object
  Comparison Tool.
  

Problem conclusion

Temporary fix

Comments

• Enhancements delivered.
  
  Error range ADB8001E to ADB8032E is converted from hard-coded
  messages.
  
  Updates to the DB2 Object Comparison Tool for z/OS Version 11,
  Release 1 User's Guide and Reference can be found in the
  following techdoc:
  
  http://www-01.ibm.com/support/docview.wss?uid=swg27041738
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UI19667

Modules/Macros

•    GOCGCMP
  

Fix information

• Fixed component name

  DB2 OBJECT COMP

• Fixed component ID

  5697G6400

Applicable component levels

• RB10 PSY UI19667

     UP14/07/21 P F407

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.