Automatic Storage Provisioning

NOTE:
Automatic Storage Provisioning function is available only for IBM Informix Dynamic Server 11.70. Previous versions of Dynamic Server do not support this function.

Every instance of Dynamic Server 11.70 has a storage pool. The storage pool contains information about the directories, cooked files, and raw devices that the server can use if necessary to automatically expand an existing dbspace, temporary dbspace, sbspace, temporary sbspace, or blobspace.

When the storage space falls below a threshold defined in the SP_THRESHOLD configuration parameter, Dynamic Server can automatically run a task that expands the space, either by extending an existing chunk in the space or by adding a new chunk.

You can use Server Studio GUI to:

• Add, delete, or modify an entry that describes one directory, cooked file, or raw device in the storage pool. The server can use the specified directory, cooked file, or raw device when necessary to automatically add space to an existing storage space.
• Control how a storage pool entry is used by modifying two different dbspace sizes that are associated with expanding a storage space, the extend size and the create size.
• Mark a chunk as extendable or not extendable.
• Immediately expand the size of a space, when you do not want Dynamic Server to automatically expand the space.
• Immediately extend the size of a chunk by a specified minimum amount.
• Create a storage space or chunk from an entry in the storage pool.
• Return empty space from a dropped storage space or chunk to the storage pool.

To perform storage related operations, select Storage folder under IDS server node in the Object Explorer tree.

Creating a storage pool entry

Each entry in the storage pool contains information about a directory, cooked file, or raw device that a Dynamic Server 11.7 instance can use if necessary to automatically expand an existing dbspace, temporary dbspace, sbspace, temporary sbspace, or blobspace.

To create a storage pool entry in Server Studio, expand Storage folder under IDS server node in the Object Explorer, select Storage Pool subfolder and press Add Entry button on Storage Pool properties panel.

Specify the following information in Add storage Pool Entry dialog box:

• The path for the file, directory, or device that the server can use when additional storage space is required.
• The offset in kilobytes into the device where Dynamic Server can begin allocating space.
• The total space available to Dynamic Server in this entry. The server can allocate multiple chunks from this amount of space.
• The minimum size in kilobytes of a chunk that can be allocated from the device, file, or directory.
• Priority. The server attempts to allocate space from a high-priority entry before it allocates space from a lower priority entry.

Modifying a storage pool entry

To modify a storage pool entry in Server Studio, expand Storage folder under IDS server node in the Object Explorer, expand Storage Pool subfolder, select required pool entry in the tree or in the properties panel grid and select Edit from popup menu.

Specify new parameters and press Save button.

Deleting storage pool entries

To delete a storage pool entry in Server Studio, expand Storage folder under IDS server node in the Object Explorer, expand Storage Pool subfolder, select required pool entry in the tree or in the properties panel grid and select Delete from popup menu.