Commands to Start TimesTen Service:
./ttdaemonadmin -start
./ttdaemonadmin -startserver
Commands to Stop TimesTen Service:
./ttdaemonadmin -stopserver
./ttdaemonadmin -stop
Command to get status of TimesTen DB:
./ttstatus
Note: Important to notice is whether the Data is loaded into RAM or not
Command to load the data into RAM:
./ttAdmin -connstr “dsn=DATA_SOURCE_NAME” -ramLoad
Command to unload data from RAM:
./ttAdmin -connstr “dsn=DATA_SOURCE_NAME” -ramUnload
Command to run quick query on the TimesTen DB:
./ttIsql -connstr “dsn=DATA_SOURCE_NAME” -e “SQL_STATEMENT_1; SQL_STATEMENT_2;”
Location of Log Files for Troubleshooting:
TimesTen/t1122/info, the two most important files are tterrors.log and ttmesg.log
If you would like to know more about Oracle TimesTen Database:
Overview: http://www.oracle.com/us/products/database/timesten/overview/index.html
Product Documentation: http://docs.oracle.com/cd/E13085_01/doc/index.htm