rs_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_non_blocking_commit_flush does not execute if the value of dsi_non_blocking_commit is zero.
rs_blocking_commit_flush has function-string class scope.
rs_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_non_blocking_commit_flush maps to null.
create function string rs_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’
create function string rs_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’