IFCID 003 - Nested SQL Activity

This topic shows detailed information about Record Trace - IFCID 003 - Nested SQL Activity.

Record trace - IFCID 003 - Nested SQL Activity

The field labels shown in the following sample layout of Record Trace - IFCID 003 - Nested SQL Activity are described in the following section.


NESTED SQL ACTIVITY
MAX CASCAD LVL           0
CALL STATEMENTS          0  PROCEDURE ABENDS             0  CALL TIMEOUTS               0  CALL REJECTS                 0
UDF EXECUTED             0  UDF ABENDS                   0  UDF TIMEOUTS                0  UDF REJECTS                  0
STMT TRIGGER             0  ROW TRIGGER                  0  SQL ERROR TRIGGER           0

MAX CASCAD LVL

The maximum level of indirect SQL cascading. This includes cascading because of triggers, UDFs, or stored procedures.

Field Name: QXCASCDP

This is an exception field.

CALL STATEMENTS

The number of SQL CALL statements executed.

Field Name: QXCALL

This is an exception field.

PROCEDURE ABENDS

The number of times a stored procedure terminated abnormally.

Field Name: QXCALLAB

This is an exception field.

CALL TIMEOUTS

The number of times an SQL call timed out waiting to be scheduled.

Field Name: QXCALLTO

This is an exception field.

CALL REJECTS

The number of times an SQL CALL statement was rejected due to the procedure being in the STOP ACTION(REJECT) state.

Field Name: QXCALLRJ

This is an exception field.

UDF EXECUTED

The number of user-defined functions executed.

Field Name: QXCAUD

This is an exception field.

UDF ABENDS

The number of times a user-defined function abended.

Field Name: QXCAUDAB

This is an exception field.

UDF TIMEOUTS

The number of times a user-defined function timed out while waiting to be scheduled.

Field Name: QXCAUDTO

This is an exception field.

UDF REJECTS

The number of times a user-defined function was rejected.

Field Name: QXCAUDRJ

This is an exception field.

STMT TRIGGER

The number of times a statement trigger was activated.

Field Name: QXSTTRG

This is an exception field.

ROW TRIGGER

The number of times a row trigger was activated.

Field Name: QXROWTRG

This is an exception field.

SQL ERROR TRIGGER

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

This is an exception field.