(Glue-2208) Trigger Management

Trigger Management serves for managing triggers created as a part of SNP Glue™ Extractor with delta type Trigger. This functionality can be accessed from the menu in the Tools tab in the SNP 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.

The 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 
• Shadow table count - number of entries in the shadow table. To update this column, select triggers in ALV and then press the button Count rows in ALV toolbar. 
• 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 been provided with Activate button and Count Rows button is disabled. Next to the name of a shadow table is a button that redirects a user to table maintenance of the table.

Editable parameters Cache size and Number of partitions are available only for HANA triggers and can be set only for triggers with saved status.

The Cache size specifies which range of sequence numbers will be cached in a node. By default Cache size is not set which means that sequence numbers will not be cached in a node.

The Number of partitions specifies the number of partitions created on column TIMESTAMP for the shadow table. By specifying the number of partitions and activating trigger shadow table will be partitioned by hash function. By specifying the number of partitions to 0 merges of existing partitions will be performed. Operations table partition and merge of table partitions may take a long time depending on the size of the table, available system resources, and so on.

If partitioning operation will be performed warning popup will be displayed before activation of triggers. By confirming the popup activation of the trigger will continue. Option No will cancel the activation.

If merge of existing partitions will be performed warning popup will be displayed before activation of triggers. By confirming the popup activation of the trigger will continue. Option No will cancel the activation.

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. 

Trigger Mass Deactivation→Reactivation

There is a possibility to mass deactivate and reactivate triggers via trigger reactivation report. This is accessible from the SNP Glue™ cockpit.

Using this functionality it is possible to mass deactivate and then reactivate triggers.

Deactivation - Deactivate triggers using the select option. If the select option is empty all active triggers are deactivated.

Reactivation - Reactivate triggers that were deactivated using this functionality if the select option is empty all triggers that were deactivated are reactivated.

Clear buffer table - Clear buffer table (allowed only for deactivation) is useful to get rid of any leftovers or inconsistent triggers in the buffer table.

SAP Tables - Select the option for source tables for triggers.