drop a chunk help

I am trying to drop a chunk that I just added to a db space. I created the chunk with the wrong size. There is no data in the chunk but I don't understand how to delete it. I tried onmonitor and onspaces. Onmonitor only shows deleting the dbspace that the chunk is in. Onspaces tells me the chunk does not exist. onspaces -d db5 -p /dev/informix/db5 -o 0Space does not exist. (db5 is part of the db1 db space) onstat -d output: IBM Informix Dynamic Server Version 9.40.UC5 -- On-Line -- Up 04:12:56 -- 1909760 Kbytes Dbspaces address number flags fchunk nchunks flags owner name 7d10e7d8 1 0x20001 1 1 N informix rootdbs 7d744c58 2 0x20001 2 1 N informix dblog 7d744da8 3 0x20001 3 1 N informix dbplog 7d745018 4 0x42001 4 1 N TB informix dbtmp 7d745168 5 0x60001 5 1 N B informix wmsnj 7d7452b8 6 0x60001 6 1 N B informix wmsmi 7d745408 7 0x60001 7 4 N B informix db1 7d745558 8 0x60001 10 1 N B informix dbtest 8 active, 2047 maximum Chunks address chunk/dbs offset size free bpages flags pathname 7d10e928 1 1 0 200000 197324 PO-- /dev/infor mix/dbroot 7d743d50 2 2 0 400000 156197 PO-- /dev/infor mix/dblog 7d744018 3 3 0 1000000 799947 PO-- /dev/infor mix/dbplog 7d7441a0 4 4 0 4000000 3999347 PO-B /dev/infor mix/dbtmp 7d744328 5 5 0 10000000 5702491 PO-B /dev/infor mix/wmsnj 7d7444b0 6 6 0 10000000 9999947 PO-B /dev/infor mix/wmsmi 7d744638 7 7 0 25000000 454 PO-B /dev/infor mix/db1 7d7447c0 8 7 0 25000000 58 PO-B /dev/infor mix/db2 7d744948 9 7 0 25000000 36792 PO-B /dev/infor mix/db3 7d744ad0 10 8 0 25000000 23841927 PO-B /dev/infor mix/db4 7d7d7018 11 7 0 12500000 12499997 PO-B /dev/infor mix/db5 11 active, 32766 maximum Expanded chunk capacity mode: enabled

Gary, You are not telling onspaces the right "space_name" based on the output above, the "space_name" is "db1", so try this: onspaces -d db1 -p /dev/informix/db5 -o 0 Regards, Daniel

On 9 Aug 2005 11:49:08 -0700, "caver" <dmcbryde@courts.state.va.us> wrote: >Gary, > >You are not telling onspaces the right "space_name" based on the output >above, the "space_name" is "db1", >so try this: > >onspaces -d db1 -p /dev/informix/db5 -o 0> >Regards, >Daniel Ahhh thank you. Gary