MX 2.x)

Starting, Configuring, and Managing MXCS

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

3-7

Resource Management

For more information about a screen, click Help.

Resource Management

You can assign a resource management policy to a data source by adding the policy

using NSM/web. You can also delete the policy that is currently in effect.

Adding or Removing a Resource Management Policy

Requirement: You must have OPERATOR permission to perform management tasks.

To add or remove a resource management policy for a data source

1. Using NSM/web, Expand Data Source Configurations.

2. Click the name of the data source for which you want to add or remove the

policy.

Click the Resource Management tab.

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.

Note. You cannot delete the MXCS default data source (TDM_Default_DataSource).

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.