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 0but i doesn't work, i got this output: > onspaces -d clientsbsp3 -p /dev/rdsk/c0t5d0s1 -o 0WARNING: 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 georges.

On Thu, 15 Jul 1999 20:30:32 +0200, "georges Chaleunsinh" <gchaleunsin@imaginet.fr> wrote: >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 [snip] >d14fd38 8 8001 8 1 N S informix clientsbsp3 [snip] >Chunks >address chk/dbs offset size free bpages flags pathname [snip] >d14fdb0 8 8 0 750000 749747 749747 POS >/usr/informix/dbspaces/clientsbsp3 [snip] >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 Georges, you should not try to drop /dev/rdsk/c0t5d0s1. Try instead "... -p /usr/informix/dbspaces/clientsbsp3 ...". It wouldn't make sense to use symbolic links to generic raw device names (e.g. /dev/rdsk/c0t5d0s1) as chunk names, if INFORMIX would follow them. HTH Matthias

why would you need to give a path to the dbspace. Probably sufficient and necessary is onspaces -d <dbspacename>. Matthias Krausse wrote: > On Thu, 15 Jul 1999 20:30:32 +0200, "georges Chaleunsinh" > <gchaleunsin@imaginet.fr> wrote: > > >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 > > [snip] > > >d14fd38 8 8001 8 1 N S informix clientsbsp3 > > [snip] > > >Chunks > >address chk/dbs offset size free bpages flags pathname > > [snip] > > >d14fdb0 8 8 0 750000 749747 749747 POS > >/usr/informix/dbspaces/clientsbsp3 > > [snip] > > >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> > Georges, > you should not try to drop /dev/rdsk/c0t5d0s1. > Try instead "... -p /usr/informix/dbspaces/clientsbsp3 ...". > It wouldn't make sense to use symbolic links to generic > raw device names (e.g. /dev/rdsk/c0t5d0s1) as > chunk names, if INFORMIX would follow them. > > HTH > Matthias

That chunk is the ONLY chunk in the sdbspace so you cannot drop it as a chunk you have to drop the sdbspace itself: onspaces -d clientsbsp3 Art S. Kagel georges Chaleunsinh wrote: > > 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 > > georges.