SQL/MX Connectivity Service Manual for SQL/MX Release 3.2 (H06.25+, J06.14+)

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 “Resource Statistics Event Message Format” (page 41) 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” (page 37) 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.
Resource Statistics Event Message Format
Message 21035
AttributeParameter
Session ID: session-id
Message Attribute: message-attribute
MXCS Statistics
Sequence Number:sequence-number
Message Info:statistics-information
{ SESSION:ConnectionInformation }
{ SESSION: SessionSummary }
message-attribute
{ STATEMENT: SQLStatement }
{ STATEMENT: SQLExecDirect }
{ STATEMENT: SQLExecute }
{ STATEMENT: SQLPrepare }
{ STATEMENT: SQLFetch }
Unique session ID generated by the SQL server at the time
the connection is established.
session-id
Name of the statistics option you selected.message-attribute
Messages too large for one message template are divided
into smaller messages. Sequence number indicates which
sequence–number
part of the message you are viewing. The sequence number
is 0 for the first or only part of a message, and 1 for
additional parts, if any.
The statistics collected for the session or statement options
selected.
statistics–information
21035
See above.
Cause. A resource statistics informational message.
Effect. None.
Recovery. Informational message only; no corrective action is needed.
Resource Statistics 41