ttDestroy

Description

Destroys a data store including all checkpoint files, transaction logs and daemon catalog entries (though not the DSNs).

Required privilege

This utility requires the instance administrator privilege.

Syntax

ttDestroy {-h | -help | -?}
ttDestroy {-V | -version}
ttDestroy [[-wait] [-timeout secs]] [-force] {-connStr connection_string | DSN | dspath}

Options

ttDestroy has the options:

Option	Description
`-connStr` `connection_string`	An ODBC connection string containing the name of the data store, the server name and DSN (if necessary) and any relevant connection attributes.
`DSN`	Specifies an ODBC data source name of the data store to be destroyed.
`dspath`	The fully qualified name of the data store to be destroyed. This is not the DSN associated with the connection but the fully qualified data store path name associated with the data store as specified in the `DataStore=` parameter of the data store's ODBC definition. For example, for a data store consisting of files`/home/payroll/1997.ds0`, `/home/payroll/1997.ds1`, and several transaction log files `/home/payroll/1997.log`n`,dspath` is `/home/payroll/1997`.
`-h` `-help` -?	Prints a usage message and exits.
`-force`	Destroy even if files are from an incompatible version or a different instance of TimesTen.
`-timeout` `seconds`	Indicates the time in seconds that ttDestroy should wait. If no timeout value is supplied, TimesTen waits five seconds before retrying the destroy operation.
`-V \| -version`	Prints the release number of ttDestroy and exits.
`-wait`	Causes ttDestroy to continually retry the destroy operation until it is successful, in those situations where the destroy fails due to some temporary condition, such as when the data store is in use.

Example

ttDestroy /users/pat/TimesTen/Daily/F112697

Notes

Using ttDestroy is the only way to delete a data store completely and safely. Do not remove data store checkpoint or transaction log files manually.

This utility is supported only where the TimesTen Data Manager is installed.

In the case that the data store to be destroyed is part of a cache grid, ttDestroy performs a detaches the data store from the grid.

ttDestroy does not perform cleanup of Oracle objects from AUTOREFRESH or AWT cache groups. If there are AUTOREFRESH or AWT cache groups in the data store, use the ttCacheSqlGet built-in procedure, specifying NULL for the cache group name, to generate Oracle SQL to perform cleanup after the data store has been destroyed.