PK98233: DB2 OBJECT COMPARISON RESULTS IN RC=20 UPON FTINCL GOCTUNL IN T04GAPY. INTERMITTENT FOR LARGE CHANGES FILES.FFA10 PM32530

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 OBJECT COMPARISON RESULTS IN RC=20 UPON FTINCL GOCTUNL
  DURING T04GAPY. INTERMITTENT WHILE PROCESSING LARGE CHANGES FILE
  

Local fix

• APPLY PTF.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool and     *
  *                 DB2 Object Comparison Tool for z/OS that     *
  *                 process large change files.                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: The possibility exists as the changes   *
  *                      file becomes larger that internal       *
  *                      tables used to store table names will   *
  *                      get erroneously overwritten causing     *
  *                      mismatched table names in the           *
  *                      generated jobs. This problem will       *
  *                      manifest with a mismatch between        *
  *                      the table name and the table space      *
  *                      name.  One way the problem will show    *
  *                      is as in the error message DSNU1224I in *
  *                      the unload output.  DSNU1224I -N3DB     *
  *                      048 09:11:54.78 DSNUULIA - TABLE OWNER. *
  *                      TABLE IS NOT IN THE TABLE SPACE         *
  *                      DBNAME.TSNAME. RC=20 in the apply job   *
  *                      generation might occur as well.         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The possibility exists as the changes file becomes larger that
  internal tables used to store table names will get erroneously
  overwritten causing mismatched table names in the generated
  jobs.
  

Problem conclusion

• After applying this maintenance, apply job generation should
  be redone for those jobs showing errors.
  

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:

  UK65834 UK65835

Modules/Macros

•    GOCGAJOB
  

Fix information

• Fixed component name

  DB2 OBJECT COMP

• Fixed component ID

  5697G6400

Applicable component levels

• R720 PSY UK65834

     UP11/03/19 P F103

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.