SQL/MX 3.2.1 Management Manual (H06.26+, J06.15+)

• Disk reads
• Attempts at escalation of locks (successful or not)
• Lock waits
• Message activity
• Records accessed
• Records used
Stream access statements do not collect SQLSTMT statistics, but FILE statistics are collected.
FILE Statistics
Monitor database files with the FILE entity. The FILE report provides information on all partitions of
a specific file and record use by a user process. The FILE report gathers statistics on these
measurements:
• Escalations of locks
• Deletes
• Disk reads
• Lock waits
• Message activity
• Reads
• Records accessed
• Records used
• Updates
• Writes
The FILE report can provide specific data on SQL tables. You can use the FILE report along with
other reports on a specific volume or subvolume.
NonStop SQL/MX does not collect statistics on timeouts or file-busy-time (the time spent waiting
on file I/O activities). In NonStop SQL/MX, there is no file I/O waiting as there is for NonStop
SQL/MP. The SQL/MX interface to the disk process is inherently nowaited.
For queries that involve multiple SQL tables or compound statements, the statistics data for the
accessed tables might all be added to a single table, depending on whether the operations are
performed by the same Data Access Manager (DAM).
PROCESSH Statistics
SQLPROC and SQLSTMT are useful, but a process could be spending time in user functions that
do not contain SQL statements or in system code or system libraries. To gather statistics on these,
use PROCESSH.
The PROCESSH entity type provides information about the relative execution time of one or more
code ranges within a program. You can measure code ranges by specifying procedure names
and address ranges or by specifying a code-space category (user code, user library, system code,
or system library).
For H-series systems, PROCESSH provides information about all DLLs in system libraries for DLLs
that are named in the ADD PROCESSH statement. This information includes the percentage of
execution time occurring within each named library.
DISKFILE and DISCOPEN Statistics
The DISKFILE and DISCOPEN entities can be useful for database access and load management.
Both entities return ANSI SQL name information.
Measure Performance Measurement Tool 289