Subject | Re: Sweep and corrupted DB |
---|---|
Author | mivi71dk |
Post date | 2002-06-25T17:52:15Z |
>the
> If the database was corrupted gbak wouldn't be able to connect to
> database. There is no (or little) trickery with gbak - it connectsto
> the server just like any other client application. How come it canActually I can connect too, but cannot do anything (except Backup -
> connect and yours can't?
Restore).
>the
>
> >
> > What is "poke Scandinavian alphabet" ?
> >
>
> A chance for us to have a laugh perhaps? What Helen meant to ask was
> whether you were trying to use characters that are not supported by
> character set specified for the database (or field). In fact,CHARSET
> NONE will accept anything.I think I use standard table construction.
The only thing I have added is NOT NULL, Foreign keys, and some index
of my own.
Thats it !
>by
> >
> >
> > Maybe not. But CAN I tell if a DB is sweeping or if it has been
> > sweeped earlier ?
> >
>
> Good question. I don't think you can tell if one is going on ( other
> than a visible performance loss). You can tell if one has happened
> regularly comparing the txn stats output from gstat. But that soundsyou
> like a lot of work.
>
> Sweeping is meant to be a non-intrusive, background operation that
> don't need to worry about. All part of the embed, deploy and relaxa
> thing. Under normal circumstances it shouldn't ever happen because
> good application design will ensure that transactions are shortrunning
> and the OIT pointer always moves along.
>
>
> Paul
>
> --
>
> Paul Reeves
> http://www.ibphoenix.com
> Supporting users of Firebird and InterBase