Neoview Workload Management Services Guide (R2.3)

Table A-10 Query Runtime Statistics (continued)
DescriptionData TypeColumn Name
Amount, in kilobytes, of the heap type of memory used in the
master and ESPs involved in processing the query
INTSQL_HEAP_USED
Approximation, in microseconds, of the total CPU time spent
in the master and ESPs involved in processing the query
LARGEINTSQL_CPU_TIME
Amount, in kilobytes, of the space type of memory allocated in
the EID (executor code in DP2 processes) involved in processing
the query
INTEID_SPACE_ALLOC
Amount, in kilobytes, of the space type of memory used in the
EID involved in processing the query
INTEID_SPACE_USED
Amount, in kilobytes, of the heap type of memory allocated in
the EID involved in processing the query
INTEID_HEAP_ALLOC
Amount, in kilobytes, of the heap type of memory used in the
EID involved in processing the query
INTEID_HEAP_USED
Estimated number of rows accessed by the queryFLOATEST_ACCESSED_ROWS
Estimated number of rows used by the queryFLOATEST_USED_ROWS
Number of processes generated by the executor on behalf of
this query
LARGEINTPROCESSES_CREATED
Time spent creating processesLARGEINTPROCESS_CREATE_TIME
Local civil time when the shared memory block was last
updated.
LARGEINTLAST_UPDATED
• The STATUS QUERY with PLAN returns the query execution plan:
Table A-11 Query Execution Plan
DescriptionData TypeColumn Name
Text for the query execution plan, which is returned in ISO8859-1
encoding. To interpret query execution plans, see the Neoview
Query Guide.
VARCHAR(3800)QUERY_PLAN
• The STATUS QUERY with TEXT returns the SQL syntax for the query:
Table A-12 SQL Text
DescriptionData TypeColumn Name
Text for the SQL query syntax, which is returned in UTF8
encoding.
VARCHAR(3800)QUERY_TEXT
• To execute this command in NS mode in NCI, see “How to Execute WMS Commands in
NCI” (page 55).
Examples
• This command displays status information about WMS:
STATUS WMS
• This command displays version information for the internal WMS processes:
STATUS WMS VERSION
• This command displays status information for all the services on the system:
STATUS SERVICE ALL
STATUS Command 73