• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1977
  • Last Modified:

IBM Informix Windows ODBC Connection Problem

I am setting up several Windows machines using ODBC clients to connect to IBM Informix DB. When testing the ODBC connections I got quick responses on some machines and slow responses (delays ranging from 2s ~ 10+s) for the others. After capturing the TCP packets I found that for a quick response the TCP packet returned from DB right after the last request packet was sent is a PSH ACK packet already containing the actual response TCP payload, while for a slow response the first packet returned is only a ACK packet for the request, and another PSH ACK packet (containing the response payload) was then received only after the mentioned delay. Is the problem related to DB configurations or firewall configurations?

Any kind of help is greatly appreciated!

Informix version: 11.x
ODBC Client version: 3.50.FC4
OS: Windows Server 2008 64-bit
0
PYA172
Asked:
PYA172
  • 2
1 Solution
 
gheistCommented:
This problem is ususally related to problems with DNS setup
Informix server tries to find client name from IP and waits for timeout.
0
 
PYA172Author Commented:
Thanks gheist for your comment and I will ask my colleagues in network team to check the DNS. I will accept this as solution once the problem has been confirmed solved by them.
0
 
gheistCommented:
Or disable DNS lookup on informix server (nameserver 127.0.0.1)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now