Update the Netcool/OMNIbus ObjectServer with the attributes and triggers that allow the ObjectServer to correctly process IBM® Tivoli® Monitoring events and forward events to the IBM Tivoli Monitoring Situation Update Forwarder when using bidirectional communication.
To verify if specific customization settings are needed, see Customizing how the IBM Tivoli Monitoring OMNIbus triggers handle event status updates from the monitoring servers.
Perform the steps in this section for each ObjectServer in a single-tier architecture or for each ObjectServer in the aggregation tier of a multitier architecture.
The tasks in this section should be completed by the Netcool/OMNIbus Administrator.
If you are setting up a unidirectional architecture and have installed the IBM Tivoli Monitoring Event Synchronization Component on a system other than your Netcool/OMNIbus ObjectServer, you must manually copy the SQL files to your ObjectServer. The files are located in the event_sync_install_dir/omnibus directory. Also, for a unidirectional architecture, you must modify the contents of the itm_proc.sql file, changing every instance of the word REJECT to the word ACCEPT and ensure that the path specified for the itmfile variable exists on the system with Netcool/OMNIbus ObjectServer. You only need to load the itm_proc.sql and itm_db_update.sql files. If you later decide to convert your environment to a bidirectional architecture, you must also load the itm_sync.sql file.
If you are setting up a bidirectional architecture, you might want to customize the itm_proc.sql file before loading it. For more information, see Customizing how the IBM Tivoli Monitoring OMNIbus triggers handle event status updates from the monitoring servers. Also review the information at the end of the topic about ensuring that the eventcmd procedure is correctly configured to send events back to the hub monitoring server.
If the OMNIbus ObjectServer is running on a UNIX system as a non-root user and the event synchronization component is installed and run as either root or another user, verify that the user under which the ObjectServer is running has write permission to the event_sync_install_dir/log directory before updating the OMNIbus database schema. If the user does not have write permission to this directory there will be error messages related to itmfile when the itm_proc.sql file is loaded into Netcool/OMNIbus and ITM-OMNIbus event synchronization will not work.
The command to configure OMNIbus pipes the SQL command set into the SQL command-line tool and performs the updates to the ObjectServer.
type path_to_file\itm_proc.sql | %OMNIHOME%\..\bin\redist\isql -U username
-P password
-S server_name
type path_to_file\itm_db_update.sql | %OMNIHOME%\..\bin\redist\isql -U username
-P password
-S server_name
Only run this command if you are using the bidirectional
architecture: type path_to_file\itm_sync.sql | %OMNIHOME%\..\bin\redist\isql -U username
-P password
-S server_name
Only run this
command if you are using the bidirectional architecture: type path_to_file\itm_event_cache.sql | %OMNIHOME%\..\bin\redist\isql -U username
-P password
-S server_name
where: $OMNIHOME/bin/nco_sql -user username
-password password
-server server_name
< path_to_file/itm_proc.sql
$OMNIHOME/bin/nco_sql -user username
-password password
-server server_name
< path_to_file/itm_db_update.sql
Only
run this command if you are using the bidirectional architecture: $OMNIHOME/bin/nco_sql -user username
-password password
-server server_name
< path_to_file/itm_sync.sql
Only
run this command if you are using the bidirectional architecture: $OMNIHOME/bin/nco_sql -user username
-password password
-server server_name
< path_to_file/itm_event_cache.sql
where: