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 > Change the default deduplication trigger

IBM Tivoli Monitoring, Version 6.3 Fix Pack 2

---

Use nco_sql to modify the agg_deduplication trigger in environments with a bidirectional failover gateway

This section shows you how to use the nco_sql command to modify the deduplication trigger in environments with a bidirectional failover gateway.

1. Open the following file:

   • %OMNIHOME%\extensions\multitier\objectserver\aggregation.sql.

   • $OMNIHOME/extensions/multitier/objectserver/aggregation.sql.

2. Copy the agg_deduplication trigger logic to a temporary file. In this example, the temporary file name is /tmp/agg_dedup.sql.

3. Edit /tmp/agg_dedup.sql and add the line highlighted in bold in the following example so that the trigger ignores IBM Tivoli Monitoring events.

   Only the beginning portion of the agg_deduplication trigger is shown in the example that follows. The remaining logic is not shown because it does not need any modifications. Your agg_deduplication trigger might be different than what is shown in the following example depending on the Netcool/OMNIbus release that you are using or if you have customized the trigger.

   CREATE OR REPLACE TRIGGER agg_deduplication
   GROUP default_triggers
   PRIORITY 2
   COMMENT 'Replacement reinsert trigger (alerts.status) for multi-ObjectServer environments.'
   BEFORE REINSERT ON alerts.status
   FOR EACH ROW
   when (new.Type != 20), and (new.Type != 21)
   declare
   
           now utc;
   begin

4. Save the file, and run the following command to replace the agg_deduplication trigger:

   • %OMNIHOME%\..\bin\redist\isql -U username -P password -S server_name < C:\tmp\agg_ dedup.sql.

   • $OMNIHOME/bin/nco_sql -user username -password password -server server_name < /tmp/agg_dedup.sql.

   where:

   OMNIHOME

   Is the system-defined variable that defines the installation location of Netcool/OMNIbus ObjectServer.

   username

   Is the Netcool/OMNIbus ObjectServer user name.

   password

   Is the Netcool/OMNIbus ObjectServer password.

   server_name

   Is the Netcool/OMNIbus ObjectServer name defined for process control.

Parent topic:

Change the default deduplication trigger

---

+

Search Tips   |   Advanced Search