×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Informix ODBC connection extremely slow - intermittent

Informix ODBC connection extremely slow - intermittent

Informix ODBC connection extremely slow - intermittent

(OP)
My Informix ODBC connection has been working great for several months.  Today, it slowed to a crawl.  This happened once before.  I spent the entire day on the phone trying to get someone to help me, failed, and went home.  When I came in the next morning, everything was working fine.  I'm not a huge fan of that method, especially since the problem eventually returns.  :(

Here's an example of the problem.  I just ran the ilogin demo.  It took 39 seconds for it to give me the standard "not found" message.  This is causing the ODBC apps I've got written to go realllllly slowly.

My server seems to be humming along just fine.  Idle is in the 90's.  I rebooted it anyway.  I also rebooted our only windows server, and all the hubs for good measure.  I then brought the system up and before I had any users on it, I tried a connection.  Almost a minute.

I'm stumped.  I don't know what's happening or even where to start looking.  Any ideas on how I might troubleshoot this????

Thank you!

RE: Informix ODBC connection extremely slow - intermittent

(OP)
Argh.  After 3 hours of extremely slow response, it just started working great again.  How maddening.

RE: Informix ODBC connection extremely slow - intermittent

Agilehound,

Do you update statistics regularly? I've only seen it happen once but a clients database (Informix SE 7.??) ground to a halt, everything else on server was OK (mem, CPU etc). Only thing that cured it was running update statistics. I only ran it as I had run out of other options.

Adrian

RE: Informix ODBC connection extremely slow - intermittent

(OP)
Hi Capoerista,

I did try updating the statistics on the DB (which, admittedly, is not something I do regularly), but it didn't make a difference.  I have a terminal emulation app that runs against the same database, and that was behaving fine the entire time . . . most puzzling!

RE: Informix ODBC connection extremely slow - intermittent

I have the same problem...if you found the cuse of the problem please let me know..I'll do the same if i find it.

RE: Informix ODBC connection extremely slow - intermittent

(OP)
Hi Madbull,

Yup, we did figure it out.  It actually had nothing to do with Informix and everything to do with the TCP/IP settings, even though Informix was the only thing showing symptoms.

We were using one of our vendor's www in our namespace for some reason (I didn't set it up, so I'm not sure why that would be), and that vendor disallowed that causing, extreme ODBC slowdowns on our end.

Rather hard to find, but fixing that resolved the problem!  (knock on wood!)

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close