SQL/MX Connectivity Service Manual (SQL/MX 2.x)
Starting, Configuring, and Managing MXCS
HP NonStop SQL/MX Connectivity Service Manual—524944-008
3-16
Collecting Server Statistics
1. Using NSM/web, expand Data Source Configurations.
2. Click a data source name.
3. Click on the Resource Statistics tab.
4. Check one or more statistics options.
5. Click Apply.
Statistics collection begins for all available servers and connected servers.
For more information about a screen, click Help.
Stopping Statistics Collection
You must use a user ID that has OPERATOR permission to perform management
tasks.
1. Using NSM/web, click Data Source Configurations.
2. Click on a data source name.
3. Click the Resource Statistics tab.
4. Clear statistics options.
5. Click Apply.
For more information about a screen, click Help.
Viewing Statistics
The EMS alternate collector collects the MXCS Server statistics and returns them in
event message 21035. See message Format of Event Message 21035 for the
message format.
Each statistics option returns a separate message for every qualified statement, for
connection information, and for session summary. See Example resource statistics
output for three selected options for an example of statistics returned.
See the MXCS online help, which is available on NSM/web, for descriptions of the
fields that are collected. To easily access a description of each statistics field while
viewing the collected statistics, keep an NSM/web window open as you look at the
statistics messages.You can view statistics messages by running a printing distributor
using the EMSDIST command, or by using ViewPoint or WebViewPoint. See the EMS
Manual, the ViewPoint Manual, or the Web ViewPoint User’s Guide for details.