MX 3.x)

Starting, Configuring, and Managing MXCS

HP NonStop SQL/MX Connectivity Service Manual—640327-001

3-9

Resource Statistics

3. Enter the new resource management policy or select an existing policy, then

click the appropriate command button.

Changes take effect immediately for an available server, and for a connected server

when it goes to available state.

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

Table 3-1. Attributes and Values for Resource Management Policies

Attribute The name of a resource management policy governing attribute that limits

the execution of user queries from a client application, based on cost.

Enter only one resource management policy for each attribute name.

Action The action to be taken by MXCS when the limit is exceeded. An event

message is sent to the event log in all cases.

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.

Limit The maximum value for the attribute. This value is any positive number. The

maximum is the value of LARGEINT SQL data type.