No more handles error with DBD::DB2 on Linux

[Hemant Shah]

Folks,

I have DB2 UDB 7.2 EE installed on AIX 5.2 system. I think I am at
latest fixpack, see output of lslpp below. I have also installed DB2
UDB 7.2 EE on RedHat Linux 7.3 I believe that is also at the latest
fix pack, see rpm output below.

The database is on AIX system and on the Linux system it is cataloged
as remote database.

I have perl/TK GUI that uses DBD:B2 interface to access the database.
If I run the GUI from AIX system (server) I have no problems. If I
run GUI from Linux system (client), then after using it for some time
I get following error:

CLI0129E No more handles.

Last time I got this error I ran following commands on the Server:

db2 list applications
db2 get snapshot for applications on dbname

There was only one connection to the database and that was the GUI,
the application also had only one section.

I have checked my code and I always call finish() method on the
statement handle after I am done. All the access to the database is
done by calling various functions. When the GUI is started it connects
to the database. Each function creates and prepares the statement and then
executes it and then calls finish() before returning.


I am not sure why I am getting this error from the Linix client.



# lslpp -l "db2_07_01*"
Fileset Level State Description
----------------------------------------------------------------------------
Path: /usr/lib/objrepos
db2_07_01.adt.rte 7.1.0.72 COMMITTED Application Development Tools
(ADT)
db2_07_01.adt.samples 7.1.0.72 COMMITTED ADT Sample Programs
db2_07_01.cdb 7.1.0.72 COMMITTED Control Database
db2_07_01.cj 7.1.0.72 COMMITTED Java Common files
db2_07_01.client 7.1.0.72 COMMITTED Client Application Enabler
db2_07_01.cnvucs 7.1.0.72 COMMITTED Code Page Conversion Tables -
Uni Code Support
db2_07_01.conn 7.1.0.72 COMMITTED Connect
db2_07_01.conv.jp 7.1.0.40 COMMITTED Code Page Conversion Tables -
Japanese
db2_07_01.conv.kr 7.1.0.40 COMMITTED Code Page Conversion Tables -
Korean
db2_07_01.conv.sch 7.1.0.40 COMMITTED Code Page Conversion Tables -
Simplified Chinese
db2_07_01.conv.tch 7.1.0.40 COMMITTED Code Page Conversion Tables -
Traditional Chinese
db2_07_01.cs.drda 7.1.0.72 COMMITTED Communication Support - DRDA
Application Server
db2_07_01.cs.ipx 7.1.0.72 COMMITTED Communication Support - IPX
db2_07_01.cs.rte 7.1.0.72 COMMITTED Communication Support - TCP/IP
db2_07_01.cs.sna 7.1.0.72 COMMITTED Communication Support - SNA
db2_07_01.ctsr 7.1.0.72 COMMITTED Control Server
db2_07_01.das 7.1.0.72 COMMITTED Administration Server
db2_07_01.db2.engn 7.1.0.72 COMMITTED Engine
db2_07_01.db2.rte 7.1.0.72 COMMITTED Run-time Environment
db2_07_01.db2.samples 7.1.0.40 COMMITTED Sample Database Source
db2_07_01.db2tie 7.2.0.2 COMMITTED Text Information Extender
db2_07_01.elic 7.1.0.72 COMMITTED Product Signature for UDB
Enterprise Edition
db2_07_01.jdbc 7.1.0.72 COMMITTED Java Support
db2_07_01.ldap 7.1.0.72 COMMITTED DB2 LDAP Support
db2_07_01.spb 7.1.0.72 COMMITTED Stored Procedure Builder
db2_07_01.tspf 7.1.0.72 COMMITTED Transformer Stored Procedure
Files
db2_07_01.wcc 7.1.0.72 COMMITTED Control Center

----------------------------------------------------------------------
# rpm -qa | grep db2
db2-2.4.14-10
db2das71-7.1.0-68
db2cnvc71-7.1.0-68
db2-devel-2.4.14-10
db2jdbc71-7.1.0-68
db2cj71-7.1.0-68
db2adt71-7.1.0-68
db2crte71-7.1.0-68
db2cnvj71-7.1.0-68
db2cliv71-7.1.0-68
db2engn71-7.1.0-68
db2conn71-7.1.0-68
db2smpl71-7.1.0-68
db2cnvt71-7.1.0-68
db2rte71-7.1.0-68
db2wcc71-7.1.0-68
db2adts71-7.1.0-68
db2cdrd71-7.1.0-68
db2cnvk71-7.1.0-68
db2cucs71-7.1.0-68
db2repl71-7.1.0-68
db2elic71-7.1.0-68

--
Hemant Shah /"\ ASCII ribbon campaign
E-mail: (e-mail address removed) \ / ---------------------
X against HTML mail
TO REPLY, REMOVE NoJunkMail / \ and postings
FROM MY E-MAIL ADDRESS.
-----------------[DO NOT SEND UNSOLICITED BULK E-MAIL]------------------
I haven't lost my mind, Above opinions are mine only.
it's backed up on tape somewhere. Others can have their own.

 

[L D Jones]

Folks,

I have DB2 UDB 7.2 EE installed on AIX 5.2 system. I think I am at
latest fixpack, see output of lslpp below. I have also installed DB2
UDB 7.2 EE on RedHat Linux 7.3 I believe that is also at the latest
fix pack, see rpm output below.

The database is on AIX system and on the Linux system it is cataloged
as remote database.

I have perl/TK GUI that uses DBD:B2 interface to access the database.
If I run the GUI from AIX system (server) I have no problems. If I
run GUI from Linux system (client), then after using it for some time
I get following error:

CLI0129E No more handles.

I suspect your problem is not with DBD:B2. try comp.databases.ibm-db2