Re: Backup Restore. 6.X -> 7.1

We just went through a similar problem. Our problem was that we didnot define the dbspace used for temp storage as a temp dbspace. the problem we ran into is that complex queries (any query using a temp table) would generate a temp table that would be logged. since these tables are created by the engine itself you cannot control the logging. the only way to prevent them from being logged is to use a temp dbspace for temp storage. Informix told use this is a "feature" of 7.11 and this is the only way around this problem. I hope this helps.... Good Luck... Russ.. > > I have problems when I restore a 6.X database backup to informix version 7.1 > The backup works fine, but when I start to do work on the database (dbaccess) > 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. I can avoid the problem by forcing the logs > to be cleared manually using onmode. > > 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. > > any info would be appriacted > > Dave McCreery > Technical Consultant > Credo Electronic Banking > . > > Russell P. Kahler |||||/// ---------- Internet: russell@oncontact.com ======== / Uh... on!contact Software . | O O | /Just reboot W67 N250A Evergreen Blvd | v_' / --> that will / Cedarburg, WI 53012 # _| |_ fix it / (414) 375-6555 (#) ( ) ---------- # //|* *| #//( * )/ # ===== # ( ) Blah, Blah, Blah. # || || .#---'| |----. #----' -----