1
Download TimesTen Troubleshooting Guide
Transcript
Contents Preface ................................................................................................................................................................. ix Audience....................................................................................................................................................... Related documents...................................................................................................................................... Conventions ................................................................................................................................................. Documentation Accessibility ..................................................................................................................... Technical support ........................................................................................................................................ ix ix ix x xi What's New ...................................................................................................................................................... xiii New features in release 11.2.1.7.0 ........................................................................................................... New features in release 11.2.1.6.0 ........................................................................................................... New features in release 11.2.1.0 .............................................................................................................. xiii xiii 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-11 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 Databases Unable to start or stop TimesTen daemon .......................................................................................... 2-1 No response from TimesTen daemon or subdaemon ....................................................................... 2-2 iii
