Often, when attempting to coordinate a combined decision-support system (DSS) where users read the data in the database but never write to it, and an online transaction processing (OLTP) environment where application end users write to the back-end database, DSS users tend to use large amounts of resources on the remote Adaptive Server.
OpenSwitch allows you to automatically cancel or terminate connections that overuse Adaptive Server by setting the RMON parameter to 1 in the [CONFIG] section of the OpenSwitch configuration file, then using the [LIMIT_RESOURCE] section to set the maximum amount of a resource that can be consumed by a given connection.
You must set the RMON parameter
in the [CONFIG] section to have the options in
the [LIMIT_RESOURCE] section take effect.
This allows you to define resource limits in terms of user name, application name, and host name of incoming user connections, so you can define different resource limits based on the type of incoming connection. You can also configure the resource monitor to either forcibly terminate offending connections, or cancel the current query and return control to the client application with a notification of the reason for the cancellation.
See “[CONFIG]” and “[LIMIT_RESOURCE]” for more information.
