ttBookmark

Description

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.

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_INTEGER	Last written offset in transaction log file
`forceLFN`	TT_INTEGER	Last transaction log file forced to disk
`forceLFO`	TT_INTEGER	Offset of last transaction log file forced to disk
`holdLFN`	TT_INTEGER	Replication bookmark transaction log file
`holdLFO`	TT_INTEGER	Replication bookmark log offset

Example

CALL ttBookmark ();