LogFileSize

The LogFileSize attribute specifies the maximum size of transaction log files in megabytes.

The minimum value is 8 MB. The default value is 64 MB. If you specify a size smaller than 8 MB, TimesTen returns an error message. Before TimesTen release 11.2.1.4, the minimum size was 1 MB. If you created your database in a previous release of TimesTen and specified a log file size of less than 8 MB, you must increase the value assigned to this attribute to avoid an error.

Actual transaction log file sizes can be slightly smaller or larger than LogFileSize because log records cannot span transaction log files.

If you specify a value of zero, TimesTen uses the default transaction log file size if the database does not exist. If the database exists, TimesTen uses the current specified transaction log file size.

Set the value of LogFileSize to be larger than or equal to the value of LogBufMB (LogFileSize >= LogBufMB).

Required Privilege

Only the instance administrator can change the value of this attribute.

Usage in TimesTen Scaleout and TimesTen Classic

This attribute is supported in both TimesTen Classic and TimesTen Scaleout.

Setting

Set LogFileSize as follows:

Where to set the attribute	How the attribute is represented	Setting
C or Java programs or UNIX and Linux systems odbc.ini file in TimesTen Classic or in the database definition (.dbdef) file in TimesTen Scaleout	LogFileSize	n - Size of transaction log file in megabytes. Default is the value of LogBufMB when the database is created and 0 (current size in effect) on subsequent connections. The minimum size is 8 MB. The maximum value is 65,536 MB (64 GB).
Windows ODBC Data Source Administrator	Not applicable