Timesten - Database

Timesten Component


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 initiates. The database instance is freed only when all existing connections have been disconnected.

The configuration for the TimesTen database is contained within the first connection attributes.


You cannot change the permanent or temporary attribute on a database after it is created.

When a database is created, it has either the permanent or temporary attribute set


Permanent databases are stored to disk automatically through a procedure called checkpointing.


Temporary databases are not stored to disk. A temporary database is automatically destroyed when no applications are connected to it; that is, when the last connection disconnects or when there is a system or application failure. TimesTen removes all disk-based files when the last application disconnects.

A temporary database cannot be backed up or replicated. Temporary databases are never fully checkpointed to disk, although Checkpoint operations can have significant overhead for permanent databases, depending on database size and activity, but have very little impact for temporary databases. Checkpoints are still necessary to remove transaction log files.

However, temporary databases do have a transaction log, which is periodically written to disk, so transactions can be rolled back. The amount of data written to the transaction log for temporary databases is less than that written for permanent databases, allowing better performance for temporary databases. Recovery is never performed for temporary databases.

You can increase your performance with temporary databases. If you do not need to save the database to disk, you can save checkpoint overhead by creating a temporary database.

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. ...
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 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...
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 - How to (load|unload) the database in memory ?

The load of the database in memory is dependent of the ram policy. You can still manage it with the ttAdmin utility with the -ramLoad and -ramUnload option. It will place the database in memory,...
Timesten Component
Timesten - Recover

If a database needs to be recovered, TimesTen merges the database checkpoint on disk with the completed transactions that are still in the transaction log files. Recovery is never performed for temporary...
Timesten Client And Timesten Server
Timesten - Server

The TimesTen Server is a child process of the TimesTen daemon (then on a server machine) that operates continually in the background. It takes network requests from TimesTen Clients (in a client server...
Timesten Component
Timesten - Sub-daemons

TimesTen assigns a separate subdaemons to each database to perform operations including the following tasks: Manage databases. Loading the database into memory from a checkpoint file on disk Recovering...
Ttbulkcp Sql Developer
Timesten - ttBulkCp

ttBulkCp is an utility to import and export data from a Timesten database Attribute lines are used for setting file attributes, which control the formatting of the datafile. Attribute lines...

Share this page:
Follow us:
Task Runner