Data Store Attributes

Data Source Name

The data source name (DSN) uniquely identifies the attributes to a connection. It serves two purposes:

As a unique identifier to the ODBC driver manager (if one is present), allowing it to associate a Data Store Name with a specific ODBC driver.
As one of potentially many name aliases to a single physical database where the name alias has unique attributes associated with it.

The database attributes can apply to either the data source name (connection to a database) or the Data Store Path Name (database).

On Windows, the data source name and all configuration information associated with the data source (including the database path name) are stored in the system registry. The ODBC driver manager and TimesTen use this information.

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 Data Source Name 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	`DSN`	A name that describes the DSN.
Windows ODBC Data Source Administrator	Not applicable

DataStore

The database path name uniquely identifies the physical database. It is the fully qualified directory path name of the database and the file name prefix, for example: /disk1/databases/database1. This name is not a file name. The actual database file names have suffixes, such as .ds0 and .log0, for example /disk1/databases/database1.ds0 and /disk1/databases/database1.log0.

Note:

You are required to specify the database path and name at database creation time. It cannot be altered after the database has been created.

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 DataStore 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	`DataStore`	Full path to the physical database that the data source name references.
Windows ODBC Data Source Administrator	Not applicable

DatabaseCharacterSet

The database character set determines the character set in which data is stored.

Note:

You are required to specify the database character set at database creation time only. It cannot be altered after the database has been created. If you do not specify a value for this attribute when creating a database, TimesTen returns error message 12701.

Generally, your database character set should be chosen based on the data requirements. For example: Do you have data in Unicode or is your data in Japanese on UNIX and Linux systems (EUC) or Windows (SJIS)?

You should choose a connection character set that matches your terminal settings or data source. See ConnectionCharacterSet.

When the database and connection character sets differ, TimesTen performs the data conversion internally based on the connection character set. If the connection and database character sets are the same, TimesTen does not need to convert or interpret the data set. Best performance occurs when connection and database character sets match, since no conversion is required.

To use this attribute you must specify a supported character set. For a list of supported character set names, see Supported Character Sets below.

There are several things to consider when choosing a character set for your database. For a discussion about these considerations, see Choosing a Database Character Set in Oracle TimesTen In-Memory Database Operations Guide.

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 DatabaseCharacterSet name 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	`DatabaseCharacterSet`	Specify the preferred character set.
Windows ODBC Data Source Administrator	Not applicable

Supported Character Sets

The following tables describe the character sets supported in TimesTen.

Asian Character Sets

Name	Description
`JA16EUC`	`EUC` 24-bit Japanese
`JA16EUCTILDE`	The same as `JA16EUC` except for the way that the wave dash and the tilde are mapped to and from Unicode
`JA16SJIS`	`Shift-JIS` 16-bit Japanese
`JA16SJISTILDE`	The same as `JA16SJIS` except for the way that the wave dash and the tilde are mapped to and from Unicode
`KO16KSC5601`	`KSC5601` 16-bit Korean
`KO16MSWIN949`	Microsoft Windows Code Page 949 Korean
`TH8TISASCII`	Thai Industrial Standard 620-2533 - ASCII 8-bit
`VN8MSWIN1258`	Microsoft Windows Code Page 1258 8-bit Vietnamese
`ZHS16CGB231280`	`CGB2312-80` 16-bit Simplified Chinese
`ZHS16GBK`	`GBK` 16-bit Simplified Chinese
`ZHS32GB18030`	`GB18030-2000`
`ZHT16BIG5`	`BIG5` 16-bit Traditional Chinese
`ZHT16HKSCS`	Microsoft Windows Code Page 950 with Hong Kong Supplementary Character Set `HKSCS-2001`. Character set conversion to and from Unicode is based on Unicode 3.0.
`ZHT16MSWIN950`	Microsoft Windows Code Page 950 Traditional Chinese

European Character Sets

Name	Description
`BLT8CP921`	Latvian Standard `LVS8-92(`1) Windows/UNIX/Linux 8-bit Baltic
`BLT8ISO8859P13`	ISO 8859-13 Baltic
`BLT8MSWIN1257`	Microsoft Windows Code Page 1257 8-bit Baltic
`BLT8PC775`	IBM-PC Code Page 775 8-bit Baltic
`CEL8ISO8859P14`	ISO 8859-13 Celtic
`CL8ISO8859P5`	ISO 8859-5 Latin/Cyrillic
`CL8KOI8R`	RELCOM Internet Standard 8-bit Latin/Cyrillic
`CL8KOI8U`	KOI8 Ukrainian Cyrillic
`CL8MSWIN1251`	Microsoft Windows Code Page 1251 8-bit Latin/Cyrillic
`EE8ISO8859P2`	ISO 8859-2 East European
`EL8ISO8859P7`	ISO 8859-7 Latin/Greek
`ET8MSWIN923`	Microsoft Windows Code Page 923 8-bit Estonian
`EE8MSWIN1250`	Microsoft Windows Code Page 1250 8-bit East European
`EL8MSWIN1253`	Microsoft Windows Code Page 1253 8-bit Latin/Greek
`EL8PC737`	IBM-PC Code Page 737 8-bit Greek/Latin
`EE8PC852`	IBM-PC Code Page 852 8-bit East European
`LT8MSWIN921`	Microsoft Windows Code Page 921 8-bit Lithuanian
`NE8ISO8859P10`	ISO 8859-10 North European
`NEE8ISO8859P4`	ISO 8859-4 North and North-East European
`RU8PC866`	IBM-PC Code Page 866 8-bit Latin/Cyrillic
`SE8ISO8859P3`	ISO 8859-3 South European
`US7ASCII`	ASCII 7-bit American
`US8PC437`	IBM-PC Code Page 437 8-bit American
`WE8ISO8859P1`	ISO 8859-1 West European
`WE8ISO8859P15`	ISO 8859-15 West European
`WE8MSWIN1252`	Microsoft Windows Code Page 1252 8-bit West European
`WE8PC850`	IBM-PC Code Page 850 8-bit West European
`WE8PC858`	IBM-PC Code Page 858 8-bit West European

