onspaces -a -p -o -s size -mpathname offset Useonspaces -ato add a chunk to an sbspace. ElementPurposeKey considerations -aIndicates that a chunk is to be addedYou can have up to 32766 chunks in an instance. You can put all those chunks in one storage space, or spread them among ...
For more information, see dropping a chunk from an sbspace with onspaces, in the chapter on managing disk space in the IBM Informix Administrator's Guide. -o offset Indicates, in kilobytes, the offset into the disk partition or into the unbuffered device to reach the initial chun...
Creates a dbspace, blobspace, sbspace, or extspace You can create up to 2047 storage spaces of any type. After you create a storage space, you must back up both this storage space and the root dbspace. If you create a storage space with the same name as a deleted storage space, perf...
Use the onspaces -d option to drop a dbspace, blobspace, plogspace, sbspace, or extspace. Syntax: onspaces -ddbspaceblobspaceplogspace -fsbspaceextspace -y ElementPurposeKey considerations -d Indicates that a storage space is to be dropped You can drop a dbspace, blobspace, plogspace, sb...
blobspaceNames the blobspace to be droppedBefore you drop a blobspace, drop all tables that include a TEXT or BYTE column that references the blobspace. dbspaceNames the dbspace to be droppedBefore you drop a dbspace, drop all databases and tables that you previously created in the dbspace....
onspaces -d dbspce5 This example drops a dbspace calledblobsp3and its mirrors. onspaces -d blobsp3 Use the-doption with the-foption if you want to drop an sbspace that contains data. If you omit the-foption, you cannot drop an sbspace that contains data. This example drops an sbspac...