Re: Deamon Threads

> Right now we are seeing that there are almost 700 informix threads on >the primary instance. I get this using 'onstat -u'. All these threads >are owned by informix. The Flags field of the 'onstat -u' o/p has >"Y--P--D" (Y - waiting on a condition, P - Primary thread for a session, >D - deamon thread) for all the above threads. The 'pid' of the above >sessions is 0 in the sysesssions table. > On 7.2x with Enterprise Replication, there are a lot of threads that might be generated. If the majority of them start with CDRD_, then they are the "data sync" threads. If there appear to be an excess of them in comparision to the repl threads, then there could be a problem. If the majority of the threads are not sqlexec threads, then there might be a problem. If so, then please submit a case with support, including the onstat -g ath listing. Madison Pruet