Hello everybody,

I'm running BaaNIVc4 on AIX with Informix. At the moment I have several (11) chunks defined, is there a way to remove the oldest chuncks and get back the disk space occupied by them? If so, how can I do that?

Thank's

It's possible if the chunk is empty:
example:
onspaces -d datdbs1 -p /informix/data/chunkxx -o 12

yes, its true, its possible if empty.

you also have to do a level 0 archive afterwards to have changes take affect. I posted some more info at www.baanfans.com under your same question a few days ago

Andy :cool:

before going to remove any chunks u must verify the chunk status using "onstat -d" command, here u can find out no. of pages allocated to chunk and free pages in chunk, by default for every first chunk of the dbspaces it uses 50 pages for its own use and every next chunk it uses 3 pages. so if different between allocated page size and free page size is not more than 50 for first chunk and 3 for first onwards, then u can drop the chunk using "onspaces" command or "using "onmonitor" also.

For safety purpose u can get the output of "oncheck -pe" into a file and go to those chunks u want to remove, if no table exist u can can drop the chunk without bothering.

anyway if chunk is not empty this can not be dropped.

alamb
alamb@dabur.com