Stored Procedures

This topic shows detailed information about Statistics - Stored Procedures.

Statistics - Stored Procedures

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


STORED PROCEDURES            QUANTITY  /SECOND  /THREAD  /COMMIT
---------------------------  --------  -------  -------  -------
CALL STATEMENT EXECUTED          0.00     0.00      N/C     0.00
PROCEDURE ABENDED                0.00     0.00      N/C     0.00
CALL STATEMENT TIMED OUT         0.00     0.00      N/C     0.00
CALL STATEMENT REJECTED          0.00     0.00      N/C     0.00

CALL STATEMENTS EXECUTED

The number of SQL CALL statements executed.

Field Name: QXCALL

PROCEDURE ABENDED

The number of times a stored procedure terminated abnormally.

Field Name: QXCALLAB

CALL STATEMENT TIMED OUT

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

Field Name: QXCALLTO

CALL STATEMENT REJECTED

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

Field Name: QXCALLRJ