IBM Support

PM88599: DB2 ADMINISTRATION TOOL FOR Z/OS WHEN ADDING VERSIONING TO A TEMPORAL TABLE ENCOUNTERS ONCODE 8094 IN THE ADB2CMP COMPONENT

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • DB2 Administration Tool for z/OS when adding versioning to a
    temporal table encounters ONCODE 8094 in the ADB2CMP component
    during processing of the ALTER in batch
    .
    Additional information:
    ADB7350E Module : ADB2CMP detected an ONCODE condition      8094
    in
      TGT_INPUT at 12703
    ADB0380E Module ADB2CMP - Severe error Alter  terminates
    

Local fix

Problem summary

  •   USERS AFFECTED: Users of the DB2 Administration or DB2
                      Object Comparison Tool for z/OS who
                      use the ALT 'Alter Table ALT' function
                      or who use the Compare function to add
                      versioning to a temporal table.
    
      PROBLEM DESCRIPTION: When adding versioning to a temporal
                           table or when comparing temporal and
                           history tables, an ONCODE8094 /
                           ONCODE 8094 error is observed in the
                           ADB2CMP module during processing of
                           the ALTER Analysis, and error
                           messages ADB7350E / msgadb7350e /
                           ADB0308E / msgadb0308e are
                           displayed:
    
                           ADB7350E Module : ADB2CMP
                           detected an ONCODE condition
                           8094  in  TGT_INPUT at 12703
                           ADB0380E Module ADB2CMP -
                           Severe error Alter  terminates
    
      RECOMMENDATION:
    
    When adding versioning to a temporal table or when comparing
    temporal and history tables, an ONCODE8094 / ONCODE 8094
    error is observed, and error messages ADB7350E / msgadb7350e /
    ADB0308E / msgadb0308e are displayed:
    
    ADB7350E Module : ADB2CMP
    detected an ONCODE condition
    8094  in  TGT_INPUT at 12703
    ADB0380E Module ADB2CMP -
    Severe error Alter  terminates
    

Problem conclusion

  • Problem has been resolved.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM88599

  • Reported component name

    DB2 ADMIN TOOL

  • Reported component ID

    568851500

  • Reported release

    A20

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2013-05-07

  • Closed date

    2013-06-17

  • Last modified date

    2013-07-03

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

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

Modules/Macros

  • ADB2CMP
    

Fix information

  • Fixed component name

    DB2 ADMIN TOOL

  • Fixed component ID

    568851500

Applicable component levels

  • RA10 PSY UK95037

       UP13/06/19 P F306

  • RA20 PSY UK95055

       UP13/06/19 P F306

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":"10.2.0"}]

Document Information

Modified date:
31 March 2021