Command Line Administration

Most TimesTen administration tasks are performed with command line utilities.

The following table summarizes common utilities:

Name	Description
`ttAdmin`	A general utility for managing a database in TimesTen Classic. Used to specify policies for automatically or manually loading and unloading a database from RAM, as well as to starting and stopping cache agents and replication agents.
`ttBackup` and `ttRestore`	Used to create a backup copy of a database in TimesTen Classic and restore it at a later time.
`ttBulkCp`	Used to transfer data between TimesTen tables and ASCII files.
`ttGridAdmin`	A general utility for all aspects of administering TimesTen Scaleout, such as creating a grid, adding or removing data instances or management instances, creating a database, and redistributing data to new data instances.
`ttIsql`	Used to run SQL interactively from the command line, similar to Oracle SQL*Plus. Also provides a number of administrative commands to reconfigure and monitor a database.
`ttMigrate`	Used to migrate the contents of a database between major TimesTen releases.
`ttRepAdmin`	Used to monitor replication status for replication schemes in TimesTen Classic.
`ttSize`	Used to estimate the amount of space to allocate for a table in the database.
`ttStats`	Used to monitor database metrics (statistics, states, and other information). Automatically captures system snapshots, and takes and compares snapshots of metrics.
`ttStatus`	Used to display information that describes the current state of a TimesTen database.
`ttTraceMon`	Used to enable and disable the TimesTen internal tracing facilities.
`ttXactAdmin`	Used to list ownership, status, log and lock information for each outstanding transaction, as well as latches held by each connection. The `ttXactAdmin` utility also enables users of TimesTen Classic to commit, terminate or forget an XA transaction branch.

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 Overview of TimesTen Replication in the Oracle TimesTen In-Memory Database Replication Guide.

For information about TimesTen utilities (both general-purpose and TimesTen Scaleout-specific), see Utilities in the Oracle TimesTen In-Memory Database Reference.