Previous Topic: SQL Status TablesNext Topic: SQL_PROC_DETAIL (SQZ)


SQL_MISC_STATS (SQM)

This table is provided to allow the monitoring of statistical information on selected SQL functionality. These statistics cover the execution of SQL procedure statements within the MUF.

Column Name

SQL Data Type

Nullable

Description

MUF_NAME

CHAR(8)

No

Logical name for this MUF.

PROC_CACHE_REUSE

INTEGER

No

Count of times a procedure definition had to be purged from the LRU (Least Recently Used) procedure definition cache to make room for a newly requested definition. Enlarge the cache size specified in the PROCEDURE Multi-User startup option until this number is as small as possible. If the number is zero, either procedures are not in use or every procedure definition used so far fits into the cache.

PROC_FAILURES

INTEGER

No

Count of times a procedure failed due to some type of abend in the procedure.

PROC_FROM_CALL

INTEGER

No

Count of times a procedure was executed because of a CALL PROCEDURE SQL statement.

PROC_FROM_TRIGGER

INTEGER

No

Count of times a procedure was executed because of a triggered event.

PROC_NESTS

INTEGER

No

Count of times a procedure was executed when it was caused by another procedure SQL statement.

PROC_QUEUED

INTEGER

No

Count of times a procedure needing to execute was placed on a queue because no procedure TCB was available. Used to tune the number of procedure TCBs.

PROC_SQL_STMTS

INTEGER

No

Count of SQL statements executed by a procedure.