Neoview Workload Management Services Guide (R2.5)

INFO RULE Command
The INFO RULE command returns information from the WMS metadata about a specific rule
or all rules. The metadata is updated less often than shared memory in WMS. See the “STATUS
RULE Command” (page 240), which returns information from shared memory.
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
INFO RULE [ { rule-name | ALL } ]
rule-name
is the name of a user-defined rule. rule-name must exist in the WMS configuration. The
rule name is not case-sensitive and is always converted to uppercase. WMS supports multibyte
characters in the rule name. For guidelines on using multibyte character sets, see the Neoview
Character Sets Administrator's Guide.
Considerations
The INFO RULE command returns this information about rules in WMS:
Table A-2 INFO 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
214 WMS Commands