No more handles error with DBD::DB2 on Linux

Discussion in 'Perl Misc' started by Hemant Shah, Mar 5, 2004.

  1. Hemant Shah

    Hemant Shah Guest

    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::DB2 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: \ / ---------------------
    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.
     
    Hemant Shah, Mar 5, 2004
    #1
    1. Advertising

  2. Hemant Shah

    L D Jones Guest

    Hemant Shah wrote:
    >
    > 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::DB2 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::DB2. try comp.databases.ibm-db2
     
    L D Jones, Mar 6, 2004
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Replies:
    0
    Views:
    7,607
  2. eino
    Replies:
    1
    Views:
    434
    =?ISO-8859-15?Q?=22Martin_v=2E_L=F6wis=22?=
    May 8, 2007
  3. Dinesh
    Replies:
    0
    Views:
    160
    Dinesh
    Apr 3, 2006
  4. Replies:
    0
    Views:
    184
  5. Jim Cochrane
    Replies:
    0
    Views:
    118
    Jim Cochrane
    Aug 25, 2007
Loading...

Share This Page