1 Data Store Attributes

The ODBC standard defines four data store attributes:

DSN
Driver
UID
PWD

For a description of the ODBC definition of these attributes, see the appropriate ODBC manual for your platform:

Microsoft ODBC 3.0 Programmer's Reference and SDK Guide
Microsoft ODBC 2.0 Programmer's Reference and SDK Guide

This chapter describes all the attributes defined by TimesTen. To view the names and values of attributes specified in the connection string, an application can use the ttConfiguration built-in procedure.

Note:

According to the ODBC standard, when an attribute occurs multiple times in a connection string, the first value specified is used, not the last value.

On UNIX, False means the attribute value is set to 0 and True means the attribute value is set to 1.

On Windows, False means the check box is unchecked and True means the check box is checked.

"List of Attributes"

Required privileges for attributes

Only the instance administrator can change a first connection attribute to a value other than the one currently in effect. (No privileges are required to change AutoCreate and ForceConnect.)

List of Attributes

This section includes the tables:

Table 1-1, "Data store attributes"
Table 1-2, "First connection attributes"
Table 1-3, "General connection attributes"
Table 1-4, "NLS general connection attributes"
Table 1-5, "PL/SQL first connection attributes"
Table 1-6, "PL/SQL general connection attributes"
Table 1-7, "IMDB Cache connection attributes"
Table 1-8, "Client connection attributes"
Table 1-9, "Server connection attributes"

Table 1-1 Data store attributes

Name	Description	Default
Data Source Name	A name that identifies the specific attributes of a connection to the data store.	None
DataStore	Identifies the physical data store.	None
DatabaseCharacterSet	Identifies the character set used by the data store. This attribute is required at data store creation time.	None
Description	A statement that identifies the use of the data source name.	None
LogDir	The directory where transaction log files are stored.	Data store directory
Preallocate	Specifies that disk space for the data store should be preallocated when creating the data store.	0 (false)
Temporary	Specifies that the data store is not saved to disk.	0 (false)
TypeMode	The type mode for the data store.	0 - Oracle Type Mode

Table 1-2 First connection attributes

Name	Description	Default
AutoCreate	Specifies that the first connection creates the data store if it does not exist already.	1 (true)
CkptFrequency	Controls the frequency in seconds that TimesTen performs a background checkpoint.	600
CkptLogVolume	Controls the amount of data in megabytes that collects in the log between background checkpoints.	0 (off)
CkptRate	Controls the maximum rate at which data should be written to disk during a checkpoint operation.	0 (unlimited rate)
Connections	Indicates the expected upper bound on the number of concurrent connections to the data store.	64
ForceConnect	Specifies whether a connection is allowed to a failed data store if it is not properly restored from the corresponding subscriber data store.	0 (Connection disallowed)
LogAutoTruncate	Determines whether the first connection to a data store should proceed if TimesTen recovery encounters a defective log record	1 (Continues after log is truncated)
LogBufMB	The size of the internal log buffer in MB.	64
LogBufParallelism	The number of log buffer strands.	2
LogFileSize	The transaction log file size in MB.	64
LogFlushMethod	Controls the method used by TimesTen to write and sync log data to transaction log files	1 (Write data to transaction log files using buffered writes. Use explicit sync operations as needed to sync log data to disk)
Logging	Specifies what type of logging should be performed for the data store. Only logging to disk is supported.	1 (Logging to disk)
LogPurge	Specifies that unneeded transaction log files are deleted during a checkpoint operation.	1 (true)
MemoryLock	Allows applications that connect to a shared data store to specify whether the real memory should be locked during data store loading	0 (Do not acquire a memory lock)
Overwrite	Specifies that the existing data store should be overwritten with a new one when a connection is attempted.	0 (false)
PermSize	The size in MB for the permanent partition of the data store.	32
ReceiverThreads	Controls the number of threads used to apply changes on the active master data store to the standby master data store in an active standby pair replication scheme.	1
RecoveryThreads	The number of threads used to rebuild indexes during recovery.	1
TempSize	The size in MB for the temporary partition of the data store.	The default size is determined from the PermSize value.

Table 1-3 General connection attributes

