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.

Usage in TimesTen Scaleout and TimesTen Classic

This procedure is supported in TimesTen Classic.

TimesTen Scaleout applications can call this built-in procedure.

In TimesTen Scaleout, this procedure runs locally on the element from which it is called.

Related Views

This procedure has these related views.

SYS.GV$BOOKMARK

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.