ttAdmin

This utility specifies or changes database policies. It enables you to:

• Get information about ttAdmin options, version, and settings. See Help, Version, and Query Options.

• Specify settings for database RAM policy, database start, and database stop. See Perform RAM Operations.

• Open or close a database to user connections. See Open or Close a Database.

• Run a forced disconnect operation for existing database connections. See Force Disconnect.

• Start and stop TimesTen cache agents for caching data from Oracle Database tables. The cache agent is a process that handles Oracle Database access on behalf of a TimesTen database. It also handles the aging and autorefresh of the cache groups in the TimesTen database. See Set Cache Policies.

• Specify settings to automatically or manually start and stop replication agents for specified databases. See Set Replication Policies.

Required Privilege

This utility requires no privileges to query the database.

Open and close options require the instance administrator privilege.

Replication options require the ADMIN privilege.

Cache options require the CACHE_MANAGER privilege.

All other options require the ADMIN privilege.

Usage in TimesTen Scaleout and TimesTen Classic

This utility is supported in TimesTen Classic but not supported in TimesTen Scaleout.

Syntax

ttAdmin {-h | -help | -?}
ttAdmin {-V | -version}
ttAdmin -query {-connStr connection_string | DSN} 

ttAdmin  [-ramUnload | -ramLoad [-open | -close]]
         [-ramPolicy {always | manual | enduring | inUse [-ramGrace secs]}]
         [-autoreload | -noautoreload]
         [-shmAttach | -shmDetach [-ckpt | -noCkpt] | -shmFree]

         [-disconnect urgency [granularity]] {-connStr connection_string | DSN}]
           urgency: {-transactional | -immediate | -abort}
           granularity: [-users | -unload]

ttAdmin -clientExportAll {FILE}{-connStr connection_string | DSN}
 
ttAdmin -certificateList [-json]

ttAdmin  [-repPolicy always | manual | norestart]
         [-repStart | -repStop]
         [-repQueryThresholdSet secs]
         [-repQueryThresholdGet]

           [-cacheUidGet]
           [-cacheUidPwdSet -cacheUid uid [-cachePwd pwd]]
           [-cachePolicy {always | manual | norestart}]
           [-cacheStart] 
           [-cacheStop [-stopTimeout secs]]
           {-connStr connection_string | DSN}

Notes

The following notes apply to all modes of ttAdmin usage:

You need to set some environment variables. See Environment Variables in Oracle TimesTen In-Memory Database Installation, Migration, and Upgrade Guide for more details.

The ttAdmin utility is supported only for TimesTen Data Manager DSNs. It is not supported for TimesTen Client DSNs.