I'm working with informix 7.31FD3W1

I try to drop a dbspace. The dbspace had the logical logs, but I moved
all the logical logs to another dbspace, but I cat'n drop this because
it's not free.
So I'm sure that it's free.

I used the onstat -d utility and I saw :

address chk/dbs offset size free bpages flags pathname
c00000001ac314d8 3 3 315000 500000 451947 PO-
/dev/informix/tecn/chunklog

I saw the extents report with oncheck -pe and I found :

DBspace Usage Report: loglogico Owner: informix Created:
04/14/2001

Chunk: 3 /dev/informix/tecn/chunklog Size Used
Free
500000 48053
451947

Disk usage for Chunk 3 Start
Length
------------------------------------------- ---------
---------
OTHER RESERVED Pages 0
2
CHUNK FREE LIST PAGE 2
1
TBLSPACE TBLSPACE 3
50
FREE 53
432000
FREE 480053
19947

There are two free bloks, but, Where is the used block ?
I lost 48000 pages, What the meaning ?

You have a temporary table squeezed inbetween the two free spaces that
needs to be dropped before dropping the dbspace. Perhaps someone on
this newsgroup has a good script to find the name of the temp table?
Anyone?

Otherwise you'll need to have Informix support dial-in and drop the
temporary table. Hope this information helps.

Brice Avila
Minneapolis, Minnesota

janto@luzdelsur.com.pe wrote in message news:<6e361c68.0307011226.3ef84e37@posting.google. com>...
> I'm working with informix 7.31FD3W1
>
> I try to drop a dbspace. The dbspace had the logical logs, but I moved
> all the logical logs to another dbspace, but I cat'n drop this because
> it's not free.
> So I'm sure that it's free.
>
> I used the onstat -d utility and I saw :
>
> address chk/dbs offset size free bpages flags pathname
> c00000001ac314d8 3 3 315000 500000 451947 PO-
> /dev/informix/tecn/chunklog
>
> I saw the extents report with oncheck -pe and I found :
>
> DBspace Usage Report: loglogico Owner: informix Created:
> 04/14/2001
>
> Chunk: 3 /dev/informix/tecn/chunklog Size Used
> Free
> 500000 48053
> 451947
>
> Disk usage for Chunk 3 Start
> Length
> ------------------------------------------- ---------
> ---------
> OTHER RESERVED Pages 0
> 2
> CHUNK FREE LIST PAGE 2
> 1
> TBLSPACE TBLSPACE 3
> 50
> FREE 53
> 432000
> FREE 480053
> 19947
>
> There are two free bloks, but, Where is the used block ?
> I lost 48000 pages, What the meaning ?