Subject: | prepare() fails: |
I'm getting out of database handles since I upgraded
Perl from 5.6.1 to 5.8.5.
OK: This is perl, v5.6.1 built for aix
KO: This is perl, v5.8.5 built for aix-thread-multi
The code that produces the error has a loop that
is constantly executing
my $sth=$dbh->prepare(...);
$sth->execute(...);
$sth->fetchrow_hashref(...);
After a few iterations, prepare() fails and produces the
following $dbh->errstr:
[IBM][CLI Driver] CLI0129E No more handles. SQLSTATE=HY014 at /home/cc/perl5lib/SDRH/KdMigr.pm line 503.
I'm running this on AIX-4.2.1.
(uname -a: AIX db2serv1 2 4 00C2CBCB4C00)
Any suggestions welcome...