Re: Altering a table and Long Transactions

From: "Gadget" <a.colapicchioni@odio.gli.spammers.acsys.it> > >Excuse me for my ugly English and thanks in advance. Got to be better than my Italian. :-) >When I try to add a column in a table containing 80.000 records, my >Informix >Universal 9.2 server tells: > >"450: Long transaction aborted" > >My database logging mode is unbuffered, the logical log configuration is : >LOGFILES 6 >LOGSIZE 1500> >I think that the only way to solve my problem is: > >create a new table containing old table structure plus my new fields >SELECT old table INTO new table >DROP old table >RENAME the newly created table. > >Unfortunately, the old table has integral constraints that I have to drop >and create in the new table. > >Right? Wrong. You can use onparams to add more logical logs. :-) _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com.