Patent ID: 8495627

Claim:
A method for allocating resources in a logically partitioned multiprocessor environment, the method comprising: monitoring resource usage in a first logical partition in the logically partitioned multiprocessor environment to predict a future underutilization of a resource in the first logical partition, wherein monitoring resource usage includes monitoring a set of commands known to release resources when executed including checking commands to be executed at the first logical partition to determine whether a respective command to be executed at the first logical partition corresponds to the set of commands known to release resources when executed, and wherein predicting the future underutilization of the resource is based on whether the respective command to be executed by the first logical partition corresponds to the set of commands known to release resources when executed; in response to determining that the respective command corresponds to the set of commands known to release resources when executed, communicating the predicted future underutilization to a database query optimizer executing in a second logical partition in the logically partitioned multiprocessor environment such that the database query optimizer generates a query plan for a query to be executed during at least a portion of the predicted future underutilization of the resource with the query plan optimized to utilize at least a portion of the resource during execution of the query plan; and executing the query plan generated by the database query optimizer in the second partition utilizing the portion of the resource at a time associated with the predicted future underutilization of the resource and while the portion of the resource is allocated to the second partition, wherein communicating the predicted underutilization to the database query optimizer is performed prior to the time associated with the predicted future underutilization of the resource and execution of the query plan while the portion of the resource is allocated to the second partition.