Technical data

iv
Extract a stack trace from the core file ............................................................................................ 2-2
Unable to create shared segment........................................................................................................... 2-3
Application unable to connect to data store in direct mode ............................................................ 2-3
Upgrading your data store ............................................................................................................... 2-4
Privileges to connect to data store ................................................................................................... 2-4
Check file system permissions to access data store....................................................................... 2-4
Check that the TimesTen daemon is running................................................................................ 2-4
Check DSN definition........................................................................................................................ 2-4
Check DSN attributes................................................................................................................. 2-4
Check path name to data store and transaction log directories........................................... 2-4
Manage semaphores and shared memory segments.................................................................... 2-5
Check available swap space (virtual memory).............................................................................. 2-5
Increase the number of available file descriptors.......................................................................... 2-6
Troubleshooting Client/Server problems............................................................................................ 2-6
Cannot connect to the TimesTen Server ......................................................................................... 2-6
TimesTen Server failed ..................................................................................................................... 2-7
Cannot find Server DSN.................................................................................................................... 2-7
TimesTen Server failed to load DRIVER ........................................................................................ 2-7
Application times out when accessing TimesTen Server............................................................. 2-8
TimesTen Client loses connection with TimesTen Server ........................................................... 2-8
Failed to attach to shared memory segment for IPC..................................................................... 2-8
Increasing the maximum server connections on Windows XP................................................... 2-8
Thread stack overflow when using multiple client connections................................................. 2-8
Out of space when DSN specifies new data store......................................................................... 2-9
Application connects or disconnects are slow .................................................................................... 2-9
Check if data store is being recovered ............................................................................................ 2-9
Check ODBC tracing.......................................................................................................................... 2-9
Application becomes disconnected unexpectedly............................................................................. 2-9
Check for ODBC or JDBC errors................................................................................................... 2-10
Check the user error log................................................................................................................. 2-10
Application is slow ............................................................................................................................... 2-10
Consider connection mode ............................................................................................................ 2-11
Update statistics for your tables.................................................................................................... 2-11
Verify lock and isolation levels ..................................................................................................... 2-12
Check trace settings ........................................................................................................................ 2-12
Check partition counts for the tables............................................................................................ 2-12
Application unresponsive, appears hung......................................................................................... 2-13
Check logs and gather trace information..................................................................................... 2-13
Check for ODBC errors .................................................................................................................. 2-13
Check for deadlocks and timeouts ............................................................................................... 2-14
Application unable to find previously created objects.................................................................. 2-14
Specify object owner ....................................................................................................................... 2-15
Check privilege to access tables .................................................................................................... 2-15
Check temporary DSN attribute ................................................................................................... 2-15
Check Overwrite DSN attribute.................................................................................................... 2-15
Check path name to data store...................................................................................................... 2-15
Troubleshooting OCI and Pro*C/C++ applications ....................................................................... 2-16