RE: Table unloads without logging [762]

What database type are You using? I suppose not non-logging. In 'logging' database each SQL operation is considered to be a single transaction, unless transaction is started explicitly. In ANSI database, each SQL statement starts a transaction. I think You cab get rid of the problem if You increase Logical log considerably. ------------------------------------------ Alexey Sonkin Senior Database Administrator Grand Virtual, Inc. (1-617) 547-6323 x245 > -----Original Message----- > From: Ferry, Craig [mailto:crferry@wescodist.com] > Sent: Tuesday, January 20, 2004 4:28 PM > To: classics@iiug.org > Subject: Table unloads without logging [762] > > We unload our informix tables nightly as part of our backup procedure. > We also do nightly processing on the database. Due to the length that > both of these processes take, we have to perform them simultaneously. > Occasionally we receive errors as part of our nightly processing similar > to the following message. I am guessing this may be because the table > unloads are running. Is there a way to unload the tables (via dbaccess) > without logging? > > 01:22:49 Aborting Long Transaction: TX 0xc000000078acd800 username:> wispier aid: 137 > > TEA > > Craig sending to informix-list