Add a Storage Pool Entry

Use this page to define the directories, files, and devices that the database server can use to expand a space.

Path

Type the full path name for the file, directory, or device that the server can use when additional storage space is required.

Offset

Specify the offset into the device at which the server can begin allocating space. If you specified a path to a directory, specify 0 as the offset.

Size

Specify the size of the storage pool entry.

Extendable

Select this option to make the storage pool entry extendable. If you specified a path to a directory, select this option.

Fixed by size

Select this option to specify a fixed size, in KB, for the storage pool entry.

Fixed by ending offset

Select this option to specify the ending offset, in KB, for the storage pool entry. The available storage is the ending offset minus the beginning offset.

Chunk Size

Specify the minimum size of a chunk that can be allocated from the storage pool entry.

Priority

Select the priority of the storage pool entry in the storage pool: high, medium, or low. The database server attempts to allocate space from a high-priority entry before it allocates space from a lower priority entry.

Show SQL

Click to display the SQL statement.