Stored Procedures

This topic shows detailed information about Accounting - Stored Procedures.

This block shows information about stored procedure.

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 - Stored Procedures

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


Report:                                  Trace:

STORED PROCEDURES   AVERAGE     TOTAL    STORED PROC.     TOTAL
-----------------  --------  --------    ------------  --------
CALL STATEMENTS        0.00         0    CALL STMTS           0
ABENDED                0.00         0    ABENDED              0
TIMED OUT              0.00         0    TIMED OUT            0
REJECTED               0.00         0    REJECTED             0

CALL STATEMENTS (CALL STMTS)

The number of SQL CALL statements executed.

Field Name: QXCALL

ABENDED

The number of times a stored procedure terminated abnormally.

Field Name: QXCALLAB

TIMED OUT

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

Field Name: QXCALLTO

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