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.

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, the minimum TempSize is 32 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.

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