SYSIQRVLOG System View

Presents group information from ISYSIQRVLOG in a readable format. Each row in the SYSIQRVLOG view corresponds to a log for a RLV-enabled table .  The row with table_id 0 represents the server-wide commit log.

Column Name Column Type Description
stream_id unsigned int The log stream identifier.
table_id unsigned int Indicates the table the log stream belongs to. NULL indicates a commit log stream.
partition_low unsigned int Corresponds to the partition map in use when that log was last active.
partition_high int Corresponds to the partition map in use when that log was last active.
identity_location unsigned bigint Location of the log stream identity block.