ttBookmark

This procedure returns information about the TimesTen transaction log.
Records in the transaction log are identified by pairs of integers:

  • A transaction log file number.

  • An offset in that transaction log file.

Transaction log file numbers correspond to the file system names given to transaction log files. For example, the transaction log file SalesData.log29 has the transaction log file number 29.

Three log records are identified in the result row of ttBookmark:

  • The identity of the most recently written log record.

  • The identity of the log record most recently forced to the disk.

  • The replication bookmark. The replication bookmark is the oldest log record that represents an update not yet replicated to another system.

Required Privilege

This procedure requires no privilege.

Related Views

This procedure has this related view.

SYS.V$BOOKMARK

Syntax

ttBookmark()

Parameters

ttBookmark has no parameters.

Result Set

ttBookmark returns the result set:

Column Type Description

writeLFN

TT_INTEGER

Last written transaction log file.

writeLFO

TT_BIGINT

Last written offset in transaction log file.

forceLFN

TT_INTEGER

Last transaction log file forced to disk.

forceLFO

TT_BIGINT

Offset of last transaction log file forced to disk.

holdLFN

TT_INTEGER

Replication bookmark transaction log file.

holdLFO

TT_BIGINT

Replication bookmark log offset.

Examples

CALL ttBookmark();
<379, 60193048,  379, 60192768, -1, -1>
1 row found.