Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2003
    Location
    Hamburg, Germany
    Posts
    38

    Unanswered: Cannot connect to online server

    From time to time, we get an error when trying to connect over TCP/IP or shared memory and a db connection (any db in the installation) is refused. Users who already have a db connection are not affected, but new connections are not allowed. If one of the connected users exits dbaccess (for example), then another user who was previously denied access can now get access. It works on 1-1 basis at this point - 1 user disconnects and another can connect. The error returned by informix is..

    No space left on device annot connect to Dynamic Server 2000 ifx62.

    I look at disk space and make db consistency checks etc and nothing shows as a problem. There are no error messages in informix logs, only to screen at time of attempted connect.

    We have Informix Dynamic Server 2000 Version 9.21.HC3 on HP-UX 11.0. Rebooting seems to fix the problem fo a short while, but does not give permanent fix.

    What is limiting the connections? What other information do you need from me to help?

    You can see our onconfig attached.

    Any help you can give is appreciated.
    Thanks
    Adi
    Attached Files Attached Files

  2. #2
    Join Date
    Jun 2003
    Location
    Hamburg, Germany
    Posts
    38
    Maybe it helps to tell you how many concurrent users we have.

    Today we have the problem, and we have 15 connected users. Other times I have seen the problem with something like 6 or 7 connected users. That is to say, there is no absolute concurrent user limit that I can see that starts the problem. Sometimes it happens with very few users, other times with more.

  3. #3
    Join Date
    Aug 2002
    Location
    Bonn/Germany
    Posts
    152
    Check the informix releasenotes and make sure
    that your kernel parameters are configured
    properly.

    Especially on HP I remember the Parameters
    SEMMNU/SEMMNI which might limit the
    number of connections to your databaseserver
    (at least for shared-memory 'onipcshm' connections).

    Also set the NETTYPE parameter in your $ONCONFIG
    appropriately. This is absolutey necessary for
    shared memory connections, otherwise you are limited
    to around 50 connections.

    NETTYPE ipcshm,1,200,CPU

    With this entry Informix would start one pool thread
    for shared memory connections on a CPU VP
    which will be able to accept about 200 connections.

    Best regards

    Eric
    --
    IT-Consulting Herber
    WWW: http://www.herber-consulting.de
    Email: eric@herber-consulting.de

    ***********************************************
    Download the IFMX Database-Monitor for free at:
    http://www.herber-consulting.de/BusyBee
    ***********************************************

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •