Please Help (Urgent)

Posted in 1999

Sherwin Jaleel — Fri, 03 Sep 1999 11:42:51 +0100 — source: Informix-list mailing list archive (1991-1998)

Hi, I am trying to load data into a table in an Informix 7 database using dbload. The table contains 14 columns and one of them is a blob. The process falls over with a "Long Transaction Error". I am lots and stuck. Please help me. sherwin

↪ replying to Sherwin Jaleel

Vic Glass — Fri, 03 Sep 1999 08:44:02 -0400 — source: Informix-list mailing list archive (1991-1998)

Just a thought: turn off logging during the load, turn it back on afterwards? To turn it off: ontape -s -L 0 -N your_database To turn it in: ontape -s -L 0 -U your_database Use -B if buffered versus Unbuffered logging is desired. If you don't know which, *before* you turn logging off use onmonitor -> status -> databases to determine the logging status of the database, then return it to that logging status after the load. Vic Sherwin Jaleel wrote: > Hi, > I am trying to load data into a table in an Informix 7 database using > dbload. The table contains 14 columns and one of them is a blob. The > process falls over with a "Long Transaction Error". I am lots and stuck. > Please help me. > > sherwin

↪ replying to Sherwin Jaleel

Madison Pruet — Fri, 03 Sep 1999 08:25:56 -0500 — source: Informix-list mailing list archive (1991-1998)

Use the -n option on dbload to commit every "x" number of inserts. Sherwin Jaleel wrote: > Hi, > I am trying to load data into a table in an Informix 7 database using > dbload. The table contains 14 columns and one of them is a blob. The > process falls over with a "Long Transaction Error". I am lots and stuck. > Please help me. > > sherwin