Timesten - DSN

Timesten Component

Timesten - DSN

About

When you connect from an application, you use a Data Source Name (DSN) to uniquely identify the particular TimesTen database to which you want to connect.

A DSN is a character-string name that identifies a TimesTen database and a collection of connection attributes that are to be used when connecting to the database.

If a user tries to use a DSN that has connection attributes for which they do not have privileges, such as first connection attributes, they receive an error.

Even though the DSN uniquely identifies a TimesTen database, a database can be referenced by multiple DSNs. The difference between each of these unique DSNs is in the specification of the connection attributes to the database. This provides convenient names to different connection configurations for a single database.

Type

Client

The Client DSN defines the server machine and the Server DSN.

The Client DSN is configured in either the user or system ODBC.INI file.

Example of Client DSN on ORACLE_INSTANCE/instance1/bifoundation/OracleBIApplication/coreapplication/setup/odbc.ini

[ODBC Data Sources]
TT_AGGR_STORE = TimesTen 11.2.2 Driver
.....

[TT_AGGR_STORE]
Driver=/u01/app/oracle/product/TimesTen/tt1122/lib/libttclient.so
TTC_SERVER = Exalytics-01.hotitem.local
TTC_SERVER_DSN = TT_AGGR_STORE
TTC_TIMEOUT = 0

where:

  • Driver is the ODBC client driver.
  • TTC_SERVER is the server machine (either the logical server name) on which the database resides
  • TTC_SERVER_DSN is the Server DSN

Server

The Server DSN is defined on the server machine where the database resides.

It is configured with the TimesTen database name and its connection attributes.

Server DSNs identify uniquely TimesTen databases that are accessed by:

The Server DSN specifies:

It has the same configuration format and attributes as a TimesTen Data Manager DSN. Some connection attributes are only allowed within the Server DSN specification. These attributes enable you to specify multiple client/server connections to a single server.

Server DSN attributes are defined in the ODBC.INI file or the ODBC Data Source Administrator.

A Server DSN:

  • must be defined as a system DSN.
  • can be added or configured while the TimesTen Server is running.

Example of server DSN in the daemon_dir/sys.odbc.ini

[ODBC Data Sources]
DI_TT_AGGR_STORE=TimesTen 11.2.2 Driver

[DI_TT_AGGR_STORE]
Driver=/u01/app/oracle/product/TimesTen/tt1122/lib/libtten.so
DataStore=/u01/app/oracle/product/aggregate_store/tt_aggr_store/di_tt_aggr_store
LogDir=/u01/app/oracle/product/aggregate_store/logs
DatabaseCharacterSet=AL32UTF8
ConnectionCharacterSet=AL32UTF8
LogFileSize=1024 
LogBufMB=1024 
LogBufParallelism=16 
Preallocate=0 
PermSize=25000 
TempSize=25000 
MemoryLock=4 
CkptFrequency=30 
CkptLogVolume=0 
CkptRate=20 
PrivateCommands=1 
RecoveryThreads=40

where:

Data Manager

See Timesten - ODBC Driver

Documentation / Reference





Discover More
Timesten Component
Timesten - (Memory|Database) (Size|Space|Partition)

TimesTen manages database space using two separate memory partitions within a single contiguous memory space. One partition contains: permanent data and the other contains temporary data. checkpointtSizeobserve...
Timesten Component
Timesten - (SQL Developer|ODBC Client) Configuration

How to configure SQL Developer to connect to a Timesten Database. Download and install the last version of SQL Developer downloadSQL Developer To access a TimesTen database from SQL Developer,...
Timesten Client And Timesten Server
Timesten - Client/Server Connection

The client application refers to the Client DSN when initiating a connection to locate and connect to the TimesTen database. The Client DSN defines: the server machine and the Server DSN. The...
Timesten Component
Timesten - Connection Attribute

The connection attributes are of two types: first : to specify how the TimesTen database is loaded and configured, general: to specify how the connections are to be controlled or managed. instance...
Sql Developer Connection String
Timesten - Connection String

A Connection string is a way to define connection attributes that are not define in the DSN. According to the ODBC standard, when an attribute occurs multiple times in a connection string, the first value...
Timesten Component
Timesten - Database Installation and configuration on Linux

On UNIX/Linux systems before installing application, you must in general configure the following: The number of semaphores Allowable shared memory In addition for timesten, you need to perform the...
Timesten Component
Timesten - How to set up the Timesten Cache ?

Steps to set up the Timesten Cache to cache data of an Oracle Database. Before you cache Oracle data in a TimesTen database, you must perform certain tasks: either outside SQL Developer using command-line...
Timesten Component
Timesten - TNSNAMES.ORA

Sample tnsnames.ora found in the directory TimesTen_Base/network/admin/samples with TNS entry: for the cache of an oracle database for a direct and client connection for the DSN defined in the sys.odbc.ini...
Timesten Component
Timesten - Transaction Log

Changes to databases are captured in transaction logs that are written to disk periodically. Log records are generated with the execution of INSERT, UPDATE and DELETE operations. Normal disk file systems...



Share this page:
Follow us:
Task Runner