Board index » delphi » How long should you leave gfix running before giving up?

How long should you leave gfix running before giving up?


2005-08-17 07:36:58 PM
delphi59
I am running :-
gfix -mend -full -ignore <db_name>-user <user>-password <pwd>
IB 7.5.1 / Windows 2003 server / Database size 3.8 GB
Fast Dell Dual XEON Processor Hardware
When you look at task manager gfix is 0% CPU / 0 CPU Time / 200k memory - although IBServer seems to be doing something. In the past gfix or IBConsole Validate/Repair has usually taken no more than 45 mins max.
I wish ther was a way to tell how long u'll be waiting, whether it has crashed/stuck especially when you have lots of angry users asking how long till ure back up and running again.
Any advice?
Steve
 
 

Re:How long should you leave gfix running before giving up?

Steve writes:
Quote
Any advice?
Answered in other thread.
--
Craig Stuntz [TeamB] . Vertex Systems Corp. . Columbus, OH
Delphi/InterBase Weblog : blogs.teamb.com/craigstuntz
Want to help make Delphi and InterBase better? Use QC!
qc.borland.com -- Vote for important issues
 

Re:How long should you leave gfix running before giving up?

Steve writes:
Quote
I am running :-

gfix -mend -full -ignore <db_name>-user <user>-password <pwd>

IB 7.5.1 / Windows 2003 server / Database size 3.8 GB
Fast Dell Dual XEON Processor Hardware

When you look at task manager gfix is 0% CPU / 0 CPU Time / 200k memory - although IBServer seems to be doing something. In the past gfix or IBConsole Validate/Repair has usually taken no more than 45 mins max.

I wish ther was a way to tell how long u'll be waiting, whether it has crashed/stuck especially when you have lots of angry users asking how long till ure back up and running again.

Any advice?

Steve
I think there is a performance monitoring tool in Windows 2003 Server offering more
options and greater details. Can you see any disk reads/writes?
Can you create an empty version of the db (metadata backup+restore) and
pump records from old to new database (not touching any indexes)?
--
Aage J.