SYSTRIGGERS catalog table
The SYSTRIGGERS table contains one row for each trigger. The schema is SYSIBM.
| Column name | Data type | Description | Use |
|---|---|---|---|
| NAME | VARCHAR(128)
NOT NULL |
Name of the trigger and trigger package. | G |
| SCHEMA | VARCHAR(128)
NOT NULL |
Schema of the trigger. This implicit or explicit qualifier for the trigger name is also used for the collection ID of the trigger package. | G |
| SEQNO | SMALLINT
NOT NULL |
Not used. | N |
| DBID | SMALLINT
NOT NULL |
Internal identifier of the database for the trigger. | G |
| OBID | SMALLINT
NOT NULL |
Internal identifier of the trigger. | G |
| OWNER | VARCHAR(128)
NOT NULL |
Owner of the trigger. | G |
| CREATEDBY | VARCHAR(128)
NOT NULL |
Primary authorization ID of the user who created the trigger. | G |
| TBNAME | VARCHAR(128)
NOT NULL |
Name of the table or view. | G |
| TBOWNER | VARCHAR(128)
NOT NULL |
Qualifier of the name of the table or view to which this trigger applies. | G |
| TRIGTIME | CHAR(1)
NOT NULL |
Time when triggered actions are applied
to the base table, relative to the event that activated the trigger:
|
G |
| TRIGEVENT | CHAR(1)
NOT NULL |
Operation that activates the trigger:
|
G |
| GRANULARITY | CHAR(1)
NOT NULL |
Trigger is executed once per:
|
G |
| CREATEDTS | TIMESTAMP
NOT NULL |
Time when the trigger was created or recreated. | G |
| IBMREQD | CHAR(1)
NOT NULL |
A value of Y indicates that the row was provided with the Db2 product code. For all other values, see Release dependency indicators. The value in this field is not a reliable indicator of release dependencies. RELCREATED should be used instead. |
G |
| TEXT | VARCHAR(6000)
NOT NULL |
Not used. | N |
| REMARKS | VARCHAR(762)
NOT NULL |
A character string provided by the user with the COMMENT statement. | G |
| TRIGNAME | VARCHAR(128)
NOT NULL |
Not used. | G |
| OWNERTYPE | CHAR(1)
NOT NULL WITH DEFAULT |
Indicates the type of creator:
|
G |
| ENVID | INTEGER
NOT NULL WITH DEFAULT |
Internal environment identifier. | G |
| RELCREATED | CHAR(1)
NOT NULL |
The release of Db2 that is used to create the object. Blank if created prior to Version 9. See Release dependency indicators for all other values. | G |
| SECURE |
CHAR(1)
NOT NULL WITH DEFAULT 'N' |
Indicates if the trigger is secured:
|
G |
| ALTEREDTS |
TIMESTAMP
NOT NULL |
Indicates when the trigger was last changed. | G |
| ROWID |
ROWID
NULL GENERATED ALWAYS |
ROWID column, created for the lob columns in this table. | G |
| SQLPL |
CHAR(1)
NOT NULL WITH DEFAULT |
Indicates whether the trigger supports SQL PL:
|
G |
| DEBUG_MODE |
CHAR(1)
NOT NULL WITH DEFAULT |
Indicates whether the trigger is enabled for debugging:
|
G |
| ASUTIME |
INTEGER
NOT NULL |
Number of CPU service units that are allowed for a single invocation of this trigger. If ASUTIME is zero, the number of CPU service units is unlimited. If the trigger consumes more CPU service units than the ASUTIME value allows, Db2 cancels the trigger. | G |
| WLM_ENVIRONMENT |
VARCHAR(96)
NOT NULL |
The WLM ENVIRONMENT FOR DEBUG MODE value in the trigger definition. This value is the name of the WLM environment that is used when a trigger is debugged. If this value is blank, the trigger cannot be debugged. | G |
| STATEMENT | CLOB(2M)
NOT NULL WITH DEFAULT |
The text of the entire CREATE TRIGGER statement that was used to create the object. | G |
| VERSION |
VARCHAR(122)
NOT NULL |
The version identifier for a trigger. A zero length string for a basic trigger. | G |
| ORIGINAL_CONTOK |
CHAR(8)
NOT NULL FOR BIT DATA |
The consistency token for the trigger. The column is set to X'20' if the value of VERSION is a zero length string. | G |
| REGENERATETS |
TIMESTAMP
NOT NULL |
The time when the object was regenerated. The value is valid only for objects that can be regenerated. If no regeneration has occurred, this column contains the same value as the CREATEDTS column. | G |
| ACTIVE |
CHAR(1)
NOT NULL |
Identifies the active version of the trigger:
|
G |
| WRAPPED |
CHAR(1)
NOT NULL |
|
G |