This form displays information on SQL statements, SQL access plans, plan buffers and calls of specific SQL components.
Field descriptions
<ver> DBH CNF Time | Version of the DBH. Name of the DBH to which the data in the form relates. Name of the configuration monitored. Time at which the form is output. |
SQL DML
Number of SQL DML statements (in this session and per time period).
UPDATE
Number of SQL update statements (in this session and per time period).
RETRIEVAL
Number of SQL retrieval statements (in this session and per time period).
SQL DDL/SSL
Number of SQL DDL and SQL SSL statements (in this session and per time period).
SQL UTI
Number of utility statements (in this session and per time period).
Accesses Core
Number of accesses of SQL access plans during the whole session.
Accesses Core/IV
Number of accesses of SQL access plans per time period.
Generated
Number of SQL access plans generated in this session. SQL access plans are also regenerated when they have been displaced from the plan buffer.
Generated/IV
Number of SQL access plans generated per time period. SQL access plans are also regenerated when they have been displaced from the plan buffer.
Number per DBH-Option
Number of SQL access plans set by means of the DBH option SQL-SUPPORT.
Kernel Control
Number of kernel-control calls (in this session and per time period).
Catalog Manager
Number of catalog-manager calls (in this session and per time period).
CALL DML Handler
Number of CALL DML handler calls (in this session and per time period).
Sort Operations
Number of SQL sort operations (in this session and per time period).
Max. SQL Cursors
Maximum number of open SQL cursors in the session.
Act. SQL Cursors
Number of currently open SQL cursors (snapshot).
Number of Plans
Number of SQL access plans in the plan buffer (snapshot).
Size of Primary Buffer
Size of the primary plan buffer in bytes.
Occupation of Primary Buffer
Space in bytes used in the primary plan buffer (snapshot).
Size of Secondary Buffer
Size of the secondary plan buffer in bytes.