Neoview Workload Management Services Guide (R2.5)

STATUS RULE Command
The STATUS RULE command returns information from shared memory about a specific rule or
all rules.
NOTE: Only administrators are permitted to run this command. By default, an administrator
is a user associated with ROLE.DBA, SUPER.SERVICES, or SUPER.SUPER.
Syntax
STATUS RULE [ { rule-name | ALL } ]
rule-name
returns status information about the specified rule. rule-name is the name of a user-defined
rule. The rule name is not case-sensitive and is always converted to uppercase. WMS supports
multibyte characters in the rule name. For more information, see Table A-18 (page 240)
ALL
returns information about all rules. For output information, see Table A-18 (page 240)
Considerations
The STATUS RULE command returns this status information:
Table A-18 STATUS RULE Output
DescriptionData TypeColumn Name
CONN, COMP, or EXECVARCHAR(4)TYPE
Name of the ruleVARCHAR(96)NAME
AND, ORVARCHAR(3)OPER
Ordinal number of the expression relative to other expressions
in the rule. It is the position of the expression in the list of
expressions in the rule definition.
INTEXPR_PRTY
External form of the rule expressionVARCHAR(128)EXPR
LOW, MEDIUM, HIGH, NO-WARNVARCHAR(8)WARN_LEVEL
HOLD, REJECT, CANCEL, or the SQL string to executeVARCHAR(1024)ACT
For connection rules, this field contains the types of SQL
queries that will have their statistics aggregated:
INSERT (unique or non-unique)
UPDATE (unique or non-unique)
DELETE (unique or non-unique)
SELECT (unique—accessing one row of data)
This field does not apply to compilation or execution rules
and is therefore blank for those rules.
For more information, see “Query Statistics Aggregation”
(page 27).
VARCHAR(30)AGGR_QUERY_TYPES
For connection rules, this field contains the frequency, in
minutes, at which the aggregated statistics are written to the
Repository.
This field does not apply to compilation or execution rules
and is therefore set to zero for those rules.
INTAGGR_REPOS_INTERVAL
240 WMS Commands