Results 1 to 9 of 9
  1. #1
    Join Date
    Jan 2005
    Posts
    5

    Unanswered: INFORMIX server getting hanged quite often

    Hi friends,

    We are currently using Informix Dynamic Server V- 7.30 UC2 on ScoUnix-5.

    I am getting frequent Informix hangs on our server, message in the online log
    shows error No. 27001.

    listener thread: err -27001 oserr = 0; errstr = : Read error occured during connection attempt.

    After restarting the server, its back to normal. We have about 50-60 users
    working in INFORMIX. The maximum no of concurrent users is 102.

    In the config file the NETTYPE lines are
    NETTYPE tlitcp, 1,50, NET
    NETTYPE ipcshm,1,50,CPU

    Hope anybody of you can help me out to solve this issue, please.

    Thanks,

    Sara Jose

  2. #2
    Join Date
    Mar 2004
    Location
    Netherlands
    Posts
    183
    Hi Sara,

    You have specified for each protocol 1 listener thread and 50 connections for every listerner thread. You can try increasing both protocols to 100 connections/thread (change 50 into 100 in NETTYPE parameters).
    I've seen several cases where this did the job....

    Greetz,

    Rob

  3. #3
    Join Date
    Jan 2005
    Posts
    5
    Hi Rob,

    Thanks for the advice, I have changed both the partameters to 100 now.
    So let me see, hope this connection limitation was my issue. I will post you about my status.

    Can you pls brief me little more on this parameters, that 50 connection/
    thread means only that many users can connect to informix at a time, or about the concurrent users sessions using the server.

    Thanks

    Sara

  4. #4
    Join Date
    Mar 2004
    Location
    Netherlands
    Posts
    183
    Hi sara,

    It is the number of sessiosn that can be serviced by this protocol. Normally a listenerthread can support 150 concurrent ransaction without any problem. If you have more usesr you can specify more threads.

    Hope this helps,

    Rob

  5. #5
    Join Date
    Jan 2005
    Posts
    5

    Idleout

    Hi Rob,

    Thank you very much for ur prmpt reply.

    Will it be advisable if I am setting the 'idleout' time to 120 sec, since in our case, some of the users keeps two/three INFORMIX logins open and then leave it idle after their use. Shall I force them out, so that I can maintain the concurrent users numbers within the limit. Will this have any negative effect on INFORMIX.

    Please advise.

    Thanks,

    Sara

  6. #6
    Join Date
    Mar 2004
    Location
    Netherlands
    Posts
    183

    Smile

    Hi Sara,

    There are two issues involved. I tries to set a plus (+) for positive and a minus (-) for megative effects:

    * Close long open standing connections
    + Keep number of connections low and stay within license (if user based)
    - Does application handle this, or get users error message?
    - Time spent reconnecting

    * Keep connections open
    - Higher chance on beaking your license (if user based)
    * Keeping connections open is almost no overhead for IDS. IDS works
    with a central listener thread and only wake up threads (connections)
    that request work to be done.

    Hope this helps,

    Rob

  7. #7
    Join Date
    Jan 2005
    Posts
    5

    Server hanged after 7 days with error (-27001)

    Hi friends,

    Sorry to trouble you, I am again seeking help with the listener thread error
    -27001 .

    As suggested in our previous thread, I have modified the config file with the
    nettype parameters (from 50 each)
    NETTYPE tlitcp 1,100, NET
    NETTYPE ipcshm, 1,100, CPU

    Our system was running perfectly with 1 or 2 restart in between, today after 7 days of continous running Server got hanged. The maximum concurrent users had reach 104 and active users at the time of hanging was 85. Do you feel I need to increase the no of connections per thread to 150 now. I have 50 - 60 users working in the system.

    Please advise.

    Thanks a lot in advance

    Sara

  8. #8
    Join Date
    Mar 2004
    Location
    Netherlands
    Posts
    183
    Hi Sara,

    Can you post (or email me personally at rpdba@xs4all.nl) the full onconfig file of your system (onstat -c) and can you give a small situation report on your system (tyep of machine, brand, os version, number of CPU's and how most users connect (tcp/shm). Best way of knowing the last is giving the command: onstat -g ath | grep sqlexec. It will then then either sm_read (shm) or netnorm (tcp).

    If you can send me this info I hope I can give you a correct answer.

    Greetings,

    Rob

  9. #9
    Join Date
    Feb 2005
    Posts
    1
    Hi there

    i had the same problem, the sistem hung every time it reached 104 connections.
    I solved in this way:
    NETTYPE tlitcp,5,100, NET

    David Ciprian

Posting Permissions

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