Drop a Chunk

Home | Previous Page | Next Page Utility Reference > onutil: Check, Define, and Modify Storage Objects > ALTER DBSPACE >

Drop a Chunk

DROP CHUNK Clause:

|--DROP CHUNK--"--pathname--"--+----------------+---------------|
                               '-OFFSET--offset-'

Element	Purpose	Restrictions	Syntax
offset	The offset, in kilobytes, into the file or raw device to reach the chunk	Value must be greater than or equal to 0. See the chapter on managing disk space in the IBM Informix: Administrator's Guide.	Unsigned integer.
pathname	The file or raw device for the chunk that you are dropping	The chunk must be an existing file or raw device. Use a full pathname.	Pathname must conform to the operating-system-specific rules for pathnames.

Usage

Use the onutil ALTER DBSPACE command with the DROP CHUNK clause to drop a chunk. If you drop a chunk that is mirrored, the mirrored chunk is also dropped.

Dropping a Chunk from a Dbspace

The following example shows how to use onutil ALTER DBSPACE to drop a chunk, test_chunk, from the root dbspace:

% onutil
1> ALTER DBSPACE rootdbs
2> DROP CHUNK "/ix/mywork/test_chunk"
3> OFFSET 0
Chunk successfully dropped.

The chunk must be empty before you can drop it. You must free all pages other than overhead pages. If any pages remain allocated to nonoverhead entities, onutil returns the following error:

Chunk is not empty.

You cannot drop the initial chunk of a dbspace. Use the chunk column of xctl onstat -d to determine the initial chunk of a dbspace. For more information, see The onstat -d Option.