Download TimesTen Troubleshooting Guide
Transcript
Using the ttStatus utility Example 1–3 ttStatus shows TimesTen daemon is running In this example, the output from ttStatus indicates that the TimesTen daemon is running. It recognizes one database named demo. The first line indicates that the TimesTen daemon is running as process 884 on port 17000 for the TimesTen instance MYINSTANCE. The second line indicates the TimesTen Server is running as process 2308 on port 17002. There are currently seven connections to the database: one user and six subdaemon connections. You may see up to 2047 connections. The restart policies for the cache agent and the replication agent in the database are set to manual. This example was produced on Windows. The results are the same on UNIX platforms except for the formats of the database path and the shared memory key. Note: C:\>ttStatus TimesTen status report as of Thu Jan 25 15:45:11 2007 Daemon pid 884 port 17000 instance MYINSTANCE TimesTen server pid 2308 started on port 17002 TimesTen webserver pid 2188 started on port 17004 -----------------------------------------------------------------------Data store c:\temp\demo There are 7 connections to the data store Data store is in shared mode Shared Memory KEY Global\DBI45b94095.1.SHM.4 HANDLE 0x278 Type PID Context Connection Name ConnID Process 4616 0x00d08820 demo 1 Subdaemon 2136 0x00526768 Worker 2042 Subdaemon 2136 0x0072e750 Flusher 2043 Subdaemon 2136 0x007348b8 Checkpoint 2044 Subdaemon 2136 0x067b0068 Aging 2045 Subdaemon 2136 0x067c0040 Monitor 2047 Subdaemon 2136 0x068404c8 HistGC 2046 Replication policy : Manual Cache agent policy : Manual -----------------------------------------------------------------------End of report Example 1–4 ttStatus shows replication information In this example, the output from ttStatus indicates that the TimesTen daemon is running. It recognizes three databases: demo, subscriber1ds, and masterds. The subscriber1ds and masterds databases are replicated databases. In this example, the output from ttStatus indicates that the replication agents for the replicated databases have been started. Bidirectional replication has been configured between masterds and subscriber1ds. Each replication agent has five connections to the database. C:\>ttStatus TimesTen status report as of Thu Jan 25 16:23:33 2007 Daemon pid 5088 port 17000 instance MYINSTANCE TimesTen server pid 4344 started on port 17002 Tools for Troubleshooting TimesTen 1-3