Utilities

5 Utilities

The reference information for most TimesTen utilities is included in this chapter, beginning with the following introductory sections:

For information about utilities that are only supported in TimesTen Scaleout see TimesTen Scaleout Utilities.

Overview

The options for TimesTen utilities are generally not case sensitive, except for single character options. You can use -connstr or -connStr interchangeably. However -v and -V are each unique options.

All utilities return 0 for success and nonzero if an error occurs.

Note:

The utility name and options listed in this chapter are case-insensitive. They appear in mixed case to make the examples and syntax descriptions easier to read.

Utilities List

Utilities listed in Utilities Supported Only in TimesTen Scaleout Descriptions are described in TimesTen Scaleout Utilities.

Utilities listed in Other Utilities Descriptions are described in this chapter.

Utilities Supported Only in TimesTen Scaleout Descriptions

Name	Description
`ttGridAdmin`	Administers a TimesTen Scaleout grid.
`ttGridRollout`	Creates a new grid and database.

Other Utilities Descriptions

Name	Description	Usage in TimesTen Scaleout
`ttAdmin`	Specifies or changes database policies.	No
`ttAdoptStores`	Moves databases from a TimesTen installation to a new TimesTen installation of the same major release, but a different minor release.	No
`ttBackup`	Creates a backup copy of a database that can be restored at a later time using the `ttRestore` utility.	No
`ttBulkCp`	Copies data between TimesTen tables and ASCII files.	No
`ttCapture`	Captures information about the state of TimesTen.	No
`ttCheck`	Performs internal consistency checking within a TimesTen database.	No
`ttCreateCerts`	Manages certificates and wallets.	Yes
`ttCacheInfo`	Returns change-log table information for Oracle Database tables and information about Oracle Database objects used to track DDL statements issued on cached Oracle Database tables.	Yes
`ttCWAdmin`	Manages TimesTen active standby pairs that take advantage of the high availability framework of Oracle Clusterware.	No
`ttDaemonAdmin`	Starts and stops the TimesTen main daemon and Server.	No
`ttDaemonLog`	Controls and displays daemon log messages.	No
`ttDestroy`	Destroys a database including all checkpoint files, transaction logs and daemon catalog entries.	No
`ttExporter`	Starts or configures the TimesTen Prometheus exporter.	Yes
`ttInstallationCheck`	Examines all files in an installation of TimesTen and generates a signature for the installation,	Yes
`ttInstallDSN`	Generates a Windows client DSN for one or more entries listed in the provided input file and installs them into the ODBC Panel as a System DSN.	Yes
`ttInstanceCreate`	Create a new TimesTen instance.	Yes
`ttInstanceDestroy`	Destroys an existing TimesTen instance.	Yes
`ttInstanceModify`	Modifies certain attributes of an instance.	Yes
`ttIsql`	Executes SQL statements interactively.	Yes
`ttMigrate`	Saves and restores TimesTen objects.	Yes, only for migrating from TimesTen Classic to TimesTen Scaleout.
`ttRepAdmin`	Displays, sets, modifies and monitors existing replication definitions and status.	No
`ttRestore`	Creates a database from a backup that has been created using the `ttBackup` utility.	No
`ttSchema`	Prints out the schema, or selected objects, of a database.	Yes
`ttSize`	Estimates the amount of space that a given table, including any views in the database will consume when the table grows to include a specified number of rows.	Yes
`ttStats`	Monitors database metrics or takes and compares snapshots of metrics.	Yes
`ttStatus`	Displays information that describes the current state of TimesTen.	Yes, only to retrieve information about the local instance.
`ttTail`	Fetches TimesTen internal trace information from a database and displays it to `stdout`.	No
`ttTraceMon`	Enables and disables the TimesTen internal tracing facilities.	No
`ttUser`	Helps to securely store user IDs and passwords in an Oracle Wallet and to obtain a hashed password for the `PWDCrypt` connection attribute.	Yes
`ttVersion`	Lists the TimesTen release information.	Yes
`ttXactAdmin`	Lists ownership, status, log and lock information for each outstanding transaction.	No
`ttXactLog`	Displays a formatted dump of the contents of a TimesTen transaction log.	Yes, but limited to diagnosing issues only on single elements.