find table in chunk
Can someone show me how to find out if a chunk has any table allocated in it? Thanks.
↪ replying to Thanh Ngo
do an oncheck -pe. The output will give you what's in each chunk.
Or if you're really feeling gutsy, try dropping the chunk. I think
informix won't allow you to drop a chunk with active data in it, but do
so at your own risk.
Thanh Ngo wrote:
> Can someone show me how to find out if a chunk has
> any table allocated in it?
>
> Thanks.
--
Phillip Tien
Database Administrator
Whole Foods Market, Inc.