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

"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.
• Changes take effect on the next connection to an NDCS server in the data source.
Example
This command adds a resource policy to the data source DDLTestDS:
SQL>add resource "ESTIMATED COST", dsname DDLTestDS, limitvalue 10000, action "LOG";
ADD USER Command
The ADD USER command assigns NDCS privileges to a Neoview role.
Syntax
ADD USER role-name, PERMISSION type
type is:
USER | OPERATOR
role-name
is the name of a Neoview role, such as ROLE.MGR.
PERMISSION USER
assigns USER privileges to the role. Users associated with roles that have USER privileges
do not have NDCS privileges and cannot change the status or configuration of the NDCS
services, data sources, or servers.
158 Connectivity Commands