External Commit Control

Replication Server can create rs_threads with row-level lock when the replicate database is IBM DB2 UDB.

By default, the row-level lock is “on”. For example:

create table rs_threads (id int,seq int)

create unique index thread_index on rs_threads(id) cluster

When the isolation level is 3, you must use this function string:

select seq from rs_threads where id = ? with cs

where:

cs is cursor stability, which is the default isolation level in IBM DB2 UDB.