can't drop chunk from sbspace
georges Chaleunsinh
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.
Matthias Krausse
<gchal...@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
Art S. Kagel
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
>
mcol...@us.dhl.com
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
mcol...@us.dhl.com