rs_set_non_blocking_commit_flush

rs_set_non_blocking_commit_flush executes at intervals equal to any number of minutes from 1 to 60 that you specify with dsi_non_blocking_commit. rs_set_non_blocking_commit_flush does not execute if the value of dsi_non_blocking_commit is zero.

rs_set_non_blocking_commit_flush has function-string class scope.

rs_set_non_blocking_commit_flush maps to the corresponding function string in Adaptive Server 15.0 and later, and Oracle 10g v2 and later. For all other non-Sybase databases, rs_set_non_blocking_commit_flush maps to null.

Example

Example 1 Create an instance of an rs_set_non_blocking_commit_flush function string for Adaptive Server:

create function string rs_set_non_blocking_commit_flush
           for sqlserver_derived_class
           output language
           ‘set delayed_commit off; begin tran; update rs_lastcommit set
           origin_time = getdate() where origin = 0; commit tran; 
           set delayed_commit on’

Example 2 Create an instance of an rs_set_non_blocking_commit_flush function string for Oracle:

create function string rs_set_non_blocking_commit_flush
           for oracle_derived_class
           output language
           ‘alter session set commit_write = immediate; begin tran; 
           update rs_lastcommit set origin_time = getdate() where
           origin = 0; commit tran; alter session set commit_write = nowait’