Informix Logging


Informix stores the log records in a logical log. Informix uses logical-log records when it performs various functions that recover data and ensure data consistency, as follows:

  • Fast recovery
  • Transactions roll back
  • Data restoration
  • Deferred checking
  • Cascading deletes
  • Distributed transactions
  • High-availability data replication (HDR)

What kind of Activity is Logged

Two types of logged activity:

  • Activity that is always logged.
  • Activity that is logged only for databases that use transaction logging

Useful Topics

update statistics Informix

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-Share Alike 2.5 License.