Subject RE: [ib-support] Re: Sweep and corrupted DB
Author Wilson, Fred
What error message(s) are you getting, after you connect and "try to do
something" ??


Best regards,
Fred Wilson
SE, Bell & Howell
fred.wilson@...



-----Original Message-----
From: mivi71dk [mailto:Michael.Vilhelmsen@...]
Sent: Tuesday, June 25, 2002 10:52 AM
To: ib-support@yahoogroups.com
Subject: [ib-support] Re: Sweep and corrupted DB


>
> If the database was corrupted gbak wouldn't be able to connect to
the
> database. There is no (or little) trickery with gbak - it connects
to
> the server just like any other client application. How come it can
> connect and yours can't?

Actually I can connect too, but cannot do anything (except Backup -
Restore).


>
>
> >
> > 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
the
> 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 !


>
> >
> >
> > 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
by
> regularly comparing the txn stats output from gstat. But that sounds
> like a lot of work.
>
> Sweeping is meant to be a non-intrusive, background operation that
you
> don't need to worry about. All part of the embed, deploy and relax
> thing. Under normal circumstances it shouldn't ever happen because
a
> good application design will ensure that transactions are short
running
> and the OIT pointer always moves along.
>
>
> Paul
>
> --
>
> Paul Reeves
> http://www.ibphoenix.com
> Supporting users of Firebird and InterBase



To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/