Updating the OMNIbus database schema in the collection tier

In a Netcool/OMNIbus multitier architecture, add IBM® Tivoli® Monitoring triggers to each ObjectServer in the collection tier.

1. 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.
2. 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.