Neoview Command Interface (NCI) Guide (R2.5)

ManualsBrandsHP ManualsSoftwareHP Neoview Release 2.5 Software

161

162

163

164

165

166

167

168

169

170

ALTER RESOURCE Command

The ALTER RESOURCE command changes the resource management policy for the specified

data source.

Syntax

ALTER RESOURCE "attribute-name", DSNAME data-source-name, LIMITVALUE value, ACTION "action"

action is:

LOG | LOG_WITH_INFO | STOP

"attribute-name"

is the name of a resource management policy attribute that limits the execution of user queries

from a client application, based on cost. Currently, ESTIMATED COST is the only attribute

supported.

DSNAME data-source-name

is the name of the data source. data-source-name is case-sensitive and cannot be the

asterisk (*) wild card.

LIMITVALUE value

is the maximum value for the attribute. Specify any positive number.

ACTION

is the action to be taken by the NDCS server when the limit is exceeded. In all cases, an event

message is sent to the event log. Valid values are:

"LOG"

causes the user query to continue executing.

"LOG_WITH_INFO"

causes the user query to return a warning message to the client while the query continues

executing.

"STOP"

causes the user query to return an error message to the client and stop executing.

Considerations

• To run this command in SQL mode, you must first run the CMDOPEN command. This

command does not run in CS mode.

• The command requires an SQL terminator.

• Only users associated with roles that have OPERATOR privileges can execute this command.

For more information, see the “ADD USER Command” (page 158) or “ALTER USER

Command” (page 167).

• The wild card (*) is not supported for the data source name, and the data source name is

case-sensitive.

• The ALTER RESOURCE command deletes all the resource management policy values for

the data source before inserting the new values.

• The association server is notified immediately of the changes to the resource management

policy for the data source.

Example

This command modifies the resource management policy of the data source DDLTestDS:

SQL>alter resource "ESTIMATED COST", dsname DDLTestDS, limitvalue 9999, action "LOG_WITH_INFO";

166 Connectivity Commands