IBM Support

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

A fix is available

Subscribe

You can track all active APARs for this component.

 

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

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 number

    PM32530

  • Reported component name

    DB2 ADMIN TOOL

  • Reported component ID

    568851500

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-02-13

  • Closed date

    2011-03-16

  • Last modified date

    2011-04-04

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    UK65864

Modules/Macros

  •    ADBGAJOB
    

Fix information

  • Fixed component name

    DB2 ADMIN TOOL

  • Fixed component ID

    568851500

Applicable component levels

  • RA10 PSY UK65864

       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.

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCVQTD","label":"IBM Db2 Administration Tool for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
04 April 2011