Transaction Logging

Introduction

A database is said to have or use transaction logging, when SQL data manipulation statements in a database generate [[[logical log]] records.

The database logging status indicates whether a database uses transaction logging.

Standard Engine

A transaction log is maintained by SE, recording all changes made to the database. This log is cleared and restarted fresh after you make a backup on the database. If a crash occurs and some recent data is lost, you must restore the last backup and then apply the last transaction log

How to start a transaction log

As user informix, run on command prompt:

ontape -s -L 0 -U <database name>

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