4 TimesTen Scaleout Utilities
This chapter provides reference information for utilities that are only supported with TimesTen Scaleout, beginning with the following introductory sections:
For information about utilities that are only supported in TimesTen Classic or supported in both TimesTen Classic and TimesTen Scaleout, see Utilities.
Overview
The options for TimesTen utilities are generally not case sensitive, except for single character options. You can use -timeout
or -TimeOut
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 this chapter.
Utilities listed in Other Utilities Descriptions are described in Utilities.
Utilities Supported Only in TimesTen Scaleout Descriptions
Name | Description |
---|---|
Administers a TimesTen Scaleout grid. |
|
Creates a new grid and database. |
Other Utilities Descriptions
Name | Description | Usage in TimesTen Scaleout |
---|---|---|
Specifies or changes database policies. |
No |
|
Moves databases from a TimesTen installation to a new TimesTen installation of the same major release, but a different minor release. |
No |
|
Creates a backup copy of a database that can be restored at a later time using the |
No |
|
Copies data between TimesTen tables and ASCII files. |
No |
|
Captures information about the state of TimesTen. |
No |
|
Performs internal consistency checking within a TimesTen database. |
No |
|
Manages certificates and wallets. |
Yes |
|
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 | |
Manages TimesTen active standby pairs that take advantage of the high availability framework of Oracle Clusterware. |
No |
|
Starts and stops the TimesTen main daemon and Server. |
No |
|
Controls and displays daemon log messages. |
No |
|
Destroys a database including all checkpoint files, transaction logs and daemon catalog entries. |
No |
|
Starts or configures the TimesTen Prometheus exporter. |
Yes |
|
Examines all files in an installation of TimesTen and generates a signature for the installation, |
Yes |
|
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 |
|
Create a new TimesTen instance. |
Yes |
|
Destroys an existing TimesTen instance. |
Yes |
|
Modifies certain attributes of an instance. |
Yes |
|
Executes SQL statements interactively. |
Yes |
|
Saves and restores TimesTen objects. |
Yes, only for migrating from TimesTen Classic to TimesTen Scaleout. |
|
Displays, sets, modifies and monitors existing replication definitions and status. |
No |
|
Creates a database from a backup that has been created using the |
No |
|
Prints out the schema, or selected objects, of a database. |
Yes |
|
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 |
|
Monitors database metrics or takes and compares snapshots of metrics. |
Yes |
|
Displays information that describes the current state of TimesTen. |
Yes, only to retrieve information about the local instance. |
|
Fetches TimesTen internal trace information from a database and displays it to |
No |
|
Enables and disables the TimesTen internal tracing facilities. |
No |
|
Helps to securely store user IDs and passwords in an Oracle Wallet and to obtain a hashed password for the |
Yes |
|
Lists the TimesTen release information. |
Yes |
|
Lists ownership, status, log and lock information for each outstanding transaction. |
No |
|
Displays a formatted dump of the contents of a TimesTen transaction log. |
Yes, but limited to diagnosing issues only on single elements. |