Working with a specific Logreader partition

solidDB Help : Programming : Transaction Logreader : Partitioning and selecting log records : Working with a specific Logreader partition

You can choose a Logreader partition to be the only partition from which to read log records.

The selection of the Logreader partition applies to only the current session and is valid for all reads from SYS_LOG that are started after the setting. The partition data is stored in the SYS_FEDT_DB_PARTITION system table.

You can complete the following tasks:

▪ Set the Logreader partition by using the SET REPLICATION PARTITION statement, see SET REPLICATION PARTITION.

▪ List the existing partitions in the SYS_FEDT_DB_PARTITION system table by using a SELECT statement. For example:

SELECT * FROM sys_fedt_db_partition

Go up to

Partitioning and selecting log records