Neoview Workload Management Services Guide (R2.4)

----------------------- --------- ---------------- ------------ ------------- --------------------
------------------- -------- -------- ------------ ------------ ------------
HPS_MANAGEABILITY ACTIVE HIGH 0 0 0 FROM 00:00
TO 24:00 NO_PLAN NO_TEXT 0 0 0
SERVICE1 ACTIVE HIGH 95 80 0 FROM 08:00
TO 24:00 PLAN TEXT 120 720 1440
SERVICE4 HOLD HIGH 95 80 0 FROM 00:00
TO 07:59 PLAN TEXT 120 720 1440
HPS_TRANSPORTER ACTIVE MEDIUM 0 0 0 FROM 00:00
TO 24:00 NO_PLAN NO_TEXT 0 0 0
SERVICE2 ACTIVE MEDIUM 75 60 0 FROM 00:00
TO 24:00 PLAN TEXT 240 1400 0
SERVICE25 ACTIVE MEDIUM 75 60 0 FROM 00:00
TO 24:00 NO_PLAN NO_TEXT 0 0 0
SERVICE13 HOLD MEDIUM 75 60 0 FROM 00:00
TO 24:00 NO_PLAN NO_TEXT 0 0 0
HP_DEFAULT_SERVICE ACTIVE LOW 100 85 0 FROM 00:00
TO 24:00 NO_PLAN NO_TEXT 0 0 0
SERVICE3 ACTIVE LOW 55 40 2000 FROM 00:00
TO 24:00 PLAN TEXT 0 0 0
--- WMS operation complete.
NS%
This STATUS SERVICE command displays configuration information for
HP_DEFAULT_SERVICE:
SQL>mode ns
NS%status service hp_default_service;
SERVICE_NAME STATE SERVICE_PRIORITY MAX_CPU_BUSY MAX_MEM_USAGE MAX_ROWS_FETCHED ACTIVE_TIME
SQL_PLAN SQL_TEXT EXEC_TIMEOUT WAIT_TIMEOUT HOLD_TIMEOUT
---------------------- --------- ---------------- ------------ ------------- --------------------
------------------- -------- -------- ------------ ------------ ------------
HP_DEFAULT_SERVICE ACTIVE LOW 100 85 0 FROM 00:00
TO 24:00 NO_PLAN NO_TEXT 0 0 0
--- WMS operation complete.
For the syntax, see the “STATUS SERVICE Command” (page 142). Also see “How to Execute
WMS Commands in NCI” (page 25).
Displaying the Service in Effect
The GET SERVICE statement shows the service that is in effect for the current session and provides
some information about the service and the client session:
SQL>get service;
CUR_SERVICE PLAN TEXT CUR_SCHEMA RULE_NAME APPL_NAME
SESSION_NAME DSN_NAME ROLE_NAME
------------ ------------- -------------- ---------------- -------------- -----------
------------ ---------------------- --------------
HP_DEFAULT_SERVICE 1 1 NEO.USR NCI
TDM_Default_DataSource role.hr
--- SQL operation complete.
SQL>
For more information about GET SERVICE, see the Neoview SQL Reference Manual.
Configuring User-Defined Services 37