Professional Web Applications Themes

db2 timeout? - IBM DB2

I have a UDB8 system on unix connecting to a db2 v6 system on os390. It seems like after long periods of inactivity the connection is invalidated in someway. Where would the possible settings be for the time the connection can stay idle but active? On the OS390 (if so whats the param name)? In the db2connect layer? Thanks Frank...

  1. #1

    Default db2 timeout?

    I have a UDB8 system on unix connecting to a db2 v6 system on os390. It
    seems like after long periods of inactivity the connection is invalidated in
    someway. Where would the possible settings be for the time the connection
    can stay idle but active? On the OS390 (if so whats the param name)? In the
    db2connect layer?

    Thanks
    Frank



    Frank Apap Guest

  2. #2

    Default Re: db2 timeout?

    I'm not a 390 expert, but if you're using TCPIP, consider the KEEPALIVE
    parameter - search on KEEPALIVE here:

    [url]http://publib.boulder.ibm.com/infocenter/db2help/index.jsp[/url]

    Frank Apap wrote:
    > I have a UDB8 system on unix connecting to a db2 v6 system on os390. It
    > seems like after long periods of inactivity the connection is invalidated in
    > someway. Where would the possible settings be for the time the connection
    > can stay idle but active? On the OS390 (if so whats the param name)? In the
    > db2connect layer?
    >
    > Thanks
    > Frank
    >
    >
    >
    Blair Adamache Guest

  3. #3

    Default Re: db2 timeout?

    There are two option on OS390 that you have to adjust :

    1. Specify INACTIVE on the DDF THREADS field of installation panel
    DSNTIPR to allow threads to become inactive.

    2. Specify IDLE THREAD TIMEOUT period between 0 and 9999 seconds.
    Active server threads that have remained idle for a specified period
    of time (in seconds) can be canceled by DB2. A value of 0, the
    default, means that the server threads cannot be canceled because of
    an idle thread timeout. It is advisible to use this option in
    conjunction with INACTIVE for the DDF THREADS field on DSNTIPR.

    3. For TCP/IP connections, it is a good idea to specify the IDLE
    THREAD TIMEOUT value in conjunction with a TCP/IP keep_alive interval
    of 5 minutes or less to make sure that resources are not locked for a
    long time when a network outage occurs.

    Blair Adamache <> wrote in message news:<bko44p$k9v$torolab.ibm.com>... [/ref]
    Chinmay Guest

Similar Threads

  1. #40750 [NEW]: fsockopen timeout parameter overwrites timeout for reading
    By andreas dot rieber at 2e-systems dot com in forum PHP Bugs
    Replies: 14
    Last Post: March 14th, 07:22 PM
  2. cfquery, timeout attribute and cfserver timeout setting
    By Telix in forum Coldfusion - Advanced Techniques
    Replies: 1
    Last Post: July 1st, 03:42 PM
  3. Replies: 3
    Last Post: April 29th, 02:21 AM
  4. Timeout sometimes runs past the timeout length
    By Stuart in forum Macromedia Director Lingo
    Replies: 1
    Last Post: August 20th, 04:28 PM
  5. Replies: 0
    Last Post: August 7th, 12:52 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139