Adding and modifying the resource management policy

The Resource Management field of the Create New Data Source dialog displays each resource management policy that is currently in effect for a data source. You can add, modify, and remove a resource management policy for the selected data source.

NOTE:

You can enter only one resource management policy for each attribute name.

Table 27 describes the fields in the Add and Modify dialogs.

Fields in the Add and Modify dialogs
Field	Description
Attributes	The name of a resource management policy attribute that limits the execution of user queries from a client application, based on cost.
Action	The action to be taken by MXCS when the limit is exceeded. In all cases, an event message is sent to the event log. Valid values are: 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 the `LARGEINT SQL` data type.

Enter the details and click OK. The new resource management policy is added to the attribute list or the currently configured policy is modified. These changes are effective when you subsequently connect to a server in the data source.