listener-thread: err = -27001

Hi, Guys, Build Version: 11.10.UC2 Build Number: N158 Build Host: vach Build OS: AIX 5.3 Build Date: Thu Oct 25 22:56:40 CDT 2007 GLS Version: glslib-4.50.UC2 We repeatedly receive the following error msg in online log, 19:43:34 listener-thread: err = -27001: oserr = 0: errstr = : Read error occurred during connection attempt. 19:43:54 listener-thread: err = -27001: oserr = 0: errstr = : Read error occurred during connection attempt. and onstat -g ntd shows many( 2451) sqlexec Calls were Rejected( see below). (1) Can we figure out which session's call was rejected? (2) Add another listen port( server alias/listener thread) will address the issue?( we think we have enough Poll threads already) (3) Any suggestions/ideas are very welcome!! Thanks a lot, Frank fqu@erika $ onstat -g ntd IBM Informix Dynamic Server Version 11.10.UC2 -- On-Line -- Up 18 days 18:52:55 -- 2023296 Kbytes global network information: #netscb connects read write q-free q-limits q-exceed alloc/max 63/ 189 0 642201 1569458992 1580668560/ 179 201/ 520 10/ 0 7071/ 226 Client Type Calls Accepted Rejected Read Write sqlexec yes 642201 2451 1505268501 1512454514 srvinfx yes 0 0 0 0 onspace yes 0 0 32 74 onlog yes 0 0 0 0 onparam yes 0 0 0 0 oncheck yes 0 0 4635 4600 onload yes 0 0 0 0 onunload yes 0 0 0 0 onmonitor yes 0 0 0 0 dr_accept yes 0 0 0 0 cdraccept yes 0 2 3722635 4433834 ontape yes 0 0 44057218 44059736 srvstat yes 0 0 2385 4770 asfecho yes 0 0 0 0 listener yes 0 0 639756 4 crsamexec yes 0 0 0 0 onutil yes 0 0 0 0 safe yes 0 0 0 0 drdaexec no 0 0 0 0 smx yes 0 0 0 0 Totals 642201 2453 1569458992 1580668560

If the incoming connection request is being rejected by the listener thread there won't be a session id - the session does not exist yet. Unless you are getting hammered by incoming connection requests or your network is being overhwhelmed by other apps I doubt a second listener (DBSERVERALIAS) will be useful. I would consider opening a ticket with technical support and ask that they use the xtrace utiliy (internal tool) to uncover more evidence. In addition take a look at system logs to see if there is anything useful there. Mike

Thank you, Mike!! Frank On Tue, Nov 18, 2008 at 3:07 PM, MIKE MAGIE <jmmagie@yahoo.com> wrote: > If the incoming connection request is being rejected by the listener thread > there won't be a session id - the session does not exist yet. Unless you > are > getting hammered by incoming connection requests or your network is being > overhwhelmed by other apps I doubt a second listener (DBSERVERALIAS) will > be > useful. I would consider opening a ticket with technical support and ask > that > they use the xtrace utiliy (internal tool) to uncover more evidence. In > addition take a look at system logs to see if there is anything useful > there. > > Mike > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > >