Neoview Workload Management Services Guide (R2.3)

4 Associating Queries With Services............................................................................35
Specifying a Service in a Client Data Source........................................................................................35
Setting the Service in the ODBC Administrator on a Windows Workstation.................................35
Setting the Service in the MXODSN File on a Linux or UNIX Workstation...................................37
Using the SQLSetConnectAttr() Function to Associate Queries With a Service..................................37
Using the setServiceName() Method to Associate Queries With a Service..........................................37
Using the SET SERVICE Statement to Associate Queries With a Service............................................38
SET SERVICE Statement..................................................................................................................38
GET SERVICE Statement.................................................................................................................38
5 Managing Workload in WMS...................................................................................41
Monitoring System Resources..............................................................................................................41
Using the STATUS WMS Command to Monitor System Resources...............................................41
Monitoring Services and Queries.........................................................................................................41
Displaying the Status of Services.....................................................................................................41
Displaying the Status and Compile-Time Statistics of All Queries.................................................43
Displaying the Status and Compile-Time Statistics of Queries in a Service...................................44
Filtering the Status and Compile-Time Statistics of Queries..........................................................44
Displaying the Total Number of Executing Queries.......................................................................47
Displaying Runtime Statistics of All Queries..................................................................................48
Displaying Runtime Statistics of a Specific Query..........................................................................49
Displaying the Query Explain Plan.................................................................................................50
Displaying the Query SQL Text.......................................................................................................50
Managing Services................................................................................................................................51
Holding All Services........................................................................................................................51
Holding a Service.............................................................................................................................51
Releasing All Services......................................................................................................................51
Releasing a Service..........................................................................................................................51
Managing Queries.................................................................................................................................52
Holding a Query..............................................................................................................................52
Releasing a Query............................................................................................................................52
Cancelling a Query..........................................................................................................................52
A WMS Commands........................................................................................................55
How to Execute WMS Commands in NCI...........................................................................................55
ADD SERVICE Command....................................................................................................................56
Syntax..............................................................................................................................................56
Considerations.................................................................................................................................58
Examples..........................................................................................................................................58
ALTER SERVICE Command.................................................................................................................58
Syntax..............................................................................................................................................58
Considerations.................................................................................................................................60
Examples..........................................................................................................................................60
ALTER WMS Command.......................................................................................................................60
Syntax..............................................................................................................................................60
Considerations.................................................................................................................................61
Examples..........................................................................................................................................61
CANCEL Command.............................................................................................................................61
Syntax..............................................................................................................................................61
Considerations.................................................................................................................................62
Examples..........................................................................................................................................62
DELETE SERVICE Command..............................................................................................................62
Syntax..............................................................................................................................................62
4 Table of Contents