Patent ID: 7305379
Filing Date: 2007-12-04
Classification: G06F,Y10S

Abstract:
1. A method for managing a storage system that stores databases as storage objects in tablespaces, said method comprising: storing in a policy manager policies for storage allocation, wherein each of said policies is named and specifies performance and workload requirements for tablespaces; receiving, by said database, a command to create a tablespace, wherein said command specifies by name a policy; creating, by a database, said tablespace; establishing, by said policy manager, a storage allocation for said tablespace based on said policy; detecting if said tablespace is out of storage, wherein said detecting comprises using an autonomic agent of said database to detect whether said tablespace is out of storage; automatically, and without user intervention, extending said storage allocation for said tablespace based on said policy, when said tablespace is out of storage; monitoring said storage system and determining if said performance and workload requirements are being met by said storage system; and adjusting said storage allocation to achieve said performance and workload requirements, wherein said detecting process is performed during a tablespace transaction and said extending process is performed while said transaction is pending, without failing said transaction.