468,140 Members | 1,613 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,140 developers. It's quick & easy.

How expensive are idle connections?

Hello,

Some of our SAS users seem to initiate 20+ idle connections to DB2 every
time they start SAS. I'm inclined to tell them to cut down on their DB2
connection number, but then again, if the connections are very cheap why
bother.

Are idle DB2 connections cheap, from the DBMS' point of view?

(I fear that there's no easy answer to this question, but maybe someone
can comment on it.)

--
Regards,
Troels Arvin <tr****@arvin.dk>
http://troels.arvin.dk/
Jan 29 '07 #1
4 2016
I think it is because SAS is trying to do a connection pool.
How many application y have ? What is your max agent defined?
A connection will use around 2MB from the server side based on your
configuration about the agent.

On Jan 29, 9:01 am, Troels Arvin <tro...@arvin.dkwrote:
Hello,

Some of our SAS users seem to initiate 20+ idle connections to DB2 every
time they start SAS. I'm inclined to tell them to cut down on their DB2
connection number, but then again, if the connections are very cheap why
bother.

Are idle DB2 connections cheap, from the DBMS' point of view?

(I fear that there's no easy answer to this question, but maybe someone
can comment on it.)

--
Regards,
Troels Arvin <tro...@arvin.dk>http://troels.arvin.dk/
Jan 29 '07 #2

"Troels Arvin" <tr****@arvin.dkwrote in message
news:ep**********@news.net.uni-c.dk...
Hello,

Some of our SAS users seem to initiate 20+ idle connections to DB2 every
time they start SAS. I'm inclined to tell them to cut down on their DB2
connection number, but then again, if the connections are very cheap why
bother.

Are idle DB2 connections cheap, from the DBMS' point of view?

(I fear that there's no easy answer to this question, but maybe someone
can comment on it.)

--
Regards,
Troels Arvin <tr****@arvin.dk>
http://troels.arvin.dk/

Jan 29 '07 #3
"Troels Arvin" <tr****@arvin.dkwrote in message
news:ep**********@news.net.uni-c.dk...
Hello,

Some of our SAS users seem to initiate 20+ idle connections to DB2 every
time they start SAS. I'm inclined to tell them to cut down on their DB2
connection number, but then again, if the connections are very cheap why
bother.

Are idle DB2 connections cheap, from the DBMS' point of view?

(I fear that there's no easy answer to this question, but maybe someone
can comment on it.)

--
Regards,
It is basically a memory issue. But 20 connections should not be a problem
in most cases. The default for a new instance is 400 agents (there is
usually one agent per connection unless queries or utilities are using
parallelism).
Jan 29 '07 #4
On Mon, 29 Jan 2007 06:58:45 -0800, shenanwei wrote:
I think it is because SAS is trying to do a connection pool.
OK; then, it obviously fails ;-)
I wonder if anyone here has pointers to good documents about the SAS+DB2
combination, perhaps including how SAS can be told to pool database
connections between several LIBNAMEs which use a common database?
How many application y have ? What is your max agent defined?
The other day, we hit our maximum of 400 connections; probably because
some users' SAS created 22 idle database connections to the same database
simply by starting SAS (not doing any analysis work at all).
A connection will use around 2MB from the server side based on your
configuration about the agent.
OK, thanks. Now, at least, I have a figure to calculate with.

--
Regards,
Troels Arvin <tr****@arvin.dk>
http://troels.arvin.dk/
Jan 30 '07 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by M Wells | last post: by
3 posts views Thread by Brent W. Hughes | last post: by
1 post views Thread by John Gibson | last post: by
reply views Thread by Stefan Felkel | last post: by
1 post views Thread by CSN | last post: by
4 posts views Thread by Josh Close | last post: by
1 post views Thread by Praveen_db2 | last post: by
4 posts views Thread by gnewsgroup | last post: by
1 post views Thread by gcdp | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.