Re: Couldn't drop dbspace
In article <6npu2n$eu7@news.itfs.nsk.su>, Ivan Lyakhovenko
<van@xtech.ru> writes
>Hi Uwe!
>
>I've made 'oncheck -pe' and these are results. Looks very strange, isn't it?
>Any thoughts?
>
>----------------------------------------------------------------------------
>----------------------
>DBspace Usage Report: testdbs Owner: informix Created:
>06/19/97
>
>Chunk: 3 /dev/ixChunk2 Size Used Free
> 998395 41664 956731
>
>^^^^^^^ Why???
> Disk usage for Chunk 3 Start Length
> ------------------------------------------- --------- --------
-
> OTHER RESERVED Pages 0 2
> CHUNK FREE LIST PAGE 2 1
> TBLSPACE TBLSPACE 3 50
> FREE 53 158498
> TBLSPACE TBLSPACE 158551 50
> FREE 158601 290858
158601+290858 = 449459
> FREE 491020 507375
491020??? Wrong. Also two free blocks like this you be coalesed
into one. I would shutdown and restart online and check again.
If this is still a problem talk to Informix.
>-----------------------------------------------------------------------
-----
>----------------------
>
>--
>Ivan Lyakhovenko, project manager, xTech Ltd.
>Novosibirsk, Russia.
>mailto:van@xTech.ru
>http://www.xTech.ru
>Uwe Feuerstein wrote in message <35A06F1C.3674@ixos-leipzig.de>...
>
>>Hi Ivan,
>>
>>verify in the output of "oncheck -pe" the chunk entries of the mentioned
>>dbspace. If the dbspace is really empty only reserved, chunk free list
>>and TBLSPACE TBLSPACE pages should reside in the dbspace.
>>If this is true the only way you have is to reorganize your complete db
>>(dbxport, oninit -i, dbimport) or contact the Ifmx hotline (for
>>patching).
>>
>>Hope this helps
>>Uwe
>>--
>>Xerox your life - If you'll loose it, it's nice to have a copy
>>
>
>
>
--
David Williams
Maintainer of the Informix FAQ
Primary site (Beta Version) http://www.smooth1.demon.co.uk
Official site http://www.iiug.org/techinfo/faq/faq_top.html
I see you standin', Standin' on your own, It's such a lonely place for you, For
you to be If you need a shoulder, Or if you need a friend, I'll be here
standing, Until the bitter end...
So don't chastise me Or think I, I mean you harm...
All I ever wanted Was for you To know that I care