RelationalDBDesign RelationalDBDesign

Table Space Management   «Prev 

Database Resource Manager

Example of a Resource Management Plan

Database Resource Manager components

Location 1 The plan is the top of a hierarchy of plan directives and consumer groups. It is also possible to create subplans. Only one plan can be in effect at one time, but you can define multiple plans in one database and switch between the plans.
Location 2 Each plan directive contains resource limitation settings. The settings define CPU levels and usage within levels and session parallelism.
Location 3 A database can have many consumer groups. Each one has a name and is intended to be a group of users with common resource consumption needs. You assign a plan directive to each consumer group, thus limiting the group's resources.
Location 4 A user can be assigned to one consumer group at a time. When the user is not explicitly assigned to a consumer group, the user is assigned to a default consumer group.
Location 5 A user's sessions belong to the user, and therefore all the restrictions of the user's consumer group apply to all the user's sessions.