ttBookmark
-
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.
Syntax
ttBookmark()
Parameters
ttBookmark
has no parameters.
Result Set
ttBookmark
returns the result set:
Column | Type | Description |
---|---|---|
|
|
Last written transaction log file. |
|
|
Last written offset in transaction log file. |
|
|
Last transaction log file forced to disk. |
|
|
Offset of last transaction log file forced to disk. |
|
|
Replication bookmark transaction log file. |
|
|
Replication bookmark log offset. |
Examples
CALL ttBookmark(); <379, 60193048, 379, 60192768, -1, -1> 1 row found.