Neoview Workload Management Services Guide (R2.4)
Displaying the Definitions of All Rules
Use the STATUS RULE ALL command to display the definitions of all rules in WMS. The STATUS
RULE ALL command displays this information:
Type of rule: CONN (connection), COMP (compilation), or EXEC (execution)TYPE
Rule nameNAME
Operator: AND or OROPER
Priority of the expression relative to other expressions in the ruleEXPR_PRTY
External form of rule expressionEXPR
LOW, MEDIUM, HIGH, or NO-WARNWARN_LEVEL
HOLD, REJECT, CANCEL or the SQL string to executeACT
Comment stringCOMMENT
This example shows the definitions of all the rules in WMS:
NS%status rule all;
TYPE NAME OPER EXPR_PRTY EXPR WARN_LEVEL ACT
---- -------------------- ---- ----------- ------------------------------ ---------- ----------------------
COMMENT
-------------------------------------------------------------- --------------------------------------------
CONN HPS_MANAGEABILITY1 AND 1 APPL ICASE (HPDM) NO-WARN
Created by NWMS installation
CONN HPS_MANAGEABILITY1 AND 2 SESSION ICASE (MANAGEABILITY) NO-WARN
Created by NWMS installation
CONN HPS_MANAGEABILITY1 AND 3 LOGIN ICASE (SUPER.SERVICES) NO-WARN
Created by NWMS installation
CONN HPS_MANAGEABILITY2 AND 1 APPL ICASE (HPDM) NO-WARN
Created by NWMS installation
CONN HPS_MANAGEABILITY2 AND 2 SESSION ICASE (MANAGEABILITY) NO-WARN
Created by NWMS installation
CONN HPS_MANAGEABILITY2 AND 3 LOGIN ICASE (SUPER.SUPER) NO-WARN
Created by NWMS installation
CONN HPS_MANAGEABILITY3 AND 1 APPL ICASE (HPDM) NO-WARN
Created by NWMS installation
CONN HPS_MANAGEABILITY3 AND 2 SESSION ICASE (MANAGEABILITY) NO-WARN
Created by NWMS installation
CONN HPS_MANAGEABILITY3 AND 3 LOGIN ICASE (ROLE.DBA) NO-WARN
Created by NWMS installation
CONN HPS_MANAGEABILITY4 AND 1 APPL ICASE (Neoview Performance Analyzer)
NO-WARN
Created by NWMS installation
CONN HPS_MANAGEABILITY4 AND 2 SESSION ICASE (MANAGEABILITY) NO-WARN
Created by NWMS installation
CONN HPS_MANAGEABILITY4 AND 3 LOGIN ICASE (SUPER.SERVICES) NO-WARN
Created by NWMS installation
CONN HPS_MANAGEABILITY5 AND 1 APPL ICASE (Neoview Performance Analyzer)
NO-WARN
Created by NWMS installation
CONN HPS_MANAGEABILITY5 AND 2 SESSION ICASE (MANAGEABILITY) NO-WARN
Created by NWMS installation
CONN HPS_MANAGEABILITY5 AND 3 LOGIN ICASE (SUPER.SUPER) NO-WARN
Created by NWMS installation
CONN HPS_MANAGEABILITY6 AND 1 APPL ICASE (Neoview Performance Analyzer)
NO-WARN
Created by NWMS installation
CONN HPS_MANAGEABILITY6 AND 2 SESSION ICASE (MANAGEABILITY) NO-WARN
Created by NWMS installation
CONN HPS_MANAGEABILITY6 AND 3 LOGIN ICASE (ROLE.DBA) NO-WARN
Created by NWMS installation
CONN HPS_MANAGEABILITY7 AND 1 APPL ICASE (Neoview Query Viewer)
NO-WARN
Created by NWMS installation
CONN HPS_MANAGEABILITY7 AND 2 SESSION ICASE (MANAGEABILITY) NO-WARN
Created by NWMS installation
CONN HPS_MANAGEABILITY7 AND 3 LOGIN ICASE (SUPER.SERVICES) NO-WARN
Created by NWMS installation
CONN HPS_MANAGEABILITY8 AND 1 APPL ICASE (Neoview Query Viewer)
NO-WARN
Created by NWMS installation
CONN HPS_MANAGEABILITY8 AND 2 SESSION ICASE (MANAGEABILITY) NO-WARN
Created by NWMS installation
CONN HPS_MANAGEABILITY8 AND 3 LOGIN ICASE (SUPER.SUPER) NO-WARN
Created by NWMS installation
CONN HPS_MANAGEABILITY9 AND 1 APPL ICASE (Neoview Query Viewer)
NO-WARN
Created by NWMS installation
66 Configuring Rules