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.