Middle Eastern Character Sets

Name	Description
`AR8ADOS720`	Arabic MS-DOS 720 Server 8-bit Latin/Arabic
`AR8ASMO8X`	ASMO Extended 708 8-bit Latin/Arabic
`AR8ISO8859P6`	ISO 8859-6 Latin/Arabic
`AR8MSWIN1256`	Microsoft Windows Code Page 1256 8-Bit Latin/Arabic
`AZ8ISO8859P9E`	ISO 8859-9 Latin Azerbaijani
`IW8ISO8859P8`	ISO 8859-8 Latin/Hebrew
`IW8MSWIN1255`	Microsoft Windows Code Page 1255 8-bit Latin/Hebrew
`TR8MSWIN1254`	Microsoft Windows Code Page 1254 8-bit Turkish
`TR8PC857`	IBM-PC Code Page 857 8-bit Turkish
`WE8ISO8859P9`	ISO 8859-9 West European & Turkish

Universal Character Sets

Name Description

Name	Description
`AL16UTF16`	Unicode 4.0 UTF-16 Universal character set. This is the implicit TimesTen national character set. This character set cannot be specified as a value to the DatabaseCharacterSet or ConnectionCharacterSet attributes.
`AL32UTF8`	Unicode 4.0 UTF-8 Universal character set
`UTF8`	Unicode 3.0 UTF-8 Universal character set, CESU-8 compliant

AL16UTF16

Unicode 4.0 UTF-16 Universal character set. This is the implicit TimesTen national character set.

This character set cannot be specified as a value to the DatabaseCharacterSet or ConnectionCharacterSet attributes.

AL32UTF8

Unicode 4.0 UTF-8 Universal character set

UTF8

Unicode 3.0 UTF-8 Universal character set, CESU-8 compliant

Description

Optionally, set this attribute to help you identify the Data Source Name (DSN) and its attributes.

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 Description 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	`Description`	Text description of the Data Source Name. This attribute is optional.
Windows ODBC Data Source Administrator	Not applicable

Driver

The Driver attribute specifies the name of the TimesTen ODBC Driver.

For example, on Windows systems the value can be TimesTen Client 22.1.

On UNIX and Linux systems, the value of the Driver attribute is the path name of the TimesTen ODBC Driver shared library file, timesten_home/install/lib/libtten.so.

For more information, see Creating a DSN on Linux and UNIX for TimesTen Classic in Oracle TimesTen In-Memory Database Operations Guide.

For general usage scenarios, refer to standard ODBC reference documentation, such as:

https://docs.microsoft.com/en-us/sql/odbc/reference/syntax/odbc-api-reference

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 Driver 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	`Driver`	Specifies the path name for the TimesTen ODBC Driver shared library file, if using a Driver Manager.
Windows ODBC Data Source Administrator	Select a driver from the Create New Data Source dialog.	Specifies the client driver for TimesTen and the release.

Durability

For TimesTen Scaleout, the setting of this attribute determines the durability of "prepare-to-commit" and commit records.

If K-safety is set to 2 or greater, the default value is 0.

If K-safety is set to 1, the default value is 1.

Durability=0 is not supported with K-safety set to 1.

For details about setting up K-safety, see Creating a Grid in the Oracle TimesTen In-Memory Database Scaleout User's Guide.

Required Privilege

No privilege is required to change the value of this attribute.

Usage in TimesTen Scaleout and TimesTen Classic

This attribute is not supported in TimesTen Classic.

This attribute is supported in TimesTen Scaleout.

Setting

Set Durability as follows:

Where to set the attribute How the attribute is represented Setting

Where to set the attribute	How the attribute is represented	Setting
C or Java programs or UNIX and Linux systems database definition (`.dbdef`) file in TimesTen Scaleout	`Durability`	`0` - TimesTen does not write the transaction prepare-to-commit and commit records to disk on transaction commit. `1` - TimesTen writes the prepare-to-commit record durably and the commit record non-durably.
Windows ODBC Data Source Administrator	N/A

