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

Table 22 General Properties options (continued)
Description Option Group
See “Adding and modifying the resource management policy” (page 85) . 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 85) 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 85) describes the fields in the DEFINEs tab.
Table 24 DEFINEs tab buttons
Function Button
Displays the Add DEFINE dialog. Add...
Displays the Edit DEFINE dialog. Modify...
Removes the selected DEFINE statement. Remove
Creating a data source 85