Try OpenEdge Now
skip to main content
Database Administration
Maintaining and Monitoring Your Database : Multi-tenant database : Database utilities : Controlling the usage of multi-tenant database resources using multi-tenant governors
 
Controlling the usage of multi-tenant database resources using multi-tenant governors
There are two multi-tenant governors which you can use to control the usage of multi-tenant database resources. These governors limit a tenant's access to the shared database resources. These multi-tenant governors are:
*Login Governor (-nGovernor)
*Lock Governor (-LGovernor)
Note: These governors are applicable to only the default tenant and regular tenant in multi-tenant databases; these governors do not apply to a super-tenant. Also, these governors do not apply to non multi-tenant databases.
The Login Governor prevents a tenant from using all the database connections in a multi-tenant database. The Lock Governor prevents a tenant from acquiring all the locks in a lock table. You can regulate the amount of multi-tenant database resources used by a tenant by enabling these database startup parameters: -nGovernor and -LGovernor.
The Startup Virtual System Table (VST) contains the fields for the -nGovernor and -LGovernor startup parameters. For more information on Startup VST, see .
The PROMON utility and Database Administration console help you to monitor and change the governor values for these two startup parameters. For more information on how the PROMON utility monitors online Lock Governor, see PROMON Utility. For more information about Database Administration console, see OpenEdge Management and OpenEdge Explorer: Configuring Multi-tenancy.
When a governor is enabled in an online database, shared memory is allocated for the governor data structure. If the shared memory becomes insufficient, use the PROUTIL INCREASETO command to provide at least 256KB of additional shared memory. See PROUTILINCREASETO qualifier.