Partition by growth table space

A system comprising:

• a database;
• a computer operably connected to the database, including a processor for processing an application and a storage operably connected to the processor for storing the application, wherein the application may be loaded into a main memory for execution by the processor and wherein the application:
• responsive to receiving a request to insert a record into a database table in the database, searches the partitioned table space to find available free space in a set of partitions in the table space, wherein each of the set of partitions which vary in size is created without a need for defining a key range for the set of partitions, the each of the set of partitions is composed of plurality of segments;
• and each of the plurality of segments is in fixed size;
• responsive to a determination that free space is unavailable for the record in the set of partitions, creates a new partition for the table space based on a size for the new partition, wherein the new partition is not created based on a key range for the new partition, and wherein the new partition is composed of the plurality of segments, and wherein the size for the new partition is determined from growth characteristics and new keywords in a structured query language statement, and wherein the size for the new partition is not defined at the time the table space is created;
• and inserts the record into the new partition;
• at least one client operably connected to the computer with access to the database.

A tangible computer storage medium having a computer program product encoded thereon for managing a table space for a database, the computer program product including:

• computer usable program responsive to receiving a request to insert a record into a database table in the database, for searching the partitioned table space to find available free space in a set of partitions in the table space, wherein each of the set of partitions which vary in size is created without a need for defining a key range for the set of partitions, the each of the set of partitions is composed of plurality of segments;
• and each of the plurality of segments is in fixed size;
• computer usable program code responsive to a determination that free space is unavailable for the record in the set of partitions, for creating a new partition for the table space based on a size for the new partition, wherein the new partition is not created based on a key range for the new partition, and wherein the new partition is composed of the plurality of segments, and
• wherein the size for the new partition is determined from growth characteristics and new keywords in a structured query language statement, and wherein the size for the new partition is not defined at the time the table space is created;
• and
• computer usable program code for inserting the record into the new partition.