Verify whether a chunk is empty

To drop a chunk successfully from a dbspace with either of these utilities, the chunk must not contain any data. All pages other than overhead pages must be freed.

If any pages remain allocated to nonoverhead entities, the utility returns the following error: Chunk is not empty.

In addition, when a dbspace consists of two or more chunks and the additional chunks do not contain user data, the additional chunks cannot be deleted if the chunks contain a tblspace tblspace.

If you receive the Chunk is not empty message, you must determine which table or other entity still occupies space in the chunk by running oncheck -pe to list contents of the extent.

Usually, the pages can be removed when you drop the table that owns them. Then reenter the utility command.

Copyright© 2018 HCL Technologies Limited