Neoview Workload Management Services Guide (R2.5)

STATUS RULE COMP Command
The STATUS RULE COMP command returns information from shared memory about all the
compilation 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 COMP
Considerations
The STATUS RULE COMP command returns this status information:
Table A-19 STATUS 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(8)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 the statistics for all compilation rules:
STATUS RULE COMP;
242 WMS Commands