HP Neoview Release 2.5 Software - Manual (Page 85)

Description Field
Number of Executor server processes created. Processes Created
Segment Id for the query. Segment Id
Entry Id for the query. Entry Id
Sequence num for the query. Sequence Num
• Type: Miscellaneous
Description Field
Session identifier. Set by the client ODBC/JDBC/ADO application. Session Id
Query identifier. Query Id
Name of the user. User Name
Role name associated with the query (role of the user running
the query). Role Name
Name of master process of the query. Process Name
Client machine name. Client Id
Name of application that initiated the query. Application Id
Name of the data source. Datasource
The Neoview WMS service under which the query is running. Service Name
Status of the query. One of these: INIT, COMPLETED, REJECTED,
CANCELLED, WAITING, HOLDING, SUSPENDED Query Status
The substate of the query. Substate
What the executor is doing. Possible query states include:
INITIAL, OPEN, EOF, CLOSE, DEALLOCATED, FETCH,
CLOSE_TABLES, PROCESS_ENDED, UNKNOWN, NULL Query Execution State
Warning levels triggered by this query (rules violations). Warning Level
ID of the transaction under which the query is executed. When
there is no transaction, the transaction ID is -1. Transaction Id
ID of the parent query. If there is no parent query ID associated
with the query, NONE is displayed. Parent Query Id
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
Name of master process of the query. Process Info
State of the query. State
If an error, error code. 0 if no error. Error Code
Total number of SQLExecute calls. Total Executes
Type of SQL statement. Sql Type
Processing node number of the NDCS server that generated the
session. Node Id
Process identification number of the NDCS server. Pin
Status of the statement. Statement Status
Triage Space Query Details 85