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.
Manage the plogspaceYou create or move the plogspace with the onspaces utility or equivalent SQL administration API command.

Manage the plogspace

You create or move the plogspace with the onspaces utility or equivalent SQL administration API command.

To create the plogspace, run the onspaces -c -P command or the admin() or task() SQL administration API function with the create plogspace argument.

If you want to change the location of the plogspace to a different chunk, create a new plogspace. The physical log is moved to the new plogspace and the old plogspace is dropped.

You can modify the chunk in the plogspace in the following ways:

Mark the chunk as not extendable. Run the admin() or task() SQL administration API function with the modify chunk extendable off argument
Change the extend size of the chunk. The default extend size is 10000 KB. Run the admin() or task() SQL administration API function with the modify space sp_sizes argument.