Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

IBM Informix Windows ODBC Connection Problem

Posted on 2010-08-23
3
Medium Priority
?
1,964 Views
Last Modified: 2013-12-24
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
Comment
Question by:PYA172
  • 2
3 Comments
 
LVL 62

Accepted Solution

by:
gheist earned 1000 total points
ID: 33508536
This problem is ususally related to problems with DNS setup
Informix server tries to find client name from IP and waits for timeout.
0
 

Author Comment

by:PYA172
ID: 33517473
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
 
LVL 62

Expert Comment

by:gheist
ID: 33519238
Or disable DNS lookup on informix server (nameserver 127.0.0.1)
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you’re involved with your company’s wide area network (WAN), you’ve probably heard about SD-WANs. They’re the “boy wonder” of networking, ostensibly allowing companies to replace expensive MPLS lines with low-cost Internet access. But, are they …
Tech spooks aren't just for those who are tech savvy, it also happens to those of us running a business. Check out the top tech spooks for business owners.
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…

564 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question