Timesten - Connection Attribute

Timesten Component

About

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.

Only the instance administrator can change a first connection attribute to a value other than the one currently in effect.

All of these connection attributes can be set in:

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.

Some connection attributes, can be configured in the TimesTen daemon options file (ttendaemon.options). If you have set the same connection attributes in both the DSN and the daemon options file, the value of the connection attributes in the DSN takes precedence.

How to

View and set connection attributes

Via ttIsql

You can view and set connection attributes with the ttIsql show and set commands.

To view a connection attribute (for instance for passtrough)

Command> show passthrough;
PassThrough = 0

To change the connection attribute setting, enter:

Command> set passthrough 1;

Via Odbc (Sql Developer,…)

To view a connection attribute (for instance for passtrough), you use the ttConfiguration built-in procedure

CALL ttConfiguration(); -- for all
call ttConfiguration('passthrough'); -- for one
PARAMNAME    PARAMVALUE                           
-----------  ----------                             
PassThrough  0           

Support

Ignoring value requested for first connection attribute

Some attributes need a restart of the server.

Warning  6226: Ignoring value requested for first connection attribute 'PermSize' 
-- value currently in use: 25000, requested value: 50000

Documentation / Reference





Discover More
Timesten Cache Group Attribute
TimesTen - Cache Group

A cache group is a collection of one or more cached Oracle tables: related to each other by foreign key constraints. arranged in a logical hierarchy by using primary key and foreign key relationships....
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. ...
Timesten   Cache Grid Relation With Oracle And Tt Database
Timesten - Cache Grid

A TimesTen cache grid provides a means to horizontally scale out cache groups across multiple systems with: read and write data consistency across the TimesTen databases and predictable latency for...
Timesten Component
Timesten - Checkpoint

TimesTen databases are automatically persisted to disk storage using periodic checkpoints to keep snapshots of the database. Checkpoint files contain an image of the database on disk. TimesTen uses...
Timesten Component
Timesten - Commit

TimesTen supports two kinds of commit: Type Default Connection att DurableCommits Avantage Disavantage Delayed durability Yes 0 High performance Small possibility of data loss Immediate durability...
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 - DSN

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...
Timesten Component
Timesten - Database

A TimesTen database is a collection of elements such as: tables, views, and sequences that can be accessed and manipulated through SQL. Each TimesTen database is created when the first connection...
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...



Share this page:
Follow us:
Task Runner