drop event trigger

Description

Removes a trigger that the RMS is monitoring. A trigger identifies a process or script that is executed by the RMS. Set triggers up using the add trigger command.

Syntax

drop {status | latency | size} trigger 
         [{connection | logical connection | route | queue | rep agent |
           partition} [component_name]]
         [with primary primary_connection]
         for server_name
         {status changes to state |
          size {exceeds | falls below} size_threshold |
          latency {exceeds | falls below} latency_threshold}

Parameters

Examples

Example 1

Removes the “DOWN” status trigger for the server INVENTORY_RS:

drop status trigger for INVENTORY_RS
    status changes to DOWN

Example 2

Removes the “SUSPENDED” status trigger for the connection “inventory_pds.pdb1” of server INVENTORY_RS:

drop status trigger connection inventory_pds.pdb1
    for inventory_rs
    status changes to SUSPENDED

Example 3

Drops a partition size trigger:

drop size trigger partition p1
   for INVENTORY_RS
   size exceeds 80

Example 4

Drops a latency connection trigger:

drop latency trigger
   connection inventory_rds.vendor
   with primary inventory_pds.ventory
   for INVENTORY_RS
   latency exceeds 300

Usage

drop trigger returns the following result set:

See also