Create a Space
Use this page to create a storage space for a database server.
- Name
- Type a name for the space that is unique among the names of spaces in the database, including these types of space: dbspace, sbspace, blobspace, temporary dbspace, temporary sbspace, mirrored dbspace, mirrored sbspace, or mirrored blobspace. The name must follow the guidelines of SQL syntax for an identifier.
- Type
- Select the type of space: dbspace, temporary dbspace, blobspace, or sbspace.
- Size
- Specify the total size of the storage space, in KB (kilobytes), MB (megabytes), or GB (gigabytes).
- Page Size
- Specify the page size of the storage space. The default is the page size of the root dbspace.
- Offset
- Specify the offset, in KB, MB, or GB into the disk partition or into the device to reach the initial chunk of the space.
- Location
- Specify the location of the space.
- Specify the path
- Select this option to enter the path name of the disk partition or the device of the initial chunk of the dbspace that you are creating.
- Create the space from the storage pool
- Select this option to create the space from free space in the storage pool. This option is enabled when the storage pool contains entries.
- Make the space expandable
- This option requires IBM® Informix® 11.70.
- Select this option to configure
the database server to automatically expand the size of the storage
space when necessary by adding or extending a chunk.
- Create Size
- Specify the minimum size of a new chunk that the server can create for this space. Specify a number of kilobytes (KB) or a percentage of the total space. The create size must be greater than zero.
- Extend Size
- Specify the minimum size that the server can use when extending a chunk for this space. Specify a number of kilobytes (KB) or a percentage of the total space. The extend size must be greater than zero.
- Show SQL
- Click to display the SQL statement.