Neoview Workload Management Services Guide (R2.5)

INFO RULE CONN Command
The INFO RULE CONN command returns information from the WMS metadata about all the
connection rules. The metadata is updated less often than shared memory in WMS. See the
“STATUS RULE CONN Command” (page 243), 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 CONN
Considerations
The INFO RULE CONN command returns this information about connection rules in WMS:
Table A-4 INFO RULE CONN Output
DescriptionData TypeColumn Name
CONNVARCHAR(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, NO-WARNVARCHAR(6)WARN_LEVEL
The SQL string to executeVARCHAR(1024)ACT
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)
For more information, see “Query Statistics Aggregation”
(page 27).
VARCHAR(30)AGGR_QUERY_TYPES
Frequency, in minutes, at which the aggregated statistics are
written to the Repository
INTAGGR_REPOS_INTERVAL
Frequency, in minutes, at which the NDCS process updates the
WMS process after aggregation has started
INTAGGR_WMS_INTERVAL
Expected execution time of the query, in minutes. If the query's
execution time exceeds this interval, its statistics are written to
the Repository without being aggregated. If the query's execution
time is less than or equal to this interval, its statistics are
aggregated.
INTAGGR_EXEC_INTERVAL
Comment stringVARCHAR(256)COMMENT
Example
This command displays information about all connection rules:
INFO RULE CONN;
INFO RULE CONN Command 217