Description of the R-Tree-Specific Logical-Log Records

As described in the preceding section, the R-tree secondary access method creates its own logical-log records for only two types of R-tree operations: insertion of an item into a leaf page and deletion of an item from a leaf page. For all other logged R-tree operations, the R-tree secondary access method allows the extensible log manager to create the logical-log record. This section describes the format of the two logical-log records created by the R-tree secondary access method.

The first six columns of the R-tree-specific logical-log records are the standard columns displayed for all logical-log records. You can identify these log records as R-tree log records because the third column always has a value of RTREE. The R-tree-specific information is contained in the seventh column of the log record. An eighth column is also displayed, although its value is always 0.

For detailed information about the standard first six columns of logical-log records, refer to the IBM Informix: Administrator's Guide for your database server.

Logical-Log Records of Insertions of Items into a Leaf Page

The format of the seventh column of the logical-log record of an insertion into an R-tree leaf page is as follows:

LEAFINST [page number, base table rowid, base table fragid, delete flag]

The following example shows an actual log record of this type displayed with the onlog utility:

c104     192  RTREE    8        0  c040     LEAFINST [9,257,1048960,0]   0

Logical-Log Records of Deletions of Items from a Leaf Page

The format of the seventh column of the logical-log record of a deletion from an R-tree leaf page is as follows:

LEAFDEL [page number, base table rowid, base table fragid, delete flag]

The following example shows an actual log record of this type displayed with the onlog utility:

288 192  RTREE    8        0  1c4      LEAFDEL  [39,258,1048960,0]   0