The database server does not generate logical-log records for every operation because it does not need a record of every action. The database server needs logical-log records only to perform the functions listed in Database Server Processes That Require Logging. Also, the space required to store a record of everything that the database server did would quickly become unwieldy.
The logical-log records themselves are variable length. This arrangement increases the number of logical-log records that can be written to a page in the logical-log buffer. However, the database server often flushes the logical-log buffer before the page is full.
Two types of logged activity are possible in the database server:
The following sections explain the two different types of activity. For more information on the format of logical-log records, see the chapter on interpreting logical-log records in the IBM Informix: Administrator's Reference.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]