Configuration Mode Commands : SteelHead Configuration Commands : MS-SQL Blade Support Commands : protocol ms-sql query-act rule-id action-id num-reps
  
protocol ms-sql query-act rule-id action-id num-reps
Specifies a query action when the corresponding query match occurs.
Syntax
[no] protocol ms-sql query-act rule-id <rule-id> action-id <action-id> num-reps <num-reps> | invalidate {flush-all | flush-rule}] [miss-policy <policy> | allow-preack {true | false} | scope {sfe | cfe}]]
Parameters
rule-id <rule-id>
Specifies the rule identification number that uniquely identifies the rule.
action-id <action-id>
Specifies the action identification number that uniquely identifies this action within the rule.
num-reps <num-reps>
Specifies how many times the action is to be repeated.
invalidate <invalidate-action> {flush-all | flush-rule}
Invalidates the specified action: flush-all or flush-rule.
miss-policy <policy>
Specifies the MS-SQL cache miss policy.
allow-preack {true | false}
Specifies whether to allow the MS-SQL pre-acknowledgment (true) or not (false).
scope {sfe | cfe}
Specifies MS-SQL scope: sfe or cfe.
Usage
You can specify the following types of actions:
•  prefetch requests as specified in query argument actions.
•  invalidate prefetched cache entries.
The no command option disables the query action.
Example
amnesiac (config) # protocol ms-sql query-act rule-id 10 action-id 1 num-reps 1 miss-policy 1
amnesiac (config) # service restart
Product
SteelHead CX, SteelHead EX, SteelHead-v, SteelHead-c
Related Commands
show protocol ms-sql