Neoview Workload Management Services Guide (R2.3)

Table A-4 System Version Information
DescriptionData TypeColumn Name
A string of version information for internal WMS processesVARCHAR(n)VERSION_INFO
Table A-5 VERSION_INFO Column String
ExampleString Element
01Segment number of the WMS process
QSSYNCProcess name
33Component ID
2Major version number
3Minor version number
1Build ID
T8010N26_15FEB2008_AFC_SYNC_0304VPROC information
• The STATUS SERVICE option returns this status information:
Table A-6 Services Status Information
DescriptionData TypeColumn Name
Name of the serviceVARCHAR(96)SERVICE_NAME
State of the service, which is INIT (for initialization), ACTIVE, HOLD,
or DELETING
VARCHAR(7)STATE
Priority of the service, which is URGENT, HIGH, MEDIUM-HIGH,
MEDIUM, LOW-MEDIUM, or LOW
VARCHAR(10)SERVICE_PRIORITY
Maximum CPU busy allowed. If this value is zero, the default value, it
means that WMS uses the threshold of the WMS system configuration,
if set, or the internal default threshold of 100%.
INTMAX_CPU_BUSY
Maximum memory usage allowed. If this value is zero, the default
value, it means that WMS uses the threshold of the WMS system
configuration, if set, or the internal default threshold of 85%.
INTMAX_MEM_USAGE
Active time for this service, such as from 00:00 through 23:59VARCHAR(19)ACTIVE_TIME
PLAN indicates that the query execution plans are collected for display.
NO_PLAN indicates that no plans are collected for display.
VARCHAR(7)SQL_PLAN
TEXT indicates that the SQL syntax of executing queries are collected
for display. NO_TEXT indicates that no SQL text is collected for display.
VARCHAR(7)SQL_TEXT
Timeout value for executing queries in the serviceINTEXEC_TIMEOUT
Timeout value for waiting queries in the serviceINTWAIT_TIMEOUT
• The STATUS SERVICE STATS option returns these statistics for all the services on the system:
Table A-7 Statistics for All Services on the System
DescriptionData TypeColumn Name
Segment numberINTSEGMENT
Name of the serviceVARCHAR(96)SERVICE_NAME
State of the service, which is INIT (for initialization), ACTIVE, or HOLDVARCHAR(8)STATE
Number of executing queries for the service across the clusterINTEXECUTING
STATUS Command 69