Files
oracle/vg/TimesTen_commands.txt
2026-03-12 21:23:47 +01:00

42 lines
1.1 KiB
Plaintext

Check for connection DSN name in following odbc.ini files.
############################
# ODBC ini file locations
############################
/opt/TimesTen/tt112230/info/sys.odbc.ini
############################
# Start/Stop/Restart Timesten MAIN daemon
# -force Starts or stops the TimesTen main daemon, even when warnings are returned.
ttDaemonAdmin [-force] {-start | -stop | -restart}
############################
# Start/Stop/Restart Timesten Server daemon
# -force immediately stops the server processes.
ttDaemonAdmin [ -startserver | -restartserver ]
ttDaemonAdmin [-force] -stopserver
ttDaemonAdmin
############################
# Display Timesten status
ttStatus {-h | -help | -?}
ttStatus {-V | -version}
ttStatus [-v] [-r secs] [-[no]pretty]
ttStatus [-r secs] [-[no]pretty] {DSN | -connStr connection_string | dspath}
############################
# Transaction
############################
ttIsql -connStr "DSN=aceds;"
Command> call ttLogHolds;
Command>
############################
# Display Query Plan
############################
ttIsql -connStr "DSN=aceds;"
Command> call ttSQLCmdQueryPlan(25215090200);