Home | Previous Page | Next Page   Tuning Database Server Performance > Tuning I/O for Tables and Indexes >

Light Appends

Light appends add table rows quickly. When the database server loads data in Express mode to unindexed RAW tables, as described in the IBM Informix: Administrator's Guide, it uses light append. Light appends might also occur if you insert rows into an OPERATIONAL table or a nonlogging temporary table.

Light appends have the following characteristics:

To determine if light appends occur, execute onstat -g lap. The output displays the session ID of any session performing a light append as well as the number of pages allocated, the number of data pages appended, the number of rows already appended, and the number of pages left in current extent. It also displays the logging mode of the light-append operation.

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]