SYS.TRANSACTION_LOG_API

The TRANSACTION_LOG_API table keeps track of the persistent Transaction Log API bookmarks. Each row in the system table corresponds to a persistent bookmark. Each persistent bookmark has a text identifier associated with it that is used to keep track of the bookmark.

Columns

Column name	Type	Description
ID	TT_CHAR(31) NOT NULL	A text tag identifier used to keep track of the bookmark
READLSNHIGH	TT_BIGINT NOT NULL	The high value of the read log record to which this bookmark points
READLSNLOW	TT_BIGINT NOT NULL	The low value of the read log record to which this bookmark points
PURGELSNHIGH	TT_BIGINT NOT NULL	The high value of the lowest LSN required by this bookmark
PURGELSNLOW	TT_BIGINT NOT NULL	The low value of the lowest LSN required by this bookmark
PID	TT_BIGINT NOT NULL	The process ID of the process to last open the XLA bookmark
INUSE	BINARY(1) NOT NULL	Bookmark being used by any persistent Transaction Log API connection
REPLICATED	BINARY(1)	For a replicated bookmark Internal use only
COUNTER	TT_BIGINT	For a replicated bookmark Internal use only
COUNTER_A	TT_BIGINT	For a replicated bookmark Internal use only
COUNTER_B	TT_BIGINT	For a replicated bookmark Internal use only
CTN_HIGH_A	TT_BIGINT	For a replicated bookmark Internal use only
CTN_LOW_A	TT_BIGINT	For a replicated bookmark Internal use only
CTN_HIGH_B	TT_BIGINT	For a replicated bookmark Internal use only
CTN_LOW_B	TT_BIGINT	For a replicated bookmark Internal use only