Drop a Chunk in a Dbspace, Blobspace, or Sbspace

Home | Previous Page | Next Page Administrative Utilities > Managing Storage Spaces with the onspaces Utility >

Drop a Chunk in a Dbspace, Blobspace, or Sbspace

Drop a Chunk:
 
|-- -d--+-dbspace----------+-- -p--pathname-- -o--offset-------->
        +-blobspace--------+
        '-+-----+--sbspace-'
          '- -f-'
 
>--+-----+------------------------------------------------------|
   '- -y-'

Element	Purpose	Key Considerations
-d	Drops a chunk	Restrictions: You can drop a chunk from a dbspace, temporary dbspace, or sbspace when the database server is online or quiescent. For more information, see the chapter on managing disk space in the IBM Informix Administrator's Guide. You can drop a chunk from a blobspace only when the database server is in quiescent mode.
-f	Drops an sbspace chunk that contains user data but no metadata If the chunk contains metadata for the sbspace, you must drop the entire sbspace.	Restrictions: Use the -f option with sbspaces only. If you omit the -f option, you cannot drop an sbspace that contains data. References: 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 chunk of the dbspace, blobspace, or sbspace that you are dropping	Restrictions: Unsigned integer. The starting offset must be equal to or greater than 0. The starting offset plus the chunk size cannot exceed the maximum chunk size. The maximum offset is 4 terabytes. References: For more information, see allocating raw disk space on UNIX, in the chapter on managing disk space in the IBM Informix Administrator's Guide.
-p pathname	Indicates the disk partition or unbuffered device of the initial chunk of the dbspace, blobspace, or sbspace that you are dropping	Additional Information: The chunk must be an existing unbuffered device or buffered file. When you specify a pathname, you can use either a full pathname or a relative pathname. However, if you use a relative pathname, it must be relative to the directory that was the current directory when you initialized the database server. References: For pathname syntax, see your operating-system documentation.
-y	Causes the database server to automatically respond yes to all prompts	None.
blobspace	Names the blobspace from which the chunk is dropped	References: Syntax must conform to the Identifier segment; see the IBM Informix Guide to SQL: Syntax. For more information, see dropping a chunk from a blobspace, in the chapter on managing disk space in the IBM Informix Administrator's Guide.
dbspace	Names the dbspace from which the chunk is dropped	References: Syntax must conform to the Identifier segment; see the IBM Informix Guide to SQL: Syntax. For more information, see dropping a chunk from a dbspace with onspaces, in the chapter on managing disk space in the IBM Informix Administrator's Guide.
sbspace	Names the sbspace from which the chunk is dropped	References: Syntax must conform to the Identifier segment; see the IBM Informix Guide to SQL: Syntax. For background information, see dropping a chunk from a dbspace with onspaces, in the chapter on managing disk space in the IBM Informix Administrator's Guide.

Important:

You must specify a pathname to indicate to the database server that you are dropping a chunk.