Multi-threading with DB2 DBD
- From: gwise@xxxxxxxxxxxxxx
- Date: 29 Dec 2006 08:23:27 -0800
I have this multi-threaded perl program where I'm trying to do
independant database operations in separate threads. I was getting an
error similar to the following:
DB2 has no driver CLONE() function so is unsafe threaded
After looking at the code and some other perl DB drivers, I added the
following bit to the DB2.pm file:
sub CLONE {
$drh = undef;
}
I e-mailed a guy at IBM who had something to do with the Perl stuff
(sorry, can't remember the name) and he said that the underlying driver
should be all thread safe and this should work.
In all my testing that I've run, I've never had a problem running
multi-threaded with this code in place. So, my question is, does
anyone know how we'd get this change made to the DB2 DBD driver? I
gotta believe someone out there wants to use DB2 in a multi-threaded
Perl application. Am I going to have to keep patching this in by hand?
Thanks,
Greig Wise
Lead Database Developer
Press Ganey Associates
.
- Prev by Date: Re: out of memory
- Next by Date: Re: out of memory
- Previous by thread: out of memory
- Next by thread: Help with Oracle stored proc call
- Index(es):
Relevant Pages
|