IBM Support

PI70065: DB2 OBJECT COMPARE RC12 DURING COMPARE WITH ADB7350E ONCODE 8094

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • A COMPARE operation receives a RC12 with message:
    ADB7350E ADB2CMF detected an ONCODE condition 8094
                in DROP_OBJECT at 14259.
    
    The object of comparison is a LOB Table Space which exists in
    target environment. In the source environment the same LOB TS
    doesn't exist.
    
    LOB Tablespace SVL20A.SVL2BAF not found on source.
       Tablespace SVL20A.SVL2BAF will be dropped by dropping
       the database.
    
    ADB7350E Module : ADB2CMF detected an ONCODE condition 8094 in
             DROP_OBJECT at 14259.
    
    ADB7380E Module ADB2CMP - Severe error Compare has been stopped.
    

Local fix

  • Set KEEPTGT on.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of the DB2 Object Comparison           *
    *                 Tool for z/OS who compare a database         *
    *                 which has a LOB table space.                 *
    ****************************************************************
    * PROBLEM DESCRIPTION: Object Compare LOB table spaces         *
    *                      failed with an ONCODE8094 /             *
    *                      ONCODE=8094.                            *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    When the database and LOB table space are both target only and
    the user specifys 'NO' for the 'Suppress DROP of objects'
    option on panel GOC5 'Generate Compare Jobs', Object Compare
    fails with a ADB7350E / msgadb7350e error:
    
    ADB7350E Module : ADB2CMF detected an ONCODE
    condition      8094 in.
              DROP_OBJECT at 14259.
    

Problem conclusion

  • Problem has been resolved.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI70065

  • Reported component name

    DB2 OBJECT COMP

  • Reported component ID

    5697G6400

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-10-04

  • Closed date

    2016-12-29

  • Last modified date

    2017-01-03

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

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

    UI43598 UI43599

Modules/Macros

  •    ADB2CMR
    

Fix information

  • Fixed component name

    DB2 ADMIN TOOL

  • Fixed component ID

    568851500

Applicable component levels

  • RB10 PSY UI43598

       UP17/01/03 P F612

  • RB20 PSY UI43599

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

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSZJXP","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1.0"}]

Document Information

Modified date:
17 March 2021