rs_get_thread_seq

Returns the sequence number for the specified entry in the rs_threads system table, using the noholdlock option.

Syntax

rs_get_thread_seq_noholdlock @rs_id

Parameters

rs_id – a number of int datatype. It represents the ID of the entry to be checked and matches the value of the id column in the rs_threads system table.

Examples

Example 1 – Creates an rs_get_thread_seq_noholdlock function string that executes a select statement on the rs_threads table.

create function string
   rs_get_thread_seq_noholdlock
 for sqlserver_derived_class
 output language
 'select seq from rs_threads noholdlock
   where id = ?rs_id!param?'

Usage

rs_get_thread_seq_noholdlock is equivalent to rs_get_thread_seq, except that it is used when dsi_isolation_level is 3. It is executed only when more than one DSI thread is defined for a connection. The row select is done with the noholdlock option. The function returns a single row with a single column, seq, which contains the current sequence number for the specified ID.
The rs_get_thread_seq_noholdlock function has function-string class scope.
Replication Server creates an initial rs_get_thread_seq_noholdlock function string for the system-provided function-string classes during installation.
If you use a user-created base function-string class and you use the parallel DSI feature with transaction isolation level 3, create a function string for rs_get_thread_seq_noholdlock.
Create or customize an rs_get_thread_seq_noholdlock function string at the Replication Server that is the primary site for the class.