469,366 Members | 1,822 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

Connection Concentrator causes slowdowns in db2 v9

I have run into a performance problem with db2 v9. When the connection
concentrator is turned on then
performance is significantly reduced. I did some simple insert tests,
75 records inserted into a table with 50 Varchar(20) and 4 CLOBs. The
results were as follows:

Connection Concentrator on db2 v8.2 ~1s
Connection concentrator off db2 v8.2 ~1s
Connection Contentrator on db2 v9.1 ~8s
Connection Concentrator off db2 v9.1 ~1s

I was wondering if anybody else has seen similar behaviour? I have done
numerous other tests with different datatypes, using the CLP, and a
JDBC application with similar results. To me it looks like there is a
bug in the Connection Concentrator on db2 v9.1.... Can anybody confirm
this?

Nov 23 '06 #1
1 1370
Otto Carl Marte wrote:
was wondering if anybody else has seen similar behaviour? I have done
numerous other tests with different datatypes, using the CLP, and a
JDBC application with similar results. To me it looks like there is a
bug in the Connection Concentrator on db2 v9.1.... Can anybody confirm
this?
I haven't heard anything. Then again this isn't an area where I keep a
pulse. Maybe worth a PMR.

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

WAIUG Conference
http://www.iiug.org/waiug/present/Fo...Forum2006.html
Nov 23 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Mark | last post: by
reply views Thread by Mark Blacks | last post: by
2 posts views Thread by Jean-Marc Blaise | last post: by
18 posts views Thread by Rob Nicholson | last post: by
7 posts views Thread by Frank Rizzo | last post: by
1 post views Thread by wpellett | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.