MX 2.x)

Starting, Configuring, and Managing MXCS

HP NonStop SQL/MX Connectivity Service Manual—524944-008

3-15

Collecting Server Statistics

TotalInsertStmtsExecuted:2

TotalDeleteStmtsExecuted:0

TotalUpdateStmtsExecuted:0

TotalSelectStmtsExecuted:2

TotalCatalogStmts:0 TotalPrepares:2 TotalExecutes:2

TotalFetches:4 TotalCloses:3 TotalExecDirects:3

TotalErrors:1 TotalWarnings:2

•

SQL Statement — The first message contains information for the SQL Statement

option and shows that an SQL SELECT statement was prepared for execution.

Note that no detailed statistics are given for that statement - just the query itself,

and the time of execution.

•

SQLPrepare — The second message contains information for the SQLPrepare

option and shows that an SQL SELECT statement was prepared at 9:27. This time

matches the time for the SELECT statement returned by SQL Statement. This

entry also contains the SQLPrepare statistics for that SELECT statement. Note that

to obtain complete statistics information for SQL statements, you must select the

SQL Statement option and the option for each specific statement for which you

want statistics.

•

Session Summary — The third message contains information for the Session

Summary option. This message shows statistics for the entire user session, from

client connect to client disconnect.

For detailed definitions of statistics that are collected, see the online help for NSM/web.

For information on configuring statistics collection, see Configuring Statistics Collection

on page 3-15

Collecting Server Statistics

Configuring Statistics Collection

You must use a user ID that has OPERATOR permission to perform management

tasks.

1. Configure an alternate collector, using the EMSACOLL command. For details on

the EMSACOLL command, see the EMS Manual.

2. Start the alternate collector before starting the MX connectivity service.

3. Use the MXOAS command to start the MX connectivity service, and pass the name

of the alternate collector to the server in the -RMC parameter. See Starting

Statistics Collection on page 3-15.

Starting Statistics Collection

You must use a user ID that has OPERATOR permission to perform management

tasks.