Technical data

1
Tools for Troubleshooting TimesTen 1-1
1Tools for Troubleshooting TimesTen
This chapter describes how to use the TimesTen utilities and other tools that are used
to diagnose problems with the TimesTen data store. This chapter includes the
following topics:
■ Using the ttIsql utility
■ Using the ttStatus utility
■ Using the ttCapture utility
■ Using the logs generated by the TimesTen daemon
■ Using the ttTraceMon utility
■ Using the ttXactAdmin utility
■ Using ODBC tracing
■ Using SNMP traps to detect events
■ Monitoring the TimesTen system tables
■ Using the query optimizer
Using the ttIsql utility
The ttIsql utility allows you to interactively execute SQL statements and report
status information on your data store.
All TimesTen SQL operations can be executed from a ttIsql Command> prompt.
Example 1–1 Using the ttIsql utility
To start the ttIsql utility for the demo data store, enter:
% ttIsql demo
You should see output similar to the following:
Copyright (c) 1996-2007, Oracle. All rights reserved.
Type ? or "help" for help, type "exit" to quit ttIsql.
connect "DSN=demo";
Connection successful: DSN=demo;UID=ttuser;DataStore=c:\temp\demo;
DatabaseCharacterSet=US7ASCII;ConnectionCharacterSet=US7ASCII;
DRIVER=C:\WINDOWS\system32\ttdv70.dll;Authenticate=0;PermSize=20;TypeMode=0;
(Default setting AutoCommit=1)
Command>