HP Integrity NonStop J-Series - Manual (Page 88)

Table 22 General Properties options (continued)
Description Option Group
See “Adding and modifying the resource management policy” (page 88) . Add Resource
Management
See “Adding and modifying the resource management policy” (page 88) . Modify
Removes the selected resource management policy. Remove
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 23 (page 88) describes the fields in the Add and Modify dialogs.
Table 23 Fields in the Add and Modify dialogs
Description Field
The name of a resource management policy attribute that limits the execution of user queries from
a client application, based on cost. Attributes
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: Action
• 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 the LARGEINT SQL data type. Limit
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.
Using the DEFINEs and SETs tab
This section describes the DEFINEs and SETs tabs.
About DEFINEs
A DEFINE statement is a named set of attribute-value pairs associated with a process. SQL/MX
allows DEFINEs to be used as logical names for tables, views, or partitions in statements that query
SQL/MP objects.
DEFINE statements are stored as part of the configuration data for the data source. They are
retrieved and set by the association server when it reads the startup values for the data source.
Changes become effective the next time a connection is made to a server in the data source.
Table 24 (page 89) describes the fields in the DEFINEs tab.
88 Managing MXCS objects