Triggers

Edit online

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.

Classic Batch Reporter layout:

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

Java Batch Reporter layout:

 TRIGGERS                     QUANTITY  /SECOND  /THREAD  /COMMIT
 ---------------------------  --------  -------  -------  -------
 STATEMENT TRIGGER ACTIVATED      0.00     0.00     0.00     0.00
 ROW TRIGGER ACTIVATED          183141     2.12     0.00     0.00
 SQL ERROR OCCURRED               0.00     0.00     0.00     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