Name	Description	Default
ConnectionName	Specifies whether there is a symbolic name for the data source.	The process name
DDLCommitBehavior	Controls transactional commit behavior in relation to DDL	0 (Oracle behavior)
Diagnostics	Specifies whether diagnostic messages are generated.	1 (Messages are generated.)
DuplicateBindMode	Determines whether applications use TimesTen or Oracle parameter binding for duplicate occurrences of a parameter in a SQL statement.	0 (Oracle-style binding)
DurableCommits	Specifies that commit operations should write log records to disk.	0 (Records not written to disk)
Isolation	Specifies whether the isolation level is read committed or serializable.	1 (Read committed)
LockLevel	Specifies whether the connection should use row-level locking (value = 0) or data store-level locking (value = 1).	Row-level locking
LockWait	Allows an application to configure the lock wait interval for the connection.	10 seconds
MatchLogOpts	Specifies that values used for the Logging and LogPurge attributes should match those of current connections.	0 (false)
PermWarnThreshold	The threshold at which TimesTen returns a warning and throws an SNMP trap when the permanent partition of the data store is low in memory.	90%
PrivateCommands	Determines if commands are shared between connections.	0 (on)
PWD See "UID and PWD".	Specify the password that corresponds with the specified UID. When caching Oracle data, PWD specifies the TimesTen password. You can specify the Oracle PWD in the connection string, if necessary.	None
PWDCrypt	The value of the encrypted user password.	None
QueryThreshold	Determines whether TimesTen returns an error message and throws an SNMP trap if a query times out before executing.	0 - No error is returned
TempWarnThreshold	The threshold at which TimesTen returns a warning and throws an SNMP trap when the temporary partition of the data store is low in memory.	90%
UID See "UID and PWD".	Specify a user name that is defined on the server machine. When caching Oracle data, the UID must match the UID on the Oracle database that is being cached in TimesTen.	None
WaitForConnect	Specifies that the connection attempt should wait if an immediate connection is not possible.	1

Table 1-4 NLS general connection attributes

Name	Description	Default
ConnectionCharacterSet	The character encoding for the connection, which may be different from the database character set.	US7ASCII unless the database character set is TIMESTEN8, then TIMESTEN8.
NLS_LENGTH_SEMANTICS	The default length semantics configuration.	BYTE
NLS_NCHAR_CONV_EXCP	Determines whether an error is reported when there is data loss during an implicit or explicit character type conversion between NCHAR/NVARCHAR data and CHAR/VARCHAR data.	0 (false)
NLS_SORT	The collating sequence to use for linguistic comparisons.	BINARY

Table 1-5 PL/SQL first connection attributes

Name	Description	Default
PLSQL	Determines whether PL/SQL is enabled.	1 (PL/SQL is enabled)
PLSQL_MEMORY_ADDRESS		Platform specific
PLSQL_MEMORY_SIZE		32 MB

Table 1-6 PL/SQL general connection attributes

Name	Description	Default
PLSCOPE_SETTINGS	Controls whether the PL/SQL compiler generates cross-reference information.	IDENTIFIERS: NONE
PLSQL_CCFLAGS	Controls conditional compilation of PL/SQL units.	NULL
PLSQL_CONN_MEM_LIMIT	specifies the maximum amount of process heap memory in MB that PL/SQL can use for this connection.	100
PLSQL_OPTIMIZE_LEVEL	The optimization level that is used to compile PL/SQL library units.	2
PLSQL_TIMEOUT	The number of seconds a PL/SQL procedure can run before being automatically terminated.	30 seconds

Table 1-7 IMDB Cache connection attributes

Name	Description	Default
CacheGridEnable	Enables cache grid.	On
CacheGridMsgWait	Sets the maximum message wait time.	60 seconds
DynamicLoadEnable	Enables or disables transparent load of Oracle data to dynamic cache groups.	0 (Transparent load is enabled)
DynamicLoadErrorMode	Determines if an error message is returned upon a transparent load failure.	0 (Errors are not returned)
OracleNetServiceName	The Oracle Service Name of the Oracle instance from which data is to be loaded into a TimesTen data store. This attribute is only used by the cache agent. Set the OracleNetServiceName attribute to the Oracle Service Name.	None
OraclePWD	Identifies the password for the Oracle database that is being cached in TimesTen.	None
PassThrough	Specifies which SQL statements are executed locally in TimesTen and which SQL statements are passed through to Oracle for execution.	0
RACCallback	Specifies whether to enable or disable the installation of f Application Failover (TAF) and Fast Application Notification (FAN) callbacks.	1 (Install the callbacks.)

Table 1-8 Client connection attributes

Name	Description	Default
TCP_Port	The port number on which the server is listening.	None
TCP_Port2	The port number on which the server should listen in the case of an automatic failover.	None
TTC_FailoverPortRange	A range for the failover port numbers	None
TTC_Server	Name of the machine where the TimesTen Server is running or a logical server name.	None
TTC_Server2	In the case of an automatic failover, the name of the machine where the TimesTen Server should be running or a logical server name.	None
TTC_Server_DSN	Server DSN corresponding to the TimesTen data store.	None
TTC_Server_DSN2	Server DSN corresponding to the TimesTen data store, in the case of an automatic failover.	None
TTC_Timeout	Optional. Timeout period, in seconds, for completion of a TimesTen client/server operation. The maximum timeout period is 99999 seconds.	60 seconds

Table 1-9 Server connection attributes

Name	Description	Default
MaxConnsPerServer	The maximum number of concurrent connections a child server process can handle.	1
ServersPerDSN	The desired number of server processes for the DSN.	1
ServerStackSize	The size in KB of the thread stack for each connection. For 32-bit systems: For 64-bit systems:	128 KB 256KB

Name

Description

Default

MaxConnsPerServer

The maximum number of concurrent connections a child server process can handle.

ServersPerDSN

The desired number of server processes for the DSN.

ServerStackSize

The size in KB of the thread stack for each connection.

For 32-bit systems:

For 64-bit systems:

128 KB

256KB