When do connections get dropped? 
Author Message
 When do connections get dropped?
DB2 UDB 7.2 WE
Linux

If I use CLP to make a DB connection, and then fail to do a
CONNECT RESET and a TERMINATE, how long does the connection
last?  Will DB2 eventually cut it?  Is there an ADMIN, DBM, or
DB cfg param that controls this?

TIA

Allen



Mon, 18 Jul 2005 03:50:13 GMT
 When do connections get dropped?

     Hi Allen,
You can use the db2 governor to force idle connections, checkout the
Admin Guide, Governor chapter.

Hope this helps,
Dave.

Quote:

>DB2 UDB 7.2 WE
>Linux

>If I use CLP to make a DB connection, and then fail to do a
>CONNECT RESET and a TERMINATE, how long does the connection
>last?  Will DB2 eventually cut it?  Is there an ADMIN, DBM, or
>DB cfg param that controls this?

>TIA

>Allen



Mon, 18 Jul 2005 05:58:59 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. ADO Connection Gets Dropped - Help Needed

2. Doing a drag and drop - HELP

3. SQL DBNETLIB drops connection on 28800 connections.

4. Getting things done in OLAP

5. While doing Bulk insert temp is getting full

6. DAO3.60 - getting error 3260 when doing CDaoRecordset::Update

7. prompting user, getting table name, doing things

8. Pictures of my sister getting her hair done - New Web Site

9. Getting identity when doing insert in VB.NET

10. ERWin temporary tables / not getting dropped

11. ---Source DB getting DROPPED when using Transfer DB function---


 
Powered by phpBB® Forum Software