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 the nco_sql command to modify the deduplication trigger in environments without a bidirectional failover gateway

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

1. Open the following file:

   • %OMNIHOME%\etc\automation.sql.

   • $OMNIHOME/etc/automation.sql.

2. Locate the command that creates the deduplication trigger. See the following example of the deduplication trigger command:

   Your 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 deduplication
   group default_triggers
   priority 1
   comment 'Deduplication processing for ALERTS.STATUS'
   before reinsert on alerts.status
   for each row
   begin
    set old.Tally = old.Tally + 1;
    set old.LastOccurrence = new.LastOccurrence;
    set old.StateChange = getdate();
    set old.InternalLast = getdate();
    set old.Summary = new.Summary;
    set old.AlertKey = new.AlertKey;
    if (( old.Severity = 0), and (new.Severity > 0))
    then  set old.Severity = new.Severity;
    end if;
   end;
   go

3. Copy this command to a temporary file. In this example, the file name is /tmp/dedup.sql.

4. Edit /tmp/dedup.sql and add the line that is highlighted in bold in the following example command so that the trigger ignores IBM Tivoli Monitoring events:

   create or replace trigger deduplication
   group default_triggers
   priority 1
   comment 'Deduplication processing for ALERTS.STATUS'
   before reinsert on alerts.status
   for each row
   when (new.Type != 20), and (new.Type != 21) 
   begin
   set old.Tally = old.Tally + 1;
   set old.LastOccurrence = new.LastOccurrence;
   set old.StateChange = getdate();
   set old.InternalLast = getdate();
   set old.Summary = new.Summary;
   set old.AlertKey = new.AlertKey;
   if (( old.Severity = 0), and (new.Severity > 0))
   then set old.Severity = new.Severity;
   end if;
   end;
   go

5. Save the file, and run the following command to replace the deduplication trigger:

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

   • $OMNIHOME/bin/nco_sql -user username -password password -server server_name < /tmp/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