Internal Commit Control

Replication Server uses the rs_dsi_check_thread_lock function to check whether the current DSI executor thread is blocking another replicate database process.

For example:

select count(*) as seq from table(snapshot_lock('',-1))

as T1 where TABLE_NAME!= '' AND AGENT_ID in (SELECT

AGENT_ID FROM TABLE(SNAPSHOT_APPL_INFO('',-1)) as T2

WHERE APPL_ID = (VALUES APPLICATION_ID()))

In IBM DB2 UDB, select the lock information of the current session using:

select agent_id from table(snapshot_lock('',-1)) as locktable

To get the current session ID, use:

SELECT APPL.AGENT_ID FROM TABLE(SNAPSHOT_APPL_INFO('',

-1)) AS APPL WHERE APPL.APPL_ID = (VALUES APPLICATION_ID())