Re: DBI->connect performance issue

2014-04-29 Thread Andrew Park
Thanks for the suggestions that I received. We finally managed to find and correct the issue so I thought I'd share it with the group to close this thread. Essentially, if we try to use a local catalog entry for the DB2 10.5 database we consistently get slow response times (4s for 32-bit version a

DBI->connect performance issue

2014-04-14 Thread Andrew Park
Hi, Hoping somebody on this mailing list can help me. We're running Perl 5.10.1 on AIX 7.1. We're finding that simply creating a connection maxes out one of the CPU's and consistently takes over 4s (but sometimes it manages to create the connection in about .2s). On our old AIX 5.1 server running