Trig compile

Number of trigger compilations.

Counter is incremented during the execution of a CREATE TRIGGER statement.

Trig exec

Trigger executions per second.

The counter is incremented when a trigger is executed.

If the value is increasing or higher than expected, a trigger might be getting called (nested or not) more than expected.

Trig SQL prepare

Number of SQL prepare calls from a trigger code.

The counter is incremented when an EXEC SQL PREPARE is done within a trigger. This counter is also incremented when an SQL EXECDIRECT is done, because a prepare operation is implicitly done.

Trig SQL execute

Number of SQL execute calls from a trigger code.

The counter is incremented when an EXEC SQL EXECUTE or EXEC SQL EXECDIRECT is done within a trigger.

Trig SQL fetch

Number of SQL fetch calls from a trigger code.

The counter is incremented when an EXEC SQL FETCH is done within a trigger.