ROLLFORWARD command

Posted in 1999

Topics: Transactions, Locking & Isolation

ml — 20 Mar 1999 14:36:09 PST — source: Informix-list mailing list archive (1991-1998)

I not an Informix expert so if anyone has any ideas I would be grateful. I am using an Informix database (SQL 4.0) on a UNIX 3.2 server with a transaction log. I have a backup database that I am trying to restore four days worth of data from a transaction log (the database was backed up on a Monday, I need to add tues-thursday's data in the transaction log) via the ROLLFORWARD command. No luck, I consistently receive "bad row id" errors ROLLFORWARD failed. I ran a bcheck on the database and had to rebuild many of the tables indexes (10% of the records had bad pointers). Tried the ROLLFORWARD command again, same error message. Is there anyway to restore the data from the transaction log to the backup database, can I somehow get around that error message? Or is the database in bad shape, I might as well just accept the fact I will need to rekey four days worth of data? Any suggestions? Thanks ML