onstat -g lap Light appends

The onstat -g lap command provides information on the status of light appends occurring in the system. A light append is an unbuffered, unlogged insert operation.

In the latest version light appends can be replicated through Enterprise Replication.

Light Append Info
session id  address   cur_ppage   la_npused   la_ndata    la_nrows    bufcnt
12894       b60a5e8   ffbff494    2398        2397        98720       4
<p></p>
<h3 class="legacy">Output Description</h3>
<p></p>
<table id="onstat">
<tbody><tr>
<th scope="col" class="legacy">Heading</th>
<th scope="col" class="legacy">Description</th>
<th scope="col" class="legacy">Format</th>
<th scope="col" class="legacy">See Also</th>
</tr>
<tr>
<td class="legacy">Session id</td>
<td class="legacy">The session ID performing the light append operation</td>
<td class="legacy">Dec</td>
<td class="legacy"><a href="/onstat/index.php?id=gses">onstat -g ses</a></td>
</tr>
<tr>
<td class="legacy">address</td>
<td class="legacy">The address of the light append buffer</td>
<td class="legacy">Hex</td>
<td class="legacy"> </td>
</tr>
<tr>
<td class="legacy">cur_ppage</td>
<td class="legacy">Current physical page address</td>
<td class="legacy">Hex</td>
<td class="legacy"> </td>
</tr>
<tr>
<td class="legacy">la_npused</td>
<td class="legacy">The number of pages allocated</td>
<td class="legacy">Dec</td>
<td class="legacy"> </td>
</tr>
<tr>
<td class="legacy">la_ndata</td>
<td class="legacy">The number of data pages appended</td>
<td class="legacy">Dec</td>
<td class="legacy"> </td>
</tr>
<tr>
<td class="legacy">la_nrows</td>
<td class="legacy">The number of rows appended.</td>
<td class="legacy">Dec</td>
<td class="legacy"> </td>
</tr>
<tr>
<td class="legacy">bufcnt</td>
<td class="legacy">The number of light append buffers</td>
<td class="legacy">Dec</td>
<td class="legacy"> </td>
</tr>
</tbody></table>
<p></p>