PM81415: LACKING OF DETAILED COMPARISON RESULT FOR NATIVE SQL PROCEDURE DEFINITION IN COMPARE REPORT.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• For the DB2 Object Comparison Tool for z/OS,
  on Panel GOC5RO "Specify Compare Reporting Options",
  if option "Only changed objects"= YES, but this comparison
  and the procedure has a change and will be drop/recreated
  ,  this change will not be reported in the
  "OBJECT COMPARISON REPORT" section.
  However, it will still be reported in the
  "COMPARISON SUMMARY REPORT" section, and will not be
  missed in the CHANGE file.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Object Comparison Tool      *
  *                 for z/OS who compare Native Stored           *
  *                 Procedures (NSP).                            *
  ****************************************************************
  * PROBLEM DESCRIPTION: Object Compare did not report changes   *
  *                      to Native Stored Procedures (NSP) if    *
  *                      the report option 'Only changed         *
  *                      objects' on panel GOC5RO 'Specify       *
  *                      Compare Reporting Options' was set to   *
  *                      'YES'. The change was reported          *
  *                      correctly in the COMPARISON SUMMARY     *
  *                      REPORT and the correct SQL statements   *
  *                      were generated in the CHANGE file.      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Object Compare did not report changes to Native Stored
  Procedures (NSP) if the report option on panel GOC5RO 'Specify
  Compare Reporting Options', 'Only changed objects'=YES.
  

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:

  UK91422

Modules/Macros

•    ADB2CMS
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UK91422

     UP13/02/08 P F302

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.