By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,779 Members | 1,111 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,779 IT Pros & Developers. It's quick & easy.

How expensive are idle connections?

P: n/a
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
Share this Question
Share on Google+
4 Replies


P: n/a
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

P: n/a

"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

P: n/a
"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

P: n/a
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.