Re: Couldn't drop dbspace
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
FREE 491020 507375
----------------------------------------------------------------------------
----------------------
--
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
>