Measure Reference Manual

OPEN-TIME
Time this process spent executing OPENs.
Counter type: Elapsed.
OPENS
Number of OPEN calls performed by the SQL executor on behalf of this process.
Counter type: Incrementing.
SQL-NEWPROCESS-TIME
Time this process spent executing SQL-NEWPROCESS.
Counter type: Elapsed.
SQL-NEWPROCESSES
Number of NEWPROCESS calls generated by the SQL executor on behalf of this process.
Counter type: Incrementing.
SQL-OBJ-RECOMPILE-TIME
Time this process spent recompiling objects. SQL/MX does not support this counter.
Counter type: Elapsed.
SQL-OBJ-RECOMPILES
Number of objects recompiled for this process. SQL/MX does not support this counter.
Counter type: Incrementing.
SQL-STMT-RECOMPILE-TIME
Time this process spent recompiling statements.
Counter type: Elapsed.
SQL-STMT-RECOMPILES
Number of statements recompiled for this process. The SQL-STMT-RECOMPILES counter is
incremented when a similarity check fails and automatic recompilation happens. Similarity checks
and automatic recompilation are explained in the SQL/MX Programming Manual for C and
COBOL.
Counter type: Incrementing.
Usage Note for New Format SQLPROC Entities
SUBSYSTEM-VERSION for ZMSSQLP records is provided by the SQL/MP or SQL/MX subsystem.
SQLSTMT
The SQLSTMT entity provides information about all SQL statements within the SQL process. There
is one SQLSTMT counter record for each SQL statement in each procedure or module of a program
that contains SQL function.
NOTE: Overhead cost for measuring SQL statements is higher than the cost of measuring other
entities. A practical use is to measure SQLSTMT periodically for application-program performance
tuning only. Be sure to configure SQLSTMT to measure only the programs to be examined.
In Measure G09 and later PVUs, SQLSTMT entity operation supports SQL/MX and OSS file
pathnames. SQL/MX program objects and run units are defined only in the OSS file system space.
In the SQL/MP environment, SQL procedures and run units are part of the program object file that
SQLSTMT 341