PK86262: FIRST DIFFERENCE UNDERLINING APPEARS BELOW EXACT TEXT MATCH IN OC JOBLOG. FFA10 PM30553.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• In DB2 Object Compare Tool, when differences exist between
  source and target VIEW text, the underlining that is reported to
  underline the first difference actually appears under text that
  is an exact match.
  .
  Later text, which differs only because the source is upper case
  and the target is lower case text, is not underlined, making it
  difficult to determine why the VIEW text is reported as changed.
  .
  For example, DISTINCT vs. distinct in the following report:
  .
  ERROR DESCRIPTION:
  <==
      (D)View text has changed. Compared view text follows.
         First difference underlined
    First difference : Source token : PS_ECBUSDOCHDR.ECBUSDOCID
                       Target token : PS_ECBUSDOCHDR.ECBUSDOCID
    View from source (formatted with masks applied) :
    CREATE VIEW PSU5.PS_ECBUSHDR_IN_VW(ECBUSDOCID, ECBUSDOCSTATUS)
    AS
    SELECT DISTINCT PSU5.PS_ECBUSDOCHDR.ECBUSDOCID, ECBUSDOCSTATUS
                         =========================
  ...
  View from target (formatted) :
    CREATE VIEW PSU5.PS_ECBUSHDR_IN_VW(ECBUSDOCID, ECBUSDOCSTATUS)
    AS
    SELECT distinct PSU5.PS_ECBUSDOCHDR.ECBUSDOCID, ECBUSDOCSTATUS
                         =========================
  

Local fix

• n/a - identify true text difference by looking at all text lines
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Object Comparison Tool for  *
  *                 z/OS who compare views.                      *
  ****************************************************************
  * PROBLEM DESCRIPTION: The DB2 Object Comparison Tool          *
  *                      reported a difference in the view text  *
  *                      when none existed. The error was caused *
  *                      by an internal option in the view       *
  *                      comparison procedure that was not set.  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The DB2 Object Comparison Tool dropped and recreated a view
  that had no changes.
  

Problem conclusion

• The 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:

  UK66435

Modules/Macros

• GOC2CMF
  GOC2CMR
  GOC2CMT
  

Fix information

• Fixed component name

  DB2 OBJECT COMP

• Fixed component ID

  5697G6400

Applicable component levels

• R720 PSY UK66435

     UP11/04/08 P F104

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.