Preallocate

The Preallocate attribute determines whether TimesTen preallocates disk space for the database checkpoint files when the database is created. Setting this attribute ensures that there is sufficient space for the database when the database is saved to the file system.

TimesTen respects the setting for the Preallocate attribute for all operations that create a new checkpoint file, such as database creation, ttRepAdmin -duplicate, and ttRestore.

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 Preallocate 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	Preallocate	0 - Does not preallocate disk space for checkpoint files when creating the database. 1 (Default) - Preallocates disk space for the checkpoint files.
Windows ODBC Data Source Administrator	Not applicable

Note:

Reallocating disk space for a large database is very time consuming.