Adaptive Server 15.0 and later includes the delayed commit feature designed to improve performance by delaying the commit phase of a transaction. The commit phase includes writing log records of the transaction to disk and then notifying the client application of the transaction status. With delayed commit, Adaptive Server notifies the client application of a successful commit before writing the corresponding transaction log to disk. This delay in writing to disk reduces contention on the last and active log page and thus improving performance.
However, the last page of a transaction log can be lost, if Adaptive Server terminates or if you shut down Adaptive Server using shutdown with no wait.
See “Using delayed_commit to determine when log records are committed,” in Chapter 11, “Developing a Backup and Recovery Plan” in the Adaptive Server Enterprise 15.0 System Administration Guide: Volume 2 and the delayed_commit parameter of the set command in “set,” in Chapter 1, “Commands” in the Adaptive Server Enterprise 15.0 Reference Manual: Commands.
