PK32805: GOC PERFORMANCE ISSUE WHEN DEALING WITH LARGE DDL SETS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Object Comparision Tool displays poor performance when
  dealing with large DDL sets ( 1+ million lines of DDL for
  example ).
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Object Comparison Tool, who     *
  *                 use large DDL files, may be affected.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: Poor performance was encountered when   *
  *                      large DDL sets ( 1+ million lines of    *
  *                      DDL for example ), were used.           *
  *                      .*                                      *
  *                      Long DTC runtime was reported if very   *
  *                      large DDL files were used.              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  See Problem Description.
  

Problem conclusion

• Apply the fix to relieve the performance situation of using
  GOC2DTC when large DDL sets are used.
  

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

•    GOC2DTC
  

Fix information

• Fixed component name

  DB2 OBJECT COMP

• Fixed component ID

  5697G6400

Applicable component levels

• R710 PSY UK20898

     UP06/12/30 P F612

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.