PK33766: OBJECT COMPARE DOES NOT ALWAYS GENERATE A CHECK UTILITY STEP EVEN WHEN YES IS SPECIFIED

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Object Compare offers a YES/NO option to run a check data step
  regardless of what transpires in the COMPARE. It does not work
  in all cases. If YES is specified, a CHECK step MUST be created.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Object Comparison Tool, who     *
  *                 have CHECK DATA step, may be affected.       *
  ****************************************************************
  * PROBLEM DESCRIPTION: Object  Compare  offers a YES/NO option *
  *                      to run a  Check Data step regardless of *
  *                      what transpires in the COMPARE. It does *
  *                      not work in all cases.                  *
  *                      .*                                      *
  *                      CHECK  DATA utility is not created when *
  *                      Check  constraints  or foreign keys are *
  *                      added to an existing table.             *
  *                      .*                                      *
  *                      CHECK DATA utility  is not created when *
  *                      Check  constraints  or foreign keys are *
  *                      added  to  an  existing  table and 'Run *
  *                      CHECK DATA'  option is set  to 'Yes' on *
  *                      GOC5 panel.                             *
  *                      .* Note:                                *
  *                      If  YES is specified, a CHECK step MUST *
  *                      be created.                             *
  *                      .* Note:                                *
  *                      Placing  Tablespaces  in Check  Pending *
  *                      should be avoided and the option should *
  *                      be  given  to  run  CHECK  DATA  on the *
  *                      Tablespace.                             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  See Problem Description.
  

Problem conclusion

• Apply the fix.
  

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

•    GOC2CMF  GOC2CMP  GOC2CMR  GOC2CMS
  

Fix information

• Fixed component name

  DB2 OBJECT COMP

• Fixed component ID

  5697G6400

Applicable component levels

• R710 PSY UK21799

     UP07/02/06 P F702

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.