Triggers

This topic shows detailed information about Accounting - Triggers.

This block provides information about triggers.

For formatting reasons, OMEGAMON XE for DB2 PE shows different labels for report and trace. The following example shows both layouts, the report on the left, and the trace layout on the right.

Accounting - Triggers

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


Report:                                   Trace:

TRIGGERS            AVERAGE     TOTAL     TRIGGERS         TOTAL
-----------------  --------  --------     ------------  --------
STATEMENT TRIGGER     15.00        60     STMT TRIGGER         0
ROW TRIGGER            8.00        24     ROW TRIGGER          0
SQL ERROR OCCUR        0.00         0     SQL ERROR            0

STATEMENT TRIGGER (STMT TRIGGER)

The number of times a statement trigger was activated.

Field Name: QXSTTRG

ROW TRIGGER

The number of times a row trigger was activated.

Field Name: QXROWTRG

SQL ERROR OCCUR (SQL ERROR)

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