Stored Procedures

This topic shows detailed information about Accounting - Stored Procedures.

This block shows information about stored procedure.

For formatting reasons, OMEGAMON 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