IBM Tivoli Monitoring > Version 6.3 Fix Pack 2 > Installation Guides > Installation Guide > Set up event forwarding to Netcool/OMNIbus > Installation and configuration > Update the Netcool/OMNIbus ObjectServer with IBM Tivoli Monitoring attributes, tables, and triggers

IBM Tivoli Monitoring, Version 6.3 Fix Pack 2

Update 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.

This task should be performed by a Netcool/OMNIbus administrator.


Perform the following steps for each Netcool/OMNIbus Object Server defined 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.


Parent topic:

Update the Netcool/OMNIbus ObjectServer with IBM Tivoli Monitoring attributes, tables, and triggers

+

Search Tips   |   Advanced Search