Neoview Workload Management Services Guide (R2.4)

STATUS RULE Command
The STATUS RULE command returns information about a specific rule or all rules.
NOTE: Only administrators are permitted to run this command. By default, an administrator
is ROLE.DBA or the super ID (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-17 (page 138)
ALL
returns information about all rules. For output information, see Table A-17 (page 138)
Considerations
• The STATUS RULE command returns this status information:
Table A-17 STATUS RULE Output
DescriptionData TypeColumn Name
CONN, COMP, or EXECVARCHAR(4)TYPE
Name of the ruleVARCHAR(96)NAME
AND, ORVARCHAR(3)OPER
Relative priority of the expression to other expressions in
the rule
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
Comment stringVARCHAR(256)COMMENT
Examples
• This command displays information for the specified rule:
STATUS RULE COMPRULE1;
• This command displays information for all rules:
STATUS RULE ALL;
138 WMS Commands