option – is the specific information about the log you need. Options are:
help – shows a message with the different options.
first_page – returns the page number of the first log page.
root_page – returns the page number of the last log page.
stp_page – returns the page number of the secondary truncation point
(STP), if it exists. The secondary truncation point (or STP) is the point in the log of the
oldest transaction yet to be processed for replication. The transaction may or may not be
active. In cases where the transaction is no longer active, the STP by definition precedes
the oldest active transaction.
checkpoint_page – returns the page number in the log that contains the
most recent checkpoint log record.
checkpoint_marker – returns the record ID (RID) in the log that
contains the most recent checkpoint log record.
checkpoint_date – returns the date of the most recent checkpoint log
record.
oldest_transaction_page – returns the page number in the log on which
the oldest active transaction at the time of the most recent checkpoint, started. If there
was no active transaction at the time of the most recent checkpoint,
oldest_transaction_page returns the same value as
checkpoint_page.
oldest_transaction_marker – returns the RID (page number and row ID)
in the log on which the oldest active transaction at the time of the most recent
checkpoint, started. If there was no active transaction at the time of the most
recent checkpoint, oldest_transaction_marker returns the same
value as checkpoint_marker.
oldest_transaction_date – is the at which the oldest active
transaction started.
until_time_date – is the latest time that could be encapsulated in the
dump that is usable by the until_time clause of load
transaction.
until_time_page – is the log page on which the log record associated
with until_time_date resides.
until_instant_marker – is the RID (page number and row ID) of the log
record associated with until_time_date.
total_pages – is the total number of log pages in the log chain, from
first_page to root_page.
stp_pages – the total number of log pages between the STP and the
oldest active transaction.
active_pages – the total number of pages between the oldest
transaction at the time of the most recent checkpoint, and the end of the log.
inactive_pages – the total number of log pages between
first_page and either stp_page or
oldest_transaction, whichever comes first. This is the number of log
pages that will be truncated by the dump transaction command.
Examples
–
The result type of loginfo is bigint, which means you must
convert the output when your query results in a RID or a date.