Please note that I attempted to backup and restore the database in hopes
that the problem would be resolved. This is what I tried:
gbak -b E:/mydata.fdb e:/mydata.fbk -user sysdba -password masterkey -v
It started off well and "wrote data for table" for 3 of the 4 tables.
When it started to
Problem finally resolved by GBAK using the -g option to disable garbage
collection. After creating my backup, I restored using GBAK and my problem
was completely resolved.
My question remains though. Is it a bad idea to modify a database as
indicated above during heavy use? Thank you.
On Tue,
I have a FB database 4 tables. I decided to add some columns, drop one
index and create two indexes while the FB database handling a 12 hour long
batch job.
Between all tables, these batch jobs consist of an average of 1 to 20
INSERTS per second and 10 to 40 UPDATES per second. There are also