Re: Unable to cleanly drop database
David Williams wrote:
>
> In article <34FD6265.2C4E@bellsouth.net>, John Carlson
> <carlson1@bellsouth.net> writes
> >Informix DS 7.23.UC4
> >HPUX 10.01
> >
> >
> >Very unusual . . .
> >
> >I have six dbspaces (size 1024000 pgs/2G within a 2G rawspace) that
> >contain tables within a single database. When I drop the database, I
> >run an onstat -d and expect to see "free" space as (1024000 pgs - 53 <?>
> >pgs overhead). Instead, I see that the free space is a negative number
> >for 5 out of 6 dbspaces. Informix tech support hasn't been able to pin
> >a bug on this one. Any ideas, out there?
> >
>
> Are they blobspaces?
>
No, just 'regular' dbspaces.
> Try bouncing online and running
>
> oncheck -cr
> oncheck -ce>
Didn't think to bounce the engine. I arranged a dial-up from Informix
and they were able to assist me. I'll remember the bounce and the
onchecks the next time . . .
John Carlson
Informix DBA
WH Smith, Inc.