Direct links to fixes
8.1.0-TIV-NCOMNIbus-ZLinux-FP0030
8.1.0-TIV-NCOMNIbus-Windows-FP0030
8.1.0-TIV-NCOMNIbus-Linux-FP0030
8.1.0-TIV-NCOMNIbus-AIX-FP0030
8.1.0-TIV-NCOMNIbus-ZLinux-FP0029
8.1.0-TIV-NCOMNIbus-Windows-FP0029
8.1.0-TIV-NCOMNIbus-Linux-FP0029
8.1.0-TIV-NCOMNIbus-AIX-FP0029
8.1.0-TIV-NCOMNIbus-ZLinux-FP0028
8.1.0-TIV-NCOMNIbus-Windows-FP0028
8.1.0-TIV-NCOMNIbus-Linux-FP0028
8.1.0-TIV-NCOMNIbus-AIX-FP0028
8.1.0-TIV-NCOMNIbus-ZLinux-FP0026
8.1.0-TIV-NCOMNIbus-Windows-FP0026
8.1.0-TIV-NCOMNIbus-Linux-FP0026
8.1.0-TIV-NCOMNIbus-AIX-FP0026
8.1.0-TIV-NCOMNIbus-ZLinux-FP0024
8.1.0-TIV-NCOMNIbus-Windows-FP0024
8.1.0-TIV-NCOMNIbus-Linux-FP0024
8.1.0-TIV-NCOMNIbus-AIX-FP0024
8.1.0-TIV-NCOMNIbus-ZLinux-FP0023
8.1.0-TIV-NCOMNIbus-Windows-FP0023
8.1.0-TIV-NCOMNIbus-Linux-FP0023
8.1.0-TIV-NCOMNIbus-AIX-FP0023
8.1.0-TIV-NCOMNIbus-ZLinux-FP0022
8.1.0-TIV-NCOMNIbus-Windows-FP0022
8.1.0-TIV-NCOMNIbus-Linux-FP0022
8.1.0-TIV-NCOMNIbus-AIX-FP0022
8.1.0-TIV-NCOMNIbus-ZLinux-FP0021
8.1.0-TIV-NCOMNIbus-Windows-FP0021
8.1.0-TIV-NCOMNIbus-Linux-FP0021
8.1.0-TIV-NCOMNIbus-AIX-FP0021
8.1.0-TIV-NCOMNIbus-ZLinux-FP0020
8.1.0-TIV-NCOMNIbus-Windows-FP0020
8.1.0-TIV-NCOMNIbus-Linux-FP0020
8.1.0-TIV-NCOMNIbus-AIX-FP0020
8.1.0-TIV-NCOMNIbus-ZLinux-FP0019
8.1.0-TIV-NCOMNIbus-Windows-FP0019
8.1.0-TIV-NCOMNIbus-Linux-FP0019
8.1.0-TIV-NCOMNIbus-AIX-FP0019
8.1.0-TIV-NCOMNIbus-ZLinux-FP0018
8.1.0-TIV-NCOMNIbus-Windows-FP0018
8.1.0-TIV-NCOMNIbus-Linux-FP0018
8.1.0-TIV-NCOMNIbus-AIX-FP0018
8.1.0-TIV-NCOMNIbus-ZLinux-FP0017
8.1.0-TIV-NCOMNIbus-Windows-FP0017
8.1.0-TIV-NCOMNIbus-Linux-FP0017
8.1.0-TIV-NCOMNIbus-AIX-FP0017
8.1.0-TIV-NCOMNIbus-ZLinux-FP0016
8.1.0-TIV-NCOMNIbus-Windows-FP0016
8.1.0-TIV-NCOMNIbus-Linux-FP0016
8.1.0-TIV-NCOMNIbus-AIX-FP0016
8.1.0-TIV-NCOMNIbus-ZLinux-FP0015
8.1.0-TIV-NCOMNIbus-Windows-FP0015
8.1.0-TIV-NCOMNIbus-Linux-FP0015
8.1.0-TIV-NCOMNIbus-AIX-FP0015
8.1.0-TIV-NCOMNIbus-ZLinux-FP0014
8.1.0-TIV-NCOMNIbus-Windows-FP0014
8.1.0-TIV-NCOMNIbus-Linux-FP0014
8.1.0-TIV-NCOMNIbus-AIX-FP0014
8.1.0-TIV-NCOMNIbus-ZLinux-FP0013
8.1.0-TIV-NCOMNIbus-Windows-FP0013
8.1.0-TIV-NCOMNIbus-Linux-FP0013
8.1.0-TIV-NCOMNIbus-AIX-FP0013
8.1.0-TIV-NCOMNIbus-ZLinux-FP0012
8.1.0-TIV-NCOMNIbus-Windows-FP0012
8.1.0-TIV-NCOMNIbus-Linux-FP0012
8.1.0-TIV-NCOMNIbus-AIX-FP0012
8.1.0-TIV-NCOMNIbus-ZLinux-FP0011
8.1.0-TIV-NCOMNIbus-Windows-FP0011
8.1.0-TIV-NCOMNIbus-Linux-FP0011
8.1.0-TIV-NCOMNIbus-AIX-FP0011
8.1.0-TIV-NCOMNIbus-ZLinux-FP0010
8.1.0-TIV-NCOMNIbus-Windows-FP0010
8.1.0-TIV-NCOMNIbus-Linux-FP0010
8.1.0-TIV-NCOMNIbus-AIX-FP0010
Tivoli Netcool/OMNIbus 8.1.0 Fix Pack 10, 8.1.0-TIV-NCOMNIbus-FP0010
Tivoli Netcool/OMNIbus 7.4.0 Fix Pack 13, 7.4.0-TIV-NCOMNIbus-FP0013
Tivoli Netcool/OMNIbus 8.1.0 Fix Pack 11, 8.1.0-TIV-NCOMNIbus-FP0011
Tivoli Netcool/OMNIbus 8.1.0 Fix Pack 12, 8.1.0-TIV-NCOMNIbus-FP0012
Tivoli Netcool/OMNIbus 8.1.0 Fix Pack 13, 8.1.0-TIV-NCOMNIbus-FP0013
Tivoli Netcool/OMNIbus 7.4.0 Fix Pack 14, 7.4.0-TIV-NCOMNIbus-FP0014
Tivoli Netcool/OMNIbus 8.1.0 Fix Pack 14, 8.1.0-TIV-NCOMNIbus-FP0014
Tivoli Netcool/OMNIbus 7.4.0 Fix Pack 15, 7.4.0-TIV-NCOMNIbus-FP0015
Tivoli Netcool/OMNIbus 8.1.0 Fix Pack 15, 8.1.0-TIV-NCOMNIbus-FP0015
Tivoli Netcool/OMNIbus 7.4.0 Fix Pack 16, 7.4.0-TIV-NCOMNIbus-FP0016
Tivoli Netcool/OMNIbus 8.1.0 Fix Pack 16, 8.1.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
Tivoli Netcool/OMNIbus 8.1.0 Fix Pack 17, 8.1.0-TIV-NCOMNIbus-FP0017
Tivoli Netcool/OMNIbus 8.1.0 Fix Pack 18, 8.1.0-TIV-NCOMNIbus-FP0018
Tivoli Netcool/OMNIbus 8.1.0 Fix Pack 19, 8.1.0-TIV-NCOMNIbus-FP0019
Tivoli Netcool/OMNIbus 8.1.0 Fix Pack 20, 8.1.0-TIV-NCOMNIbus-FP0020
Tivoli Netcool/OMNIbus 8.1.0 Fix Pack 21, 8.1.0-TIV-NCOMNIbus-FP0021
Tivoli Netcool/OMNIbus 8.1.0 Fix Pack 22, 8.1.0-TIV-NCOMNIbus-FP0022
Tivoli Netcool/OMNIbus 8.1.0 Fix Pack 23, 8.1.0-TIV-NCOMNIbus-FP0023
Tivoli Netcool/OMNIbus 8.1.0 Fix Pack 24, 8.1.0-TIV-NCOMNIbus-FP0024
Tivoli Netcool/OMNIbus 8.1.0 Fix Pack 26, 8.1.0-TIV-NCOMNIbus-FP0026
Tivoli Netcool/OMNIbus 8.1.0 Fix Pack 25, 8.1.0-TIV-NCOMNIbus-FP0025
Tivoli Netcool/OMNIbus 8.1.0 Fix Pack 27, 8.1.0-TIV-NCOMNIbus-FP0027
Tivoli Netcool/OMNIbus 8.1.0 Fix Pack 28, 8.1.0-TIV-NCOMNIbus-FP0028
Tivoli Netcool/OMNIbus 8.1.0 Fix Pack 29, 8.1.0-TIV-NCOMNIbus-FP0029
APAR status
Closed as new function.
Error description
Many selects performed by gateways have a list of ServerSerial values in the where clause, a hash index on this field in alerts.status will improve the performance of these select statements and avoid the need for a full table scan.
Local fix
create index serverserial on alerts.status using hash (ServerSerial); go
Problem summary
**************************************************************** * USERS AFFECTED: * * Users of Objectservers with ObjectServer gateways attached. * **************************************************************** * PROBLEM DESCRIPTION: * * ObjectServer Gateway performance can be improved by adding * * an index on alerts.status.ServerSerial. This index has now * * been added to the default application.sql file so any new * * ObjectServers created will have the index automatically. * * Please see the README for details of updating existing * * ObjectServers. * **************************************************************** * RECOMMENDATION: * * Apply the maintenance vehicles listed in the Problem * * Conclusion and read the associated README for details of * * updating existing ObjectServers. * ****************************************************************
Problem conclusion
The fix for this APAR is contained in the following maintenance packages: | fix pack | 8.1.0-TIV-NCOMNIbus-FP0010 | fix pack | 7.4.0-TIV-NCOMNIbus-FP0013
Temporary fix
Comments
APAR Information
APAR number
IV89509
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
2016-09-29
Closed date
2017-03-29
Last modified date
2017-03-29
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
Document Information
Modified date:
17 March 2023