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:

- a maximum number of DB2 buffer lookups
- a maximum number of I/O requests or dataspace page transfers
- a maximum statement response time
- a maximum LUW response time
- a maximum lock wait time
- a maximum lock hold time
- a maximum checkpoint delay time
- a maximum idle time, while in LUW
- a maximum number of writes to the DB2 log

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.