Results 1 to 8 of 8
  1. #1
    Join Date
    Oct 2001
    Location
    England
    Posts
    426

    Unanswered: data studio disconnects after inactivity

    We are using Data Studio v2.2 on windows to connect to DB2 v9.5 on Linux .
    After a while without use this disconnects and drops any temporary tables.
    I's causing some users a lot of dificulty.

    Is there any way of preventing or extending this disconnect?
    Is it controlled from the client?

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    My guess is that your connection is being dropped without your knowledge. This can be controlled from the server. What is the output of: "cat /proc/sys/net/ipv4/tcp_keepalive_time"?

    Andy

  3. #3
    Join Date
    Oct 2001
    Location
    England
    Posts
    426
    Quote Originally Posted by ARWinner View Post
    My guess is that your connection is being dropped without your knowledge. This can be controlled from the server. What is the output of: "cat /proc/sys/net/ipv4/tcp_keepalive_time"?

    Andy
    Thanks
    Would that be on the DB2 server which I don't have access to - onlt via a database connection.

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Yes it would.

    Andy

  5. #5
    Join Date
    Oct 2001
    Location
    England
    Posts
    426
    Got someone to look and he says
    /proc/sys/net doesn't exist
    /proc/sys does.

  6. #6
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    What flavor of linux is it?

    Andy

  7. #7
    Join Date
    Oct 2001
    Location
    England
    Posts
    426
    I'm told it's
    SUSE Linux Enterprise Server 10 SP1 (x86_64)

    thanks.

  8. #8
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Sorry, I do not know anything about SUSE. Have them figure out what the keepalive_time is for the system.

    Andy

Posting Permissions

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