Autonomic self-tuning of database management system in dynamic logical partitioning environment

A database partition monitoring and reconfiguration system, comprising:

• one or more central processing units;
• a memory operatively coupled to said one or more central processing units;
• said memory storing program logic that runs in an execution context of said one or more central processing units to implement;
• monitoring means for monitoring one or more database application-level resource parameters in a logical partition running a database application in a logically partitioned data processing host, said resource parameters being defined by said database application and including tunable database parameters that are associated with database management operations or database storage and integrity;
• suggestion means associated with said monitoring means for determining partition resources to be reallocated based on said resource parameters and for suggesting dynamic logical partition reconfiguration in the event that said parameters vary from predetermined parameter values, said partition resources being different from said resource parameters but utilized by said database application to operate according to said resource parameters;
• and
• listener means for determining how suggestions for reconfiguration from said suggestion means can be handled and for interacting with a dynamic logical partitioning function associated with said data processing host to implement said suggestions.

A database partition monitoring and reconfiguration system, comprising:

• one or more central processing units;
• a memory operatively coupled to said one or more central processing units;
• said memory storing program logic that runs in an execution context of said one or more central processing units to implement;
• monitoring means for monitoring one or more database application-level resource parameters in a logical partition running a database application in a logically partitioned data processing host, said resource parameters being defined by said database application and including tunable database parameters that are associated with database management operations or database storage and integrity;
• suggestion means for determining partition resources to be reallocated based on said resource parameters and for requesting dynamic logical partition reconfiguration in the event that said parameters vary from predetermined parameter values;
• and
• listener means for receiving requests for partition reconfiguration from said suggestion means and for 1) checking resource availability in a resource free pool of said data processing host, 2) checking resource availability in other logical partitions of said data processing host in response to said free pool not having enough resources, and 3) attempting to partially satisfy said request for partition reconfiguration in response to said free pool and other partitions not having enough resources.