Technical data

iii
Contents
Preface ................................................................................................................................................................. ix
Audience....................................................................................................................................................... ix
Related documents...................................................................................................................................... ix
Conventions ................................................................................................................................................. ix
Documentation Accessibility..................................................................................................................... x
Technical support........................................................................................................................................ xi
What’s New...................................................................................................................................................... xiii
New features for release 11.2.1.6............................................................................................................. xiii
New features for release 11.2.1................................................................................................................ xiii
1 Tools for Troubleshooting TimesTen
Using the ttIsql utility ............................................................................................................................. 1-1
Using the ttStatus utility......................................................................................................................... 1-2
Using the ttCapture utility...................................................................................................................... 1-5
Using the logs generated by the TimesTen daemon ......................................................................... 1-6
Using the ttTraceMon utility.................................................................................................................. 1-6
Starting a trace and reading the trace buffer.................................................................................. 1-7
SQL tracing.......................................................................................................................................... 1-9
API tracing ....................................................................................................................................... 1-10
DEADLOCK tracing ....................................................................................................................... 1-10
LOCK tracing................................................................................................................................... 1-12
ERR tracing....................................................................................................................................... 1-13
AGING tracing ................................................................................................................................ 1-14
AUTOREFRESH tracing................................................................................................................. 1-16
Using the ttXactAdmin utility............................................................................................................. 1-19
Using ODBC tracing ............................................................................................................................. 1-20
Using SNMP traps to detect events ................................................................................................... 1-20
Monitoring the TimesTen system tables .......................................................................................... 1-20
Using the query optimizer................................................................................................................... 1-21
2 Troubleshooting TimesTen Applications and Data Stores
Unable to start or stop TimesTen daemon .......................................................................................... 2-1
No response from TimesTen daemon or subdaemon....................................................................... 2-2
Check the TimesTen user error log.................................................................................................. 2-2