Re: Droping an unused chunk
In article <33A7D195.41C6@uk.ibm.com>, Daniel Williams
<danny@uk.ibm.com> writes
>Winson Kwok wrote:
>>
>> Dear Gurus,
>>
>> If I have a chunk that's not used (but added to the dbs) is it possible
>> to drop it to free space.
>>
>> Chris
>
>
>Simple answer: No
>
>Soution: Backup the dbspace; drop the dbspace; recreate the dbspace with
>the smaller size; restore the backup.
>
>There may be an method known to Informix employees (such as messing
>around with sysmaster tables) but I don't know of one.
>
>Dan
If you are running Online 5 then you cannot drop an unused chunk.
If you are running Online 7 then run
onspaces -d <dbspaces> -p <pathname> -o <offset>
for the chunk you wish to drop.
--
David Williams