(Glue-2308) 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.

Main screen (list overview)

After accessing Trigger Management, a screen with a list of all triggers 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.
• Table Name: The name of the table on which the trigger is created.
• Trigger: The name of Database Trigger.
• Description: Description of the table.
• Object Name: The name of the Extractor or Fetcher object which has trigger delta.
• Shadow table count: The number of entries in the shadow table. To update this column, select triggers in ALV and then press the button Count rows in the ALV toolbar. 
• Created on: Date of creation.
• Created by: The name of the user who created the trigger.
• Changed on: Date of the last change.
• Changed by: The name of a user who last changed the trigger.

There are several actions that can be performed from the list overview screen:

• Activate: activate selected trigger(s)

• Deactivate: deactivate selected trigger(s)

• Check: check the consistency of selected trigger(s)
• Show object: display the parent object (column 'Object name') of the selected trigger
• Sequence settings: go to global sequence settings (with an option to mass alter sequence cache)

Detail View

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

For active/disabled/inconsistent triggers the button Deactivate is provided and the button Count Rows is enabled which after use shows the number of entries in a shadow table. Triggers with inactive status have been provided with Activate button and the button Count Rows is disabled. Next to the name of a shadow table is a button that redirects a user to the Data Browser (SE16).

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 the 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 the 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: A 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.