Slow - listener-thread: err = -27001 -25573

[Sritharan]

Hi,

We are using HPUX 11i with MC/SG running Informix 9.4,recently we are getting error message in informix log.

listener-thread: err = -27001: oserr = 0: errstr = : Read error occurred during connection attempt.

listener-thread: err = -25573: oserr = 233: errstr = : Network driver cannot accept a connection on the port. System error = 233.

But there is no error message in system logs.

I also have checked on the informix level there is no any error on the Database level also.The user is complaining the application is very slow recently.

How do I overcome this problem?

Thanks & Regards
Sri

[Tony Scully_2]

I think system error 233 is no buffer space.

Do you have memeory problems on the server, maybe post output of:

swapinfo -tam

sar -v 1 1

sar -w 1 1

T

[Sritharan]

Hi,

Below are the result.

swapinfo -tam

Mb Mb Mb PCT START/ Mb
TYPE AVAIL USED FREE USED LIMIT RESERVE PRI NAME
dev 4096 0 4096 0% 0 - 1 /dev/vg00/lvol2
reserve - 1658 -1658
memory 3152 1688 1464 54%
total 7248 3346 3902 46% - 0 -

sar -v 1 1
15:31:42 text-sz ov proc-sz ov inod-sz ov file-sz ov
15:31:43 N/A N/A 130/1404 0 890/1604 0 940/5010 0

sar -w 1 1
15:31:53 swpin/s bswin/s swpot/s bswot/s pswch/s
15:31:54 0.00 0.0 0.00 0.0 1407


Thanks & Regards
Sri

[Steve Lewis]

As user informix, type finderr -27001 to get a longer description of this error.

The solution is to change your onconfig file to increase the number of network poll threads under NETTYPE. I like to run them in separate VPs, to free up the CPU VPs for SQL work.

I use soctcp as the connection type in the sqlhosts. The onconfig parameter to configure 2 poll threads instead of one is this:

NETTYPE soctcp,2,100,NET

That configures 2 soc VPs with initial memory for 100 connections each.

[Sritharan]

Hi,

Sorry for the late reply..

We already configured the
NETTYPE soctcp,2,400,NET

Is that anything else that could cause this problem.On the OS level what else i can monitor and also on the Database level.


Thanks & Regards
sri

[Steve Lewis]

What about

NETTYPE soctcp,4,200,NET ?

What about your free CPU? Is there none left?

You may consider putting some local connections on ipcshm instead of soctcp, to reduce workload on those threads.

Other than that, make sure you are up-to-date on patches.