Governor facility


The SQL/MF Governor continuously checks database resource consumption by users and packages. The facility prevents excessive consumption by applying installation-defined restrictions, which define the maximum amount of system resources, a user or package is allowed to consume. Users that violate a restriction, will be forced off the database by the Governor.

Restrictions are defined in the restriction control file as:

INCLUDE and EXCLUDE statements define the users and packages, subject to restricting.

The Governor applies defined restrictions to all users and packages, both static and dynamic.

Sample restriction control file.