CkptReadThreads

The CkptReadThreads connection attribute determines the number of threads used to read the checkpoint file when loading the database into memory, such as in first connection or recovery operations.

When the CkptReadThreads attribute is set to 1, TimesTen reads checkpoint files serially. When the CkptReadThreads attribute is set to a value greater than 1, TimesTen uses the specified number of threads to read checkpoint files concurrently (in parallel). When the CkptReadThreads attribute is set to 0 or unspecified, the previously specified value is used.

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 CkptReadThreads 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	`CkptReadThreads`	`n` - The number of threads to use when reading the checkpoint files during the loading of the database into memory. Takes an integer value of `0` or greater (maximum = `2`³¹`-1`). Default is `1`.
Windows ODBC Data Source Administrator	Not applicable

Note:

For a progress report on a recovery process, see the rebuild messages in the daemon log file. Set the number of threads low enough to leave sufficient resources on the TimesTen server for other services/processes.