Product Documentation

Database Administrator's Guide

Previous Topic

Next Topic

No Transaction Processing

No Transaction Processing (or "non-transaction files") is the simplest transaction level. This mode is appropriate for temporary files and for non-critical data.

The server does not guarantee that unwritten updated data and index cache pages are backed by a persistent copy on disk, so non-transaction files are not recoverable in the event of an abnormal server termination. In such a situation a non-transaction file is in an unknown state because an unknown number of updates may have not yet been written to disk at the time of the abnormal server termination.

This mode does not provide recoverability. It is best suited for temporary data that does not need to be committed to permanent storage. If it is used for critical data, data integrity must be protected by other means.


No Transaction Processing

In This Section

When to Use Non-Transaction Files

Previous Topic

Next Topic

When to Use Non-Transaction Files

Use non-transaction files when the files are of a temporary nature and can be re-created or the data in the files can be restored from another source in the event of an abnormal server termination.

To minimize loss of unwritten cached non-transaction file updates in the event of an abnormal server termination, consider using WRITETHRU for non-transaction files or periodically calling the FairCom DB API function CtreeFlushFile() to flush non-transaction data and index cache pages to disk.

TOCIndex