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.