Re: can't drop chunk from sbspace

> hi all! > i'm using solaris 2.5.1 with IUS 9.14.UC3 > I don't know why I can't drop a chunk from a sbspace. > with onstat -d , i choose to drop the chunk from clientsbsp3 > > onstat -d> > INFORMIX-Universal Server Version 9.14.UC3 -- On-Line -- Up 7 days > 11:19:15 -- 92872 Kbytes > > Dbspaces > address number flags fchunk nchunks flags owner name > c0a2108 1 2 1 1 M informix rootdbs > c0a2a68 2 1 2 1 N informix dbsp1 > c0a2ae0 3 1 3 1 N informix logdbsp > c0a2b58 4 2001 4 1 N T informix tempdbsp > c0a2bd0 5 2 5 1 M informix clientdbsp > c0a2c48 6 8002 6 1 M S informix clientsbsp > c0a2cc0 7 8001 7 1 N S informix clientsbsp2 > d14fd38 8 8001 8 1 N S informix clientsbsp3 > 8 active, 2047 maximum > > Chunks > address chk/dbs offset size free bpages flags pathname > c0a2180 1 1 128 450000 447710 PO- > /dev/rdsk/c0t2d0s0 > c0a2258 1 1 128 450000 0 MO- > /dev/rdsk/c0t3d0s0 > c0a23a8 2 2 128 500000 499897 PO- > /dev/rdsk/c0t2d0s1 > c0a2480 3 3 128 500000 191747 PO- > /usr/informix/dbspaces/logdbsp > c0a2558 4 4 64 497500 497447 PO- > /usr/informix/dbspaces/tempdbsp > c0a2630 5 5 64 497500 313643 PO- > /usr/informix/dbspaces/clientdbsp > c0a28b8 5 5 64 497500 0 MO- > /usr/informix/dbspaces/m_clientdbsp > c0a2708 6 6 64 499980 344826 474927 POS > /usr/informix/dbspaces/clientsbsp > c0a2990 6 6 64 499980 0 MOS > /usr/informix/dbspaces/m_clientsbsp > c0a27e0 7 7 8 475000 368229 463239 POS > /usr/informix/dbspaces/clientsbsp2 > d14fdb0 8 8 0 750000 749747 749747 POS > /usr/informix/dbspaces/clientsbsp3 > 8 active, 2047 maximum > > here i 'm looking for the link > > ls -l /usr/informix/dbspaces/clientsbsp3 > lrwxrwxrwx 1 informix informix 18 Jul 15 19:46 > /usr/informix/dbspaces/clientsbsp3-> /dev/rdsk/c0t5d0s1 > > so I use onspaces: > onspaces -d clientsbsp3 -p /dev/rdsk/c0t5d0s1 -o 0> but i doesn't work, i got this output: > > onspaces -d clientsbsp3 -p /dev/rdsk/c0t5d0s1 -o 0> WARNING: Dropping a chunk. > Do you really want to continue? (y/n)y > Chunk not dropped. > ISAM error: No such chunk> > I really don't why it doesn't work. > any help will be appreciate. > thanks First, why are you using the /dev/rdsk/c0t5d0s1? The "No such chunk" message is because Informix doesn't recognize any chunks with the specified combination of path and offset. From the output of your 'onstat -d' it appears that Informix knows the chunk to be on /usr/informix/dbspaces/clientsbsp3, so that should be what you use for the '-p' in your onmode command. Secondly, since there is only one chunk, this probably won't work anyway. With only one chunk, you are effectively dropping the entire dbspace, so try 'onmode -d clientsbsp3'. Of course, all of my experience is with 7.x, so 9.x may have a few quirks that invalidate my suggestions. Mark Collins mcollins@us.dhl.com