Re: Couldn't drop dbspace
Ivan Lyakhovenko wrote:
>
> 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
Here is the problem add up the start and length (158601+290858=449459)
which does not equal the start of the next free block. An old 7.10 bug
has lost a chunk of disk of length (491020-449459=41561) and 41561 plus
the 103 pages actually used == 41664. Tech support can patch this up
for you. Alternative is complex, build another instance with an empty
chunk3 the same size, bring this engine down, copy the chunk3 from the
dummy instance to this chunk3, bring the engine back up and drop the
dbspace. This is dangerous also so just call support.
> FREE 491020 507375
Art S. Kagel