Function Strings for Commit Control Using rs_threads

Replication Server manipulates the rs_threads system table with several system functions.

These functions have function-string-class scope. They are executed only when more than one DSI thread is defined for a connection.

Note: These function strings are needed only when the external, rs_threads method is used for commit control.
System Functions that Modify the rs_threads System Table

Function

Description

rs_initialize_threads

Sets the sequence of each entry in the rs_threads system table to 0. This function is executed during the initialization of a connection.

rs_update_threads

Updates the sequence number for the specified entry in the rs_threads system table.

rs_get_thread_seq

Returns the current sequence number for the specified entry in the rs_threads system table.

rs_get_thread_seq_noholdlock

Returns the current sequence number for the specified entry in the rs_threads system table, using the noholdlock option. This thread is used when dsi_isolation_level is 3.