C or Java programs or UNIX and Linux systems database definition (.dbdef) file in TimesTen Scaleout

Durability

0 - TimesTen does not write the transaction prepare-to-commit and commit records to disk on transaction commit.

1 - TimesTen writes the prepare-to-commit record durably and the commit record non-durably.

Windows ODBC Data Source Administrator

N/A

Also see CreateEpochAtCommit.

GridLogRecoveryThreshold

The GridLogRecoveryThreshold attribute determines the number of log files that are prevented from purging before declaring another replica set element is declared unrecoverable.

Default value is 0, which means TimesTen saves all the log files. When the value is set to some thing non-zero, log files will keep getting accumulated until the threshold value is reached. Once the threshold is reached, the replica set element for which the log files are being saved is declared as unrecoverable.

Required Privilege

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

Usage in TimesTen Scaleout and TimesTen Classic

This attribute is supported only in TimesTen Scaleout.

Setting

Set GridLogRecoveryThreshold 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	`GridLogRecoveryThreshold`	A positive integer that specifies the number of log files to preserve before declaring a replica set element is unrecoverable. The default is 0, meaning all files are saved.
Windows ODBC Data Source Administrator	Not applicable

LogDir

The LogDir attribute specifies the fully qualified directory path name where database logs reside. Specifying this attribute enables you to place the transaction log files on a different I/O path from the database checkpoint files. Placing the transaction log files and checkpoint files on different disks can improve system performance.

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 LogDir 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	`LogDir`	Specifies the directory where transaction log files reside.
Windows ODBC Data Source Administrator	Not applicable

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

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

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.

ReplicationApplyOrdering

ReplicationApplyOrdering enables parallel replication.

When used with the ReplicationParallelism attribute, multiple transmitters on the master send to multiple receivers on the subscriber.

Automatic parallel replication: Parallel replication over multiple threads that automatically enforces transactional dependencies and all changes applied in commit order. This is the default.
Automatic parallel replication with disabled commit dependencies: Parallel replication over multiple threads that automatically enforces transactional dependencies, but does not enforce transactions committed in the same order on the subscriber database as on the active database. You can also increase replication throughput by applying transactions to specific tracks.

For more details on configuring parallel replication, see Configuring Parallel Replication in Oracle TimesTen In-Memory Database Replication Guide.

This attribute also sets parallel propagation for AWT cache groups. By default, this attribute enables parallel propagation of updates to the Oracle database. To learn more about parallel AWT caching, see Configuring Parallel Propagation to Oracle Database Tables in Oracle TimesTen In-Memory Database Cache Guide.

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 TimesTen Classic but not supported in TimesTen Scaleout.

Setting

Set ReplicationApplyOrdering as follows:

Where to set the attribute How the attribute is represented Setting

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	`ReplicationApplyOrdering`	`0` - Specifies automatic parallel replication. Automatic parallel replication is available for both classic and active standby pair replication schemes. (default) `2` - Specifies automatic parallel replication with disabled commit dependencies.
Windows ODBC Data Source Administrator	Not applicable

C or Java programs or UNIX and Linux systems odbc.ini file in TimesTen Classic

ReplicationApplyOrdering

0 - Specifies automatic parallel replication. Automatic parallel replication is available for both classic and active standby pair replication schemes. (default)

2 - Specifies automatic parallel replication with disabled commit dependencies.

Windows ODBC Data Source Administrator

Not applicable

Restrictions

Restrictions when using automatic parallel replication with disabled commit dependencies:

The replication scheme must be an active standby pair that uses asynchronous replication. Classic replication schemes are not supported.
The replication scheme cannot contain cache groups.
This is only supported for TimesTen Release 11.2.2.8 and greater for both the active and standby masters. Both the active and standby masters must have commit dependencies disabled.
XLA is not supported.

All data stores in the replication scheme must use the same setting.

ReplicationParallelism

This attribute specifies the number of tracks, or the number of transmitter/receiver pairs, used for automatic parallel replication.

Set ReplicationParallelism to a number from 2 to 32. The number cannot exceed half the value of LogBufParallelism. This number indicates the number of transmitter threads on the source database and the number of receiver threads on the target database. However, if you are using single-threaded replication, set ReplicationParallelism to 1, the default.

To learn more about automatic parallel replication, see Configuring Parallel Replication in the Oracle TimesTen In-Memory Database Replication Guide.

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 TimesTen Classic but not supported in TimesTen Scaleout.

Setting

Set ReplicationParallelism 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	`ReplicationParallelism`	`n` - A value between 1 and 32, indicating the number of tracks to replicate in parallel. The default is 1.
Windows ODBC Data Source Administrator	Not applicable

Restrictions

Restrictions and things to consider when specifying parallel replication include:

When parallel replication is enabled, the Description column of the ttLogHolds built-in procedure displays one row per track per subscriber node.
We recommend setting the value of this attribute to a value no greater than half the value of the LogBufParallelism attribute. If you specify more replication tracks than log buffer threads, some replication tracks can remain empty.