Re: Backup Restore. 6.X -> 7.1

In article <4d0iln$jh2@news.Ieunet.ie>, dave@columbo (Dave McCreery) wrote: > I have problems when I restore a 6.X database backup to informix version 7.1 Can't say as I'm terribly surprised. I understood this to be an unsupported scenario. > The backup works fine, but when I start to do work on the database (dbaccess) There's no reason for the backup to be affected in any way. It would be no surprise for the restore to appear to work also. > I start to get long transactions causing rollbacks of my work. > This happens (obviously) beacuse the logical log are being filled and not > cleared out when they are full. It's not obvious to me! Long transactions cause full logs, full logs do *not* cause long transactions. > I can avoid the problem by forcing the logs > to be cleared manually using onmode. This is a new one on me! My onmode does not document a switch for clearing full logs (thank goodness!). I have to back them up. > > I know that informix 7.1 manages the logs slightly differently but why does > this cause the problem. Is this a bug (oversight) or can it be avoided. No > one in Informix tech support knows or wants to tell me. Maybe you've just confused 'em! :-) graeme -- Disclaimer: The author's opinions are his own, and not necessarily those of Pyramid Technology Ltd or Pyramid Technology Inc --------------------------------------------------------------------- -m------- Graeme Sargent Voice: +44(0)1252 373035 ---mmm----- Senior Database Consultant Fax : +44(0)1252 373135 -----mmmmm--- Pyramid Technology Ltd. Telex: Tell who??? -------mmmmmmm- Farnborough, Hants GU14 7PL Email: graeme@pyra.co.uk --------------------------------------------------------------------- We have the technology. The tricky bit is learning how to use it.