In a Netcool/OMNIbus multitier architecture, add IBM® Tivoli® Monitoring
triggers to each ObjectServer in the collection tier.
Before you begin
This task should be performed by a Netcool/OMNIbus administrator.
About this task
Perform the following steps for each Netcool/OMNIbus Object
Server defined in the collection tier.
Procedure
- Copy the collection_itm.sql file from
an ObjectServer in the aggregation tier to each ObjectServer in the
collection tier. The collection_itm.sql file
can found be in the event_sync_install_dir/omnibus/multitier
directory where event_sync_install_dir is
the location where the IBM Tivoli Monitoring Event Synchronization
component is installed on an ObjectServer in the aggregation tier.
- Update the Object Server database with the following command,
which pipes the SQL command set into the SQL command-line tool and
performs the updates to the ObjectServer database:
-
type path_to_file\collection_itm.sql | %OMNIHOME%\..\bin\redist\isql
-U username
-P password
-S server_name
where: - $OMNIHOME
- Is the system-defined variable defining the installation location
of OMNIbus.
- username
- Is the OMNIbus Object Server user name.
- password
- Is the OMNIbus Object Server password.
- server_name
- Is the OMNIbus Object Server name defined for process control.
- path_to_file
- Is the fully qualified path to the specified SQL file.
-
$OMNIHOME/bin/nco_sql -user username
-password password
-server server_name
< path_to_file/collection_itm.sql
where: - $OMNIHOME
- Is the system-defined variable defining the installation location
of OMNIbus
- username
- Is the OMNIbus ObjectServer user name
- password
- Is the OMNIbus ObjectServer password
- server_name
- Is the OMNIbus ObjectServer name defined for process control.
- path_to_file
- Is the fully qualified path to the specified SQL file.