Re: question on logical log

Posted in 1997

Chris Burton — Thu, 13 Mar 1997 20:00:14 GMT — source: Informix-list mailing list archive (1991-1998)

On 13 Mar 1997 07:13:08 -0500, stephane.magnan@eur.autodesk.com ("Stephane Magnan") wrote: > Hi, > > This week-end, we have to load data in a database. > > I would like to know if we will meet a problem with long transaction. > > We want use the sql statment 'load from filename ....' > > Could you tell me if this command execute sometimes 'commit' or it > commit at the end of loading. > > Stephane > At the end. You could run into long xact if you are loading a large table. You might want to increase the LTXHWM and LTXEHWM values before the load, but be careful about loading too many large tables at once. Hope this helps. Chris Burton cburton@gte.net