CreateEpochAtCommit

For TimesTen Scaleout, specifies if each commit generates an epoch.

Set this general connection attribute to 1 to make every commit from this connection an epoch. The default value is 0, which will make it so commits are not epochs unless the transaction included a call to the ttEpochCreate built-in procedure.

TimesTen Classic ignores this attribute.

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 CreateEpochatCommit 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

CreateEpochatCommit

0 (default) - TimesTen does not write the transaction log to disk on transaction commit.

1 - TimesTen writes log to disk on transaction commit.

Windows ODBC Data Source Administrator

Not applicable

Also see LogFlushMethod.