IBM Support

IV57465: OBJECTSERVER GATEWAYS DO NOT ISSUE BULK SQL FOR INSERTS CONVERTED TO UPDATES DUE TO UPDTOINS MODE ENABLED"

Direct links to fixes

7.4.0-TIV-NCOMNIbus-ZLinux-FP0011
7.4.0-TIV-NCOMNIbus-Windows-FP0011
7.4.0-TIV-NCOMNIbus-Solaris-FP0011
7.4.0-TIV-NCOMNIbus-Linux-FP0011
7.4.0-TIV-NCOMNIbus-AIX-FP0011
7.4.0-TIV-NCOMNIbus-HPUXIA-FP0011
7.3.1-TIV-NCOMNIbus-Windows-FP0015
7.3.1-TIV-NCOMNIbus-Solaris-FP0015
7.3.1-TIV-NCOMNIbus-Linux-FP0015
7.3.1-TIV-NCOMNIbus-ZLinux-FP0015
7.3.1-TIV-NCOMNIbus-HPUXIA-FP0015
7.3.1-TIV-NCOMNIbus-AIX-FP0015
7.4.0-TIV-NCOMNIbus-Windows-FP0010
7.4.0-TIV-NCOMNIbus-Solaris-FP0010
7.4.0-TIV-NCOMNIbus-Linux-FP0010
7.4.0-TIV-NCOMNIbus-ZLinux-FP0010
7.4.0-TIV-NCOMNIbus-HPUXIA-FP0010
7.4.0-TIV-NCOMNIbus-AIX-FP0010
7.4.0-TIV-NCOMNIbus-Windows-FP0009
7.4.0-TIV-NCOMNIbus-ZLinux-FP0009
7.4.0-TIV-NCOMNIbus-Solaris-FP0009
7.4.0-TIV-NCOMNIbus-Linux-FP0009
7.4.0-TIV-NCOMNIbus-HPUXIA-FP0009
7.4.0-TIV-NCOMNIbus-AIX-FP0009
7.4.0-TIV-NCOMNIbus-HPUXIA-FP0008
7.4.0-TIV-NCOMNIbus-Windows-FP0008
7.4.0-TIV-NCOMNIbus-Solaris-FP0008
7.4.0-TIV-NCOMNIbus-Linux-FP0008
7.4.0-TIV-NCOMNIbus-ZLinux-FP0008
7.4.0-TIV-NCOMNIbus-AIX-FP0008
7.3.1-TIV-NCOMNIbus-Windows-FP0013
7.3.1-TIV-NCOMNIbus-Solaris-FP0013
7.3.1-TIV-NCOMNIbus-Linux-FP0013
7.3.1-TIV-NCOMNIbus-ZLinux-FP0013
7.3.1-TIV-NCOMNIbus-HPUXIA-FP0013
7.3.1-TIV-NCOMNIbus-HPUX-FP0013
7.3.1-TIV-NCOMNIbus-AIX-FP0013
7.4.0-TIV-NCOMNIbus-Windows-FP0007
7.4.0-TIV-NCOMNIbus-Solaris-FP0007
7.4.0-TIV-NCOMNIbus-Linux-FP0007
7.4.0-TIV-NCOMNIbus-ZLinux-FP0007
7.4.0-TIV-NCOMNIbus-HPUXIA-FP0007
7.4.0-TIV-NCOMNIbus-AIX-FP0007
7.3.1-TIV-NCOMNIbus-Windows-FP0012
7.3.1-TIV-NCOMNIbus-Solaris-FP0012
7.3.1-TIV-NCOMNIbus-Linux-FP0012
7.3.1-TIV-NCOMNIbus-ZLinux-FP0012
7.3.1-TIV-NCOMNIbus-HPUXIA-FP0012
7.3.1-TIV-NCOMNIbus-HPUX-FP0012
7.3.1-TIV-NCOMNIbus-AIX-FP0012
7.4.0-TIV-NCOMNIbus-Windows-FP0006
7.4.0-TIV-NCOMNIbus-Solaris-FP0006
7.4.0-TIV-NCOMNIbus-ZLinux-FP0006
7.4.0-TIV-NCOMNIbus-Linux-FP0006
7.4.0-TIV-NCOMNIbus-HPUXIA-FP0006
7.4.0-TIV-NCOMNIbus-AIX-FP0006
7.3.1-TIV-NCOMNIbus-Windows-FP0011
7.3.1-TIV-NCOMNIbus-Solaris-FP0011
7.3.1-TIV-NCOMNIbus-Linux-FP0011
7.3.1-TIV-NCOMNIbus-ZLinux-FP0011
7.3.1-TIV-NCOMNIbus-HPUXIA-FP0011
7.3.1-TIV-NCOMNIbus-HPUX-FP0011
7.3.1-TIV-NCOMNIbus-AIX-FP0011
7.4.0-TIV-NCOMNIbus-Linux-FP0005
7.4.0-TIV-NCOMNIbus-Windows-FP0005
7.4.0-TIV-NCOMNIbus-Solaris-FP0005
7.4.0-TIV-NCOMNIbus-ZLinux-FP0005
7.4.0-TIV-NCOMNIbus-HPUXIA-FP0005
7.4.0-TIV-NCOMNIbus-AIX-FP0005
Tivoli Netcool/OMNIbus 7.4.0 Fix Pack 4, 7.4.0-TIV-NCOMNIbus-FP0004
Tivoli Netcool/OMNIbus 7.3.1 Fix Pack 10, 7.3.1-TIV-NCOMNIbus-FP0010
Tivoli Netcool/OMNIbus 7.4.0 Fix Pack 5, 7.4.0-TIV-NCOMNIbus-FP0005
Tivoli Netcool/OMNIbus 7.3.1 Fix Pack 11, 7.3.1-TIV-NCOMNIbus-FP0011
Tivoli Netcool/OMNIbus 7.3.1 Fix Pack 12, 7.3.1-TIV-NCOMNIbus-FP0012
Tivoli Netcool/OMNIbus 7.4.0 Fix Pack 6, 7.4.0-TIV-NCOMNIbus-FP0006
Tivoli Netcool/OMNIbus 7.3.1 Fix Pack 13, 7.3.1-TIV-NCOMNIbus-FP0013
Tivoli Netcool/OMNIbus 7.4.0 Fix Pack 8, 7.4.0-TIV-NCOMNIbus-FP0008
Tivoli Netcool/OMNIbus 7.4.0 Fix Pack 7, 7.4.0-TIV-NCOMNIbus-FP0007
Tivoli Netcool/OMNIbus 7.4.0 Fix Pack 9, 7.4.0-TIV-NCOMNIbus-FP0009
Tivoli Netcool/OMNIbus 7.3.1 Fix Pack 15, 7.3.1-TIV-NCOMNIbus-FP0015
Tivoli Netcool/OMNIbus 7.4.0 Fix Pack 10, 7.4.0-TIV-NCOMNIbus-FP0010
Tivoli Netcool/OMNIbus 7.4.0 Fix Pack 11, 7.4.0-TIV-NCOMNIbus-FP0011
Tivoli Netcool/OMNIbus 7.4.0 Fix Pack 12, 7.4.0-TIV-NCOMNIbus-FP0012
Tivoli Netcool/OMNIbus 7.3.1 Fix Pack 14, 7.3.1-TIV-NCOMNIbus-FP0014
Tivoli Netcool/OMNIbus 7.4.0 Fix Pack 13, 7.4.0-TIV-NCOMNIbus-FP0013
Tivoli Netcool/OMNIbus 7.4.0 Fix Pack 14, 7.4.0-TIV-NCOMNIbus-FP0014
Tivoli Netcool/OMNIbus 7.4.0 Fix Pack 15, 7.4.0-TIV-NCOMNIbus-FP0015
Tivoli Netcool/OMNIbus 7.4.0 Fix Pack 16, 7.4.0-TIV-NCOMNIbus-FP0016
Tivoli Netcool/OMNIbus 7.4.0 Fix Pack 17, 7.4.0-TIV-NCOMNIbus-FP0017
Tivoli Netcool/OMNIbus 7.4.0 Fix Pack 18, 7.4.0-TIV-NCOMNIbus-FP0018

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Propagation Delay was observed by the Unidirectional gateway
    between the Aggregation to Display layer. This also applies to
    Collection to Aggregation Object Server gateways using the
    multitier configuration.
    
    This APAR is applicable to any Object Server gateway with
    UPDTOINS set in the table replication definition file and the
    UseBulkInsCmd property set to TRUE.
    

Local fix

  • n/a
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Users of Object Server gateways with BULK SQL enabled and    *
    * UPDTOINS CHECK set to convert updates to inserts             *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * The ObjectServer gateway would not use bulk sql statements   *
    * (when configured to) for updates converted to inserts due to *
    * the UPDTOINS CHECK setting.                                  *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Apply the maintenance vehicles listed in the Problem         *
    * Conclusion.                                                  *
    ****************************************************************
    

Problem conclusion

  • The fix for this APAR is contained in the following maintenance
    packages:
    | fix pack | 7.3.1-TIV-NCOMNIbus-FP0010
    | fix pack | 7.4.0-TIV-NCOMNIbus-FP0004
    

Temporary fix

Comments

APAR Information

  • APAR number

    IV57465

  • Reported component name

    NETCOOL/OMNIBUS

  • Reported component ID

    5724O4800

  • Reported release

    740

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2014-03-26

  • Closed date

    2014-03-27

  • Last modified date

    2015-04-02

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

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

Fix information

  • Fixed component name

    NETCOOL/OMNIBUS

  • Fixed component ID

    5724O4800

Applicable component levels

  • R731 PSN

       UP

  • R731 PSY

       UP

  • R740 PSN

       UP

  • R740 PSY

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSSHTQ","label":"Tivoli Netcool\/OMNIbus"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"740","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
23 July 2021