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.