MX Release 3.2 (H06.25+, J06.14+)

ManualsBrandsHP ManualsServerHP Integrity NonStop J-Series

Table 1 Attributes and Values for Resource Management Policies (continued)

LOG - The user query continues execution.

LOG_WITH_INFO - The user query returns a warning

message to the client. The query execution continues.

STOP - The user query returns an error message to the

client. The query execution stops.

The maximum value for the attribute. This value is any

positive number. The maximum is the value of LARGEINT

SQL data type.

Limit

Resource Statistics

You can collect resource statistics (server statistics) for a particular data source.

MXCS Server can collect these statistics:

• Session Statistics

Connection information

Session summary

• Statement Statistics

SQL statement — shows the text of the SQL query for individual SQL statements executed

but does not include other statistics

◦

◦ Statistical data about individual statements

SQLExecDirect

SQLExecute

SQLPrepare

SQLFetch

You may choose any combination of options. For example, choosing SQL statement plus one

or more of the individual statements returns the SQL statement that was executed and the

statistics for that statement. Choosing SQL Statement alone returns the text of the SQL query

for individual SQL statements. See “Example resource statistics output for three selected options”

(page 37).

Use NSM/web or MXCI to select these options for collecting resource statistics. See “Starting

Statistics Collection” (page 40).

Statement Statistics - Statements and Values

SQL Statement

Statement statistics are written to the alternate EMS collector at the time a Prepare statement is

received.

Table 2 Statement Statistics - SQL Statement

ValueStatistic

Unique session ID generated by the MXCS SQL server at

the time the connection is established.

Session ID

STATEMENT:SQLStatement (the Statistics option that was

selected.)

Message Attribute

Message sequence number generated by MXCS. The

number begins with 0 (zero) and is incremented by 1 with

each new record.

Sequence Number

32 Starting, Configuring, and Managing MXCS