RE: 'Phantom' connections?
The flag codes for position 7: B btree cleaner thread C terminated user thread waiting for cleanup D a daemon thread F a page-cleaner thread M special Dynamic Server utility thread So I guess that you probably have 131 cleaners. Just having a quick look at the nwrites column I am going to stick my neck out and say that you probably don't need that many. Check your onconfig file? Jo > Morning all, > > does anyone know what these informix connections are? we > counted 131 > of them this morning. > > brett > > INFORMIX-OnLine Version 7.24.UC6 -- On-Line -- Up 04:22:03 > -- 190464 > Kbytes > > Userthreads > address flags sessid user tty wait tout > locks nreads > nwrites4003a014 ---P--D 1 informix - 0 0 > 0 82 > 192 > 4003a454 ---P--F 0 informix - 0 0 0 > 0 > 396 > 4003a894 ---P--F 0 informix - 0 0 0 > 0 > 0 > 4003acd4 ---P--F 0 informix - 0 0 0 > 0 > 0 > 4003b114 ---P--F 0 informix - 0 0 0 > 0 > 40 > 4003b554 ---P--F 0 informix - 0 0 0 > 0 > 131 > 4003b994 ---P--F 0 informix - 0 0 0 > 0 > 313 > 4003bdd4 ---P--F 0 informix - 0 0 0 > 0 > 150 > 4003c214 ---P--F 0 informix - 0 0 0 > 0 > 579 > 4003c654 ---P--F 0 informix - 0 0 0 > 0 > 0 > 4003ca94 ---P--F 0 informix - 0 0 0 > 0 > 0 > 4003ced4 ---P--F 0 informix - 0 0 0 > 0 > 0 > 4003d314 ---P--F 0 informix - 0 0 0 > 0 > 0 > 4003d754 ---P--F 0 informix - 0 0 0 > 0 > 0 > 4003db94 ---P--F 0 informix - 0 0 0 > 0 > 0 > 4003dfd4 ---P--F 0 informix - 0 0 0 > 0 > 0 > 4003e414 ---P--F 0 informix - 0 0 0 > 0 > 0 > 4003e854 ---P--F 0 informix - 0 0 0 > 0 > 0 > 4003ec94 ---P--F 0 informix - 0 0 0 > 0 > 0 > ___________________________________________________________________________ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of Sema Group. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the Sema Group Helpdesk by telephone on +44 (0) 121 627 5600. ___________________________________________________________________________