PK34487: MISSING RUNSTATS WHEN OBJECT COMPARE COMPARES SPACES FOR MULTIPLE DATABASE THAT HAD SEGSIZE CHANGES

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• User compares same source and target DDL files for 6 Databases
  with source objects all changing segsize to 64. User wants the
  Runstats for all of the changes. Object Compare runs with rc=0
  but the APPLY job is missing many of the RUNSTATS for many of
  the changed or created objects. There are runstats for only
  one of the databases but not all of them. However the CREATES
  are correct.
  

Local fix

• Please apply PTF when available.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  *                 Users of Object Compare requesting           *
  *                  runstat utilities in apply processing       *
  *                 for comparison having tables with            *
  *                  same name in different databases.           *
  ****************************************************************
  * PROBLEM DESCRIPTION: Customer compares multiple databases    *
  *                       that have tables with same name in     *
  *                      them. Runstats was only generated on    *
  *                       the tables changed in the last         *
  *                      database compared.                      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Exec Gocgajob modified to create
   runstats for the tables in all
    databases
  modified in the comparison.
  

Problem conclusion

• The problem has been solved
  

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

•    GOCGAJOB
  

Fix information

• Fixed component name

  DB2 OBJECT COMP

• Fixed component ID

  5697G6400

Applicable component levels

• R710 PSY UK22303

     UP07/03/01 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.