(Glue-2102) Trigger Management

Owned by SNP
Feb 16, 2021
3 min read

Trigger Management serves for managing triggers created as a part of Glue Extractor with delta type Trigger. This functionality can be accessed from the menu in the Tools tab in the Glue Cockpit screen or by using transaction /DVD/GL_DBT.

After accessing the Trigger Management functionality, a screen with the list of all extractors will be displayed.

List of triggers is composed of several columns:

  • Status - icon with the actual status of the trigger
    • Active (green square) - the trigger is active and it is collecting data
    • Inactive (stop sign) - the trigger is dropped
    • Disabled (yellow triangle) - the trigger is created but it is not collecting data
    • Inconsistent (yellow diamond with exclamation mark) - the trigger is in an inconsistent state and needs to be checked
  • Trigger - name of Database Trigger
  • Type - type of Database system (ORA, MSS, DB4, ADA, SYB, etc.)
  • Object Name - name of the Extractor or Fetcher object which has trigger delta 
  • Table Name - name of the table on which trigger is created
  • Description - description of the table
  • DB Conn. - type of the database connection
  • Sch. Name - name of the database schema
  • Created by - name of the user who created the trigger
  • Created on - date of creation
  • Created at - time of the creation
  • Changed by - name of a user who last changed the trigger
  • Changed on - date of the last change
  • Changed at - time of the last change

On the screen, there are also three buttons. Button Activate will activate selected trigger/s, Deactivate button will deactivate selected triggers/s. 

Button Show Object will display the selected object described in the Object name column. 

After double-clicking on any trigger, a screen with a detailed view of the trigger will be shown.

For active/disabled/inconsistent trigger the Deactivate button is provided with enabled Count Rows button which after using it shows the number of entries in a shadow table. Triggers with inactive status have provided Activate button and Count Rows button is disabled. Next to the name of a shadow table is a button with an arrow that redirects a user to table maintenance of the table.

On the bottom of the screen, specific Database triggers are shown for each DML operation (INSERT, DELETE, UPDATE), with its current status.

In the case of failed deactivation, a confirmation popup will be displayed. After clicking on Yes, trigger's metadata will be changed and logs from failed deactivation with information about changed metadata will be displayed. When option No is chosen, only logs from failed deactivation are displayed.