Subject | RE: [ib-support] Re: Sweep and corrupted DB |
---|---|
Author | Wilson, Fred |
Post date | 2002-06-25T17:53:56Z |
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
Restore).
The only thing I have added is NOT NULL, Foreign keys, and some index
of my own.
Thats it !
ib-support-unsubscribe@egroups.com
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
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
>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.To unsubscribe from this group, send an email to:
>
>
> Paul
>
> --
>
> Paul Reeves
> http://www.ibphoenix.com
> Supporting users of Firebird and InterBase
ib-support-unsubscribe@egroups.com
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/