Table dump without logging

[craig322]

We do nightly table dumps of our database as part of our database backup procedure. We do this through dbaccess. Is there a way to go into dbaccess and tell the database not to log the transactions performed?

We are having problems occasionally with long transactions and I think it may be related to these transactions running at the same time as the database unload.

I am new to informix, so this may be a dumb question.

TIA

 

[olded]

Craig:

Once a database has transactions turned on, since version 5.X of the engine, there's no way of turning transactions off for only a single table.


You can create temp tables "with NO LOG" which forces no activity to be written to the logs for that particular temp table.

Regards,

Ed

 

[vpshriyan]

Craig,

Table data dumping does not necessitate transaction. That is, you are not doing any data manipulation (DML) as such. Long transaction (LTX) are side effects of transactions, inefficient config parameter settings, poor data set manipulation logic etc. I have written a FAQ on how to avoid long transaction in the FAQ area of this forum. Please have a look at:

Avoiding Long Transactions (LTX) faq179-2537

The root cause for LTX need to be identified and addressed at your database server front.

Regards,
Shriyan