9 TimesTen and TimesTen Cache Administration

This chapter includes the following topics:

Installing TimesTen and TimesTen Cache

TimesTen and TimesTen Cache software is easy to install. On UNIX systems, TimesTen is installed by a simple set-up script. On Windows, TimesTen is installed by running InstallShield®.

Access Control

TimesTen and TimesTen Cache are installed with Access Control to allow only users with specific privileges to access particular TimesTen features.

TimesTen Access Control uses standard SQL statements to establish TimesTen user accounts with specific privilege levels. TimesTen offers object-level access control as well as database-level access control.

Command line administration

Most TimesTen and TimesTen Cache administration tasks are performed with command line utilities. The following table summarizes common utilities:

Name Description
ttAdmin A general utility for managing TimesTen databases and TimesTen Caches. Used to specify policies for automatically or manually loading and unloading databases from RAM, as well as to starting and stopping TimesTen cache agents and replication agents.
ttBackup and ttRestore Used to create a backup copy of a database and restore it at a later time.
ttBulkCp Used to transfer data between TimesTen tables and ASCII files.
ttIsql Used to run SQL interactively from the command line. Also provides a number of administrative commands to reconfigure and monitor databases.
ttMigrate Used to save tables and cache group definitions to a binary data file. Also used to restore tables and cache group definitions from the binary file.
ttRepAdmin Used to monitor replication status.
ttSize Used to estimate the amount of space to allocate for a table in the database.
ttStatus Used to display information that describes the current state of TimesTen or TimesTen Cache.
ttTraceMon Used to enable and disable the TimesTen and TimesTen Cache internal tracing facilities.
ttXactAdmin Used to list ownership, status, log and lock information for each outstanding transaction. The ttXactAdmin utility also allows users to commit, abort or forget an XA transaction branch.

SQL administration

TimesTen provides SQL statements for administrative activities such as creating and managing tables, replication schemes, cache groups, materialized views, and indexes.

The metadata for each TimesTen database is stored in a group of system tables. Applications can use SQL SELECT queries on these tables to monitor the current state of a database.

Administrators can use the ttIsql utility for SQL interaction with a database. For example, there are several built-in ttIsql commands that display information on database structures.

SQL Developer

Oracle SQL Developer is a graphical tool for database development tasks. Use SQL Developer to:

  • Browse, create, and edit database objects and PL/SQL programsAutomate cache group operations

  • Manipulate and export data

  • Execute SQL and PL/SQL statements and scripts

  • View and create reports

SQL Developer is a Java application that supports direct-linked and client/server connections to the TimesTen databases. Support for connecting to multiple databases enables SQL Developer users to work with data in the TimesTen and the Oracle databases concurrently.

ODBC Administrator

The ODBC Administrator is a utility program used on Windows to create, configure and delete data source definitions. You can use it to define a data source and set connection attributes.

Upgrading TimesTen and the TimesTen Cache

TimesTen and the TimesTen Cache provide the facilities to perform three types of upgrades:

In-place upgrades

In-place upgrades are typically used to move to a new patch release of TimesTen or TimesTen Cache.

In-place upgrades can be done without destroying the existing databases. However, all applications must first disconnect from the databases, and the databases must be unloaded from shared memory. After uninstalling the old release of TimesTen or TimesTen Cache and installing the new release, applications can reconnect to the databases and resume operation.

Offline upgrades

Offline upgrades are performed by using the ttMigrate utility to export the database into an external file and to restore the database with the desired changes.

Use offline upgrades to perform the following tasks:

  • Move to a new major TimesTen or TimesTen Cache release

  • Move to a different directory or machine

  • Reduce database size

During an offline upgrade, the database is not available to applications. Offline upgrades usually require enough disk space for an extra copy of the upgraded database.

Online upgrades

TimesTen replication enables online upgrades, which can be performed online by the ttMigrate and ttRepAdmin utilities while the database and its applications remain operational and available to users. Online upgrades are useful for applications where continuous availability of the database is critical.

Use online upgrades to perform the following tasks:

  • Move to a new major release of TimesTen or TimesTen Cache and retain continuous availability to the database

  • Increase or reduce the database size

  • Move the database to a new location or machine

Updates made to the database during the upgrade are transmitted to the upgraded database at the end of the upgrade process. Because an online upgrade requires that the database be replicated to another database, it can require more memory and disk space than offline upgrades.

For more information

For more information about installing and upgrading TimesTen, see Oracle TimesTen In-Memory Database Installation Guide.

For more information about Access Control, see Oracle TimesTen In-Memory Database Operations Guide.

For more information about SQL Developer, see Oracle SQL Developer Oracle TimesTen In-Memory Database Support User's Guide.

For more information about general administration of TimesTen, see "Managing TimesTen Databases" and "Working with Data in a TimesTen Database" in the Oracle TimesTen In-Memory Database Operations Guide. These chapters include the use of the ODBC Administrator.

For more information about administering TimesTen replication, see the Oracle TimesTen In-Memory Database Replication Guide.

For a complete list of SQL statements, see the Oracle TimesTen In-Memory Database SQL Reference.

For a complete list of TimesTen command-line utilities, see the Oracle TimesTen In-Memory Database Reference.