DELAYED_COMMITS Option

Determines when the server returns control to an application following a COMMIT.

Allowed Values

OFF

Default

OFF. This corresponds to ISO COMMIT behavior.

Description

When set to OFF (the only value allowed by Sybase IQ), the application must wait until the COMMIT is written to disk. This option must be set to OFF for ANSI/ISO COMMIT behavior.