Open Glue Trigger Management
Step type: Simple user interface.
Step description: This step allows you to maintain the generated triggers: activate, deactivate, show records collected by a trigger, etc. The generated triggers are listed in an ALV grid.
Detailed functions: The ALV grid has the following structure:
-
Status: Status of the trigger. The following options are possible:
-
Inactive (stop sign icon): The trigger is dropped.
-
Active (green square icon): The trigger is active on the database and is collecting data.
-
Disabled (yellow triangle icon): The trigger has been created but is not collecting data.
-
Inconsistent (lightning bolt icon): The trigger is in an inconsistent state and needs to be checked.
-
-
Table name: Table name on which the trigger is built.
-
Database trigger name: Name of the database trigger.
-
Table description: Description of the table.
-
Object name: Internal label for trigger management. This is neither used nor maintained by DTS.
-
Shadow table count: Row count of the shadow tables. You can update this column by clicking Count rows in the ALV toolbar.
-
Created on: Date when the trigger was created.
-
Created by: User who created the trigger.
-
Changed on: Date of the last change.
-
Changed by: User who made the last change.
When you double-click a row, the database trigger details are shown. This screen contains the following options:
-
Trigger name: Name of the trigger.
-
Trigger type: Database vendor acronym.
-
Database connection: Name of the database connection.
-
Database schema: Name of the database schema.
-
Table: Table name.
-
Sequence: Glue trigger counter.
-
Shadow table: Name of the shadow table. This is the table where the delta records are stored.
-
Browse: Shows the content of the shadow table.
-
-
Shadow table entries: Shows the last counted entries of the trigger shadow table size in terms of the number of rows.
-
Count rows: Updates the Shadow table entries field with the actual value. The value shown is a value stored after the last calculation. Note that the active triggers might have collected new records since the last count of rows.
-
-
Created: Trigger creation date, time and user.
-
Last change: Trigger last change date, time and user.
-
Activate/deactivate: Enables or disables individual trigger events from the list below. Select the event in the table below and click Activate or Deactivate to perform the required action.
-
List of the registered trigger events in an ALV grid:
-
Status: Description of the main trigger ALV column.
-
Trigger object name: Name of the trigger event.
-
Operation: Type of registered trigger operation.
-
DB trigger status: Short text that describes the status icon.
-
The toolbar provides the following functions:
-
Activate (F8): Activates the selected triggers.
-
Check (Ctrl+F1): Checks the consistency of the selected triggers.
-
Deactivate (Shift+F1): Deactivates the selected triggers.
-
Show object (Shift+F5): Shows the SNP Glue trigger object details.
The ALV grid toolbar provides the following functions:
-
Select all: Selects all the records in the ALV grid.
-
Deselect all: Deselects all the records in the ALV grid.
-
Count rows: Updates the number of records collected in the shadow tables (see the column Shadow table count).
-
The other functions are standard ALV grid functions.