Home
AdministeringIn addition to administering the database server, you can tune performance, replicate data, and archive data.
System administrationThese topics contain concepts, procedures, and reference information for database and database server administrators to use for managing and tuning HCL OneDB™ database servers.
Administrator's GuideThe HCL OneDB™ Administrator's Guide provides the information required to administer HCL OneDB™.
Disk, memory, and process management
Manage disk spaceYou can use several utilities and tools to manage disk spaces and the data that the database server controls.
Automatic space managementYou can configure the server to add more storage space automatically when more space is required. You use space more effectively and ensure that space is allocated as necessary, while reducing out-of-space errors. You reduce the time required to manually monitor your spaces to determine which storage space might run out of free space. If you configure the server to automatically add space, you can also manually expand a space or extend a chunk.
Manually expanding a space or extending an extendable chunkYou can manually expand a space or extend a chunk when necessary, instead of waiting for OneDB to automatically expand the space or extend a chunk.

Manually expanding a space or extending an extendable chunk

You can manually expand a space or extend a chunk when necessary, instead of waiting for OneDB to automatically expand the space or extend a chunk.

Before you begin

Prerequisites:

You can extend a chunk only if it is in an unmirrored dbspace or temporary dbspace.
The chunk must be marked as extendable before it can be extended. If not, you must run the admin() or task() function with the modify chunk extendable argument to specify that the chunk is extendable.
If a space cannot be expanded by extending a chunk, the storage pool must contain active entries that the server can use to create new chunks.

Procedure

To immediately increase your storage space:

Either:

Manually expand a space by running the admin() or task() function with the modify space expand argument, as follows:
```
EXECUTE FUNCTION task("modify space expand", "space_name", "size");
```
For example, the following command expands space number 8 by 1 gigabyte:
```
EXECUTE FUNCTION task("modify space expand", "8", "1000000");
```
The server expands the space either by extending a chunk in the space or adding a new chunk. The server might round the requested size up, depending on the page size of the storage space and the configured chunk size for any storage pool entry used during the expansion.
Manually extend a chunk by running the admin() or task() function with the modify chunk extend argument, as follows:
```
EXECUTE FUNCTION task("modify chunk extend", "chunk_number", "extend_amount");
```
For example, the following command extends chunk number 12 by 5000 KB:
```
EXECUTE FUNCTION task("modify chunk extend", "12", "5000");
```
The server might round the requested size up, depending on the page size of the storage space.