Durability

For TimesTen Scaleout, the setting of this attribute determines the durability of "prepare-to-commit" and commit records.

If K-safety is set to 2 or greater, the default value is 0.

If K-safety is set to 1, the default value is 1.

Durability=0 is not supported with K-safety set to 1.

For details about setting up K-safety, see Creating a Grid in the Oracle TimesTen In-Memory Database Scaleout User's Guide.

Required Privilege

No privilege is required to change the value of this attribute.

Usage in TimesTen Scaleout and TimesTen Classic

This attribute is not supported in TimesTen Classic.

This attribute is supported in TimesTen Scaleout.

Setting

Set Durability as follows:

Where to set the attribute	How the attribute is represented	Setting
C or Java programs or UNIX and Linux systems database definition (.dbdef) file in TimesTen Scaleout	Durability	0 - TimesTen does not write the transaction prepare-to-commit and commit records to disk on transaction commit. 1 - TimesTen writes the prepare-to-commit record durably and the commit record non-durably.
Windows ODBC Data Source Administrator	N/A

Also see CreateEpochAtCommit.