Neoview Workload Management Services Guide (R2.5)

INFO RULE COMP Command
The INFO RULE COMP command returns information from the WMS metadata about all the
compilation rules. The metadata is updated less often than shared memory in WMS. See the
“STATUS RULE COMP Command” (page 242), 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 COMP
Considerations
The INFO RULE COMP command returns this information about rules in WMS:
Table A-3 INFO RULE COMP Output
DescriptionData TypeColumn Name
COMPVARCHAR(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(6)WARN_LEVEL
HOLD, REJECT, or the SQL string to executeVARCHAR(1024)ACT
This field does not apply to compilation rules and is therefore
blank.
VARCHAR(30)AGGR_QUERY_TYPES
This field does not apply to compilation rules and is therefore
set to zero.
INTAGGR_REPOS_INTERVAL
This field does not apply to compilation rules and is therefore
set to zero.
INTAGGR_WMS_INTERVAL
This field does not apply to compilation rules and is therefore
set to zero.
INTAGGR_EXEC_INTERVAL
Comment stringVARCHAR(256)COMMENT
Example
This command displays information about the all the compilation rules:
INFO RULE COMP;
216 WMS Commands