Skip to Content

Default language.

Information
Space announcement The Using section of the MainView for DB2 documentation is now available in Japanese. The displayed language is dependent on your browser language. You can switch languages from the Language menu.

Stored procedures (BACCTDR)

This topic describes the Stored procedures section of the Accounting summary—long report (BACCTDR).

STORED PROC      AVERAGE    TOTAL
--------------- -------- --------
CALL STMT           0.00        0
PROC ABEND          0.00        0
CALL TIMEOUT        0.00        0
CALL REJECT         0.00        0

The following table describes the fields in the Stored procedures section.

Field

Description

CALL STMT

Number of SQL CALL statements executed (QXCALL)

In the DB2 Accounting Stored Procedures Report, this value is the average number of CALL statements executed. It is a count of the number of SQL CALL statements processed for the application and it activates a DB2 stored procedure.

PROC ABEND

Number of stored procedure abends (QXCALLAB)

In the DB2 Accounting Stored Procedures Report, this value is the average number of times a stored procedure terminated abnormally.

Tuning Tip: Large numbers here indicate that one or more stored procedures have fatal errors.

CALL TIMEOUT

Number of SQL CALL statements timed out (QXCALLTO)

In the DB2 Accounting Stored Procedures Report, this value is the average number of times an SQL CALL statement timed out while waiting to be scheduled. This counter is incremented when the Stored Procedures Address Space does not have a TCB available within the time limit specified in the DSNZPARM TIMEOUT parameter to schedule the execution of an SQL CALL statement.

Tuning Tip: Appropriate fixes include the following actions:

  • Reduce the amount of CPU service units in other stored procedures to get better throughput. @Stop stored procedures no longer needed.
  • Increase the number of TCBs available in the Stored Procedures Address Space (by increasing the NUMTCB parameter in the Stored Procedures Address Space JCL).

CALL REJECT

Number of SQL CALL statements rejected because the procedure was stopped (QXCALLRJ)

In the DB2 Accounting Stored Procedures Report, this value is the average number of times an SQL CALL statement was rejected because the procedure was stopped. This counter is incremented when an SQL application CALLs a stored procedure which has been stopped by the operator or system administrator.

Tuning Tip: If this problem happens frequently, ensure that the procedure is started in normal mode.

Related topic

Accounting report fields

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

MainView for DB2 6.1