In This Chapter

You can perform the following tasks with the onspaces utility:

• Create a dbspace or temporary dbspace.
• Create a blobspace.
• Create an extspace.
• Create an sbspace or temporary sbspace.
• Change sbspace default specifications.
• Clean up stray smart large objects in sbspaces.
• Drop a dbspace, blobspace, sbspace, or extspace.
• Rename a dbspace, blobspace, sbspace, or extspace.
• Add a chunk to a dbspace or blobspace.
• Add a chunk to an sbspace.
• Drop a chunk in a dbspace, blobspace, or sbspace.
• Start mirroring.
• End mirroring.
• Change status of a mirrored chunk.
• Specify the DATASKIP parameter.

When you use onspaces or ISA to manage a storage space, the database server updates information about the space in the oncfg_servername.servernum file. For more information on the oncfg* file, refer to Appendix A. Files That the Database Server Uses.

You can specify a maximum of 2047 chunks for a storage space, and a maximum of 2047 storage spaces on the database server system. The storage spaces can be any combination of dbspaces, blobspaces, and sbspaces.

On UNIX, you must be logged in as user root or user informix to execute onspaces. On Windows, you must be a member of the Informix-Admin group.