Triggers

This topic shows detailed information about Statistics - Triggers.

Statistics - Triggers

The field labels shown in the following sample layout of Statistics - Triggers are described in the following section.


TRIGGERS                     QUANTITY  /SECOND  /THREAD  /COMMIT
---------------------------  --------  -------  -------  -------
STATEMENT TRIGGER ACTIVATED      0.00     0.00      N/C     0.00
ROW TRIGGER ACTIVATED            0.00     0.00      N/C     0.00
SQL ERROR OCCURRED               0.00     0.00      N/C     0.00

STATEMENT TRIGGER ACTIVATED

The number of times a statement trigger was activated.

Field Name: QXSTTRG

ROW TRIGGER ACTIVATED

The number of times a row trigger was activated.

Field Name: QXROWTRG

SQL ERROR OCCURRED

The number of times an SQL error occurred during the execution of a triggered action. This includes errors that occur in user-defined functions or stored procedures that are called from triggers and that pass back a negative SQLCODE.

Field Name: QXTRGERR