DB Connection Times

Posted in 2000

Parker, J — Mon, 31 Jan 2000 11:12:10 -0500 — source: Informix-list mailing list archive (1991-1998)

Question: 1 - What Informix onstat commands or Unix statistics can I analyze to understand the cause for long delays when connecting to our database. I've looked at "onstat -g nt?" commands but they don't seem very useful. 2 - What Informix/Unix parms can I "tune" to reduce connection times Background: - Hardware/Software: HP-UX 11, Informix 7.31.FC2 - We have Informix 4GL applications running on an application server connecting to our DB server. - Application server is connected to db server via 2 100Mb network paths. - The connect time on average is ~ 3-4 sec but is extremely variable and can peak up to 40 seconds. We've tried experimenting w/ adding listen threads and poll threads but haven't seen much improvement. Thanks for the help

Related threads

Posting from the Informix-list
Migrating from IDS 9.40.UC6 to 11.50.UC3
Ip for a network session
questions onstat -g