Re: Update big tables !

Posted in 1998

Oleg Milenkiy — Wed, 02 Sep 1998 15:11:40 -0500 — source: Informix-list mailing list archive (1991-1998)

Rok, You can move in two directions: 1. Increase logical log space. 2. Reduce size of the transaction by inserting COMMIT WORK operator(s). If update information comes as a flat file, you can split it and run more than one update process (sequentially or in parallel). Note. Locking table in exclusive mode would not reduce size of a long transaction (it helps against lock table overflows). Oleg Rok Vi'intin wrote: > > I'm using Informix 7.30 and BUFFERED database. > > I want to update very big table and Long transaction error appears. > I usually do in this way: > 1. change database mode to NON LOGGING. > 2. update a table > 3. chnage database mode to BUFFERED again. > > Is teher any shortcut to do it. > > Thanks > Rok