OT: Db2 connection pooling?
Hey folks,
Sorry for the OT - we are most of the way through a Db2 --> PG
migration that is some 18 months in the making so far. We've got
maybe another 3 to 6 months to go before we are complete, and in the
meantime have identified the need for connection pooling in Db2, a-la
the excellent pgbouncer tool we have implemented on PG
We are 100% CentOS based.
Anyone know of anything?
From my process list it looks like Db2 V8.1 - my DBA is away at the
moment so I cannot ask him :)
root 3370 1 0 2009 ? 00:18:38 /opt/IBM/db2/V8.1/bin/db2fmcd
thanks,
-Alan
--
“Don't eat anything you've ever seen advertised on TV”
- Michael Pollan, author of "In Defense of Food"
On Fri, 2010-01-15 at 12:16 -0500, Alan McKay wrote:
Hey folks,
Sorry for the OT - we are most of the way through a Db2 --> PG
migration that is some 18 months in the making so far. We've got
maybe another 3 to 6 months to go before we are complete, and in the
meantime have identified the need for connection pooling in Db2, a-la
the excellent pgbouncer tool we have implemented on PGWe are 100% CentOS based.
Anyone know of anything?
From my process list it looks like Db2 V8.1 - my DBA is away at the
moment so I cannot ask him :)root 3370 1 0 2009 ? 00:18:38 /opt/IBM/db2/V8.1/bin/db2fmcd
thanks,
-Alan--
“Don't eat anything you've ever seen advertised on TV”
- Michael Pollan, author of "In Defense of Food"
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
Consulting, Training, Support, Custom Development, Engineering
Respect is earned, not gained through arbitrary and repetitive use or Mr. or Sir.
Yeah, that is Db2 Enterprise, and we have Workgroup Server version.
And the cost of upgrading to that was part of why we decided to move
to PG.
So I should have been more specific - a FREE connection pooler :-)
--
“Don't eat anything you've ever seen advertised on TV”
- Michael Pollan, author of "In Defense of Food"
On Fri, Jan 15, 2010 at 2:40 PM, Alan McKay <alan.mckay@gmail.com> wrote:
Yeah, that is Db2 Enterprise, and we have Workgroup Server version.
And the cost of upgrading to that was part of why we decided to move
to PG.So I should have been more specific - a FREE connection pooler :-)
What language are you running this in again? There might be other
options that are more language oriented (java for instance) than db
oriented. Or maybe some intermediate layer for pooling that's db
agnostic.
On Fri, Jan 15, 2010 at 4:45 PM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
What language are you running this in again? There might be other
options that are more language oriented (java for instance) than db
oriented. Or maybe some intermediate layer for pooling that's db
agnostic.
Oh, should have mentioned that too - Perl
--
“Don't eat anything you've ever seen advertised on TV”
- Michael Pollan, author of "In Defense of Food"
On Fri, 2010-01-15 at 17:35 -0500, Alan McKay wrote:
On Fri, Jan 15, 2010 at 4:45 PM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
What language are you running this in again? There might be other
options that are more language oriented (java for instance) than db
oriented. Or maybe some intermediate layer for pooling that's db
agnostic.Oh, should have mentioned that too - Perl
Mod_perl?
--
“Don't eat anything you've ever seen advertised on TV”
- Michael Pollan, author of "In Defense of Food"
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
Consulting, Training, Support, Custom Development, Engineering
Respect is earned, not gained through arbitrary and repetitive use or Mr. or Sir.
On Fri, Jan 15, 2010 at 5:36 PM, Joshua D. Drake <jd@commandprompt.com> wrote:
Mod_perl?
That on our front-end servers, as well as just regular perl on the back end.
--
“Don't eat anything you've ever seen advertised on TV”
- Michael Pollan, author of "In Defense of Food"