TempSize

Indicates the size in MB for the temporary partition of the database.

For TimesTen Classic, TempSize indicates the total amount of memory in MB allocated to the temporary region for the database.

For TimesTen Scaleout, indicates the total amount of memory in MB allocated to the temporary region for an element.

TempSize has no predefined value.

If left unspecified, the TempSize value is determined from PermSize as follows:

• If PermSize is less than 64 MB, TempSize = 32 MB + ceiling(PermSize / 4 MB).

• Otherwise, TempSize = 40 MB + ceiling(PermSize / 8 MB).

TimesTen rounds the value up to the nearest MB.

In TimesTen Classic, the minimum TempSize is 32 MB. In TimesTen Scaleout, the minimum TempSize is 64 MB.

If specified, TimesTen always honors the TempSize value. Since the temporary data partition is recreated each time a database is loaded, the TempSize attribute can be increased or decreased each time a database is loaded. For an existing database, a value of 0 or no value indicates that the existing size should not be changed.

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 TempSize 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	TempSize	n - Size of the temporary partition, in MB. Minimum size is 32 MB for TimesTen Classic. Minimum size is 64 MB for TimesTen Scaleout.
Windows ODBC Data Source Administrator	Not applicable