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:
A
Trigger is applied after the event.
B
Trigger is applied before the event.
I
Trigger is applied instead of the event
 G
TRIGEVENT
CHAR(1)
NOT NULL
 Operation that activates the trigger:
I
Insert
D
Delete
U
Update
 G
GRANULARITY
CHAR(1)
NOT NULL
 Trigger is executed once per:
S
Statement
R
Row
 G
CREATEDTS
TIMESTAMP
NOT NULL
 Start of changeTime when the trigger was created or recreated.End of change 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:
blank
Authorization ID
L
Role
 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:
N
The trigger is not secured
Y
The trigger is secured
 G
ALTEREDTS
TIMESTAMP
NOT NULL
 Start of changeIndicates when the trigger was last changed.End of change G
ROWID
ROWID
NULL
GENERATED
ALWAYS
 ROWID column, created for the lob columns in this table. G
Start of changeSQLPLEnd of change Start of change
CHAR(1)
NOT NULL
WITH DEFAULT
End of change		 Start of changeIndicates whether the trigger supports SQL PL:
Y
Advanced trigger that supports SQL PL.
blank
Basic trigger that does not support SQL PL.
End of change		 Start of changeGEnd of change
Start of changeDEBUG_MODEEnd of change Start of change
CHAR(1)
NOT NULL
WITH DEFAULT
End of change		 Start of changeIndicates whether the trigger is enabled for debugging:
1
This trigger is enabled for debugging, and can be debugged in a client debug session using the Db2 Unified Debugger.
0
This trigger is not enabled for debugging.
N
This trigger can never be enabled for debugging.
blank
This trigger is a basic trigger that cannot be debugged.
End of change		 Start of changeGEnd of change
Start of changeASUTIMEEnd of change Start of change
INTEGER
NOT NULL
End of change		 Start of changeNumber 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.End of change Start of changeGEnd of change
Start of changeWLM_ENVIRONMENTEnd of change Start of change
VARCHAR(96)
NOT NULL
End of change		 Start of changeThe 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.End of change Start of changeGEnd of change
STATEMENT
CLOB(2M)
NOT NULL
WITH DEFAULT
 The text of the entire CREATE TRIGGER statement that was used to create the object. G
Start of changeVERSIONEnd of change Start of change
VARCHAR(122)
NOT NULL
End of change		 Start of changeThe version identifier for a trigger. A zero length string for a basic trigger.End of change Start of changeGEnd of change
Start of changeORIGINAL_CONTOKEnd of change Start of change
CHAR(8)
NOT NULL
FOR BIT DATA
End of change		 Start of changeThe consistency token for the trigger. The column is set to X'20' if the value of VERSION is a zero length string.End of change Start of changeGEnd of change
Start of changeREGENERATETSEnd of change Start of change
TIMESTAMP
NOT NULL
End of change		 Start of changeThe 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.End of change Start of changeGEnd of change
Start of changeACTIVEEnd of change Start of change
CHAR(1)
NOT NULL
End of change		 Start of changeIdentifies the active version of the trigger:
Y
The version is the active version.
N
The version is not the active version.
blank
The value of VERSION is a zero length string.
End of change		 Start of changeGEnd of change
Start of changeWRAPPEDEnd of change Start of change
CHAR(1)
NOT NULL
End of change		 Start of change
'Y'
The trigger text is obfuscated.
blank
The trigger text is not obfuscated.
End of change		 Start of changeGEnd of change