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. |
|
Copyright © 2014 CA.
All rights reserved.
|
|