IV89509: REQUIRE AN INDEX ON SERVERSERIAL IN ALERTS.STATUS TO IMPROVE GATEWAY PERFORMANCE.

Direct links to fixes

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

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSSHTQ","label":"Tivoli Netcool\/OMNIbus"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"740","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
17 March 2023

Tips

IV89509: REQUIRE AN INDEX ON SERVERSERIAL IN ALERTS.STATUS TO IMPROVE GATEWAY PERFORMANCE.

Direct links to fixes

Subscribe

APAR status

Closed as new function.

Error description

Local fix

Problem summary

Problem conclusion

Temporary fix

Comments

APAR Information

APAR number

Reported component name

Reported component ID

Reported release

Status

PE

HIPER

Special Attention

Submitted date

Closed date

Last modified date

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

Fixed component ID

Applicable component levels

Document Information

Share your feedback

Need support?