HP Neoview Release 2.5 Software - Manual (Page 49)

Description Metric
Indicates an estimate of the number of rows accessed in the disk
process. Compilation Disk Process Rows Accessed
Indicates an estimate of the number of rows used in the disk process. Compilation Disk Process Rows Used
Run-Time Metrics
Run-time metrics indicate the actual resources that have been currently used by the query or
metrics that relate to the current state of the query. This information varies and will change over
time when this information is sampled or aggregated. Depending on the version of the platform
to which you are connected, the information displayed will vary. This document provides a short
description of the metrics:
Description Metric
Indicates the query’s execution state. Exec State
Error code value. Error Code
Top level error code returned by the query. This is also an indicator
that shows whether the query completed with warnings, errors or
successfully. A positive number indicates a warning. A negative
number indicates an error. SQL Error Code
Number of rows accessed by the Executor in the disk process (EID). Rows Accessed
Number of rows used. This is the number of rows returned by the
Executor in the disk process (EID) after applying the predicates. In a
push down plan, EID may not return all the user rows. Used Rows
Number of gigabytes (GB) of memory allocated. Space Allocation GB
Number of gigabytes (GB) of memory used. Space Usage GB
Number of kilobytes (KB) of memory allocated. Same as the GB value
but in KB units. Total Space Alloc KB
Number of kilobytes (KB) of memory used. Same as the GB value but
in KB units. Total Space Used KB
Internal counter of the run-time statistics infrastructure. Indicates the
number of bytes returned for statistics counts. Stats Bytes
Number of disk-read operations for accessing all the tables referenced
by the query. Disk Reads
Number of lock waits. This counter indicates the number of times this
query had to wait on a conflicting lock. A value of 0 indicates no locks
were encountered while executing the query. Lock Waits
Number of lock escalations. This counter indicates the number of times
row locks escalated into a file lock during the execution of the query.
A value of 0 indicates no locks were escalated while executing the
query. Lock Escalations
Number of opens (one per partition). This is the number of OPEN calls
performed by Neoview SQL on behalf of the query. Opens
Number of messages sent to execute operations on the tables used by
the query. Messages To Disk
Number of messages bytes sent to access the tables used by the query. Message Bytes To Disk
Number of rows inserted, updated, or deleted. Num Rows IUD
Internal error code returned to the stats collector from the run-time
statistics (RMS) infrastructure. Stats Error Code
Configuring Neoview WMS Services and Rules With Live View 49