Governing

When a user submits a request against any database monitored by SmartMode, the governing facility performs high-speed resource usage estimates at run time, using the rules that it previously determined. It uses the rules that are stored in the rule file associated with the database. SmartMode decides whether to run or cancel each request based on the rule file. Depending on the decision, one of the following actions occurs:

In this section: Using ADVISE How to: Select a Rule Files for a Database Turn Governing On and Off

• Run. The request is allowed to execute.
• Cancel. The request is terminated and a cancellation message is returned to the client.
• Advise. SmartMode indicates which requests would have been cancelled if Governing had been set on. For more information, see Using ADVISE.

In addition to the resources each request may use, SmartMode considers the time of day, the date, and detailed characteristics of the request and compares this to the information in the rule file.

The Governor can be turned on or off for any database at any time, but before you can turn Governing on you must assign a rule file to the database.

Procedure: How to Select a Rule Files for a Database

Before you can turn on governing for a database, you must associate a rule file with the database. You can associate a rule file that contains data rules for that database, or a rule file that contains only Custom rules, which is therefore database independent and can be assigned to any database.

1. Select the Database Monitor/Govern maintenance option. The Database Monitor/govern maintenance screen opens.

2. Type an S in the Opt column next to the database you wish to assign a Rule file and press Enter.

All available Rule files for the selected database display. This includes any Rule files with data rules for the selected database and rule files that contain only Custom rules.

3. Type an S in the Opt column next to the Rule file you wish to assign to the database.

4. Press Enter to assign the Rule file and return to the Database Monitor/Govern Maintenance screen.

Procedure: How to Turn Governing On and Off

Once you have assigned a rule file to a database, you can begin to govern the requests submitted against it.

1. Select Database monitor/govern maintenance from the Database Control menu. The Database monitor/govern monitor window opens:

2. Enter Start, Stop, or Advise in the Governing column for the appropriate database.

3. Press Enter.

Using ADVISE

ADVISE is a feature that enables the system administrator to ease SmartMode into the production environment. When the governing mode is ADVISE, the Usage Monitor indicates which request would have been cancelled if governing had been set on. Before the report displays, a message is returned to the user indicating that the request would have been cancelled.

ADVISE gives you the ability to log data about a request that would normally have been cancelled by SmartMode. With this information, you can then decide if the threshold limits in effect are correct, and if governing should be turned on.