473,322 Members | 1,703 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

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 1450
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Mark | last post by:
I know that DB2 LUW version 8 has "connection pooling" that provides a connection concentrator (limits the number of simultaneous connections that can occur). But does it really provide connection...
0
by: Mark Blacks | last post by:
I'm using the connection concentrator with db2 v8.2 on AIX 52 with this configuration: max_connections = 4000 maxagents = max_coordagents = num_poolagents = 600 num_initagents = 100 maxcagents...
2
by: Jean-Marc Blaise | last post by:
Hi, The Information Center (V8 FP4) states that "Each SQL statement must explicitly indicate the Connection Context object, and that context must be explicitly instantiated in the Java method"...
18
by: Rob Nicholson | last post by:
We're getting an occasional occurrence of the following error when two users try and open the same record in our ASP.NET app: "There is already an open DataReader associated with this Connection...
5
by: Suresh | last post by:
Hi Guys I have Db2 server installed on remote server. i am connecting to that remote server by using VPN. I want to connect that remote DB2 server instance using my local machine DB2...
7
by: Frank Rizzo | last post by:
Hello, I have a 32-bit .net 1.1 service that spawns many different threads and, in general, does a lot of processing. Up to now, it's been working on Win2003 32-bit servers fairly well against...
1
by: Laurence | last post by:
Hi all, Does connection concentroator only support in DRDA environment? Thanks in advance, Laurence
1
by: s_valmont | last post by:
Just wondering if anyone's heard of this issue. It relates to accessing an Oracle 9i database from ASP.NET 1.1. The first time you do this (e.g., run a sproc) it works fine. However doing this...
1
by: wpellett | last post by:
I have the DB2 Connection Concentrator enabled (DB2 V9.1) on a system with very limited memory resources. Does anyone know if the db2evmg, db2taskd, and db2stmm processes count toward the...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.