Unix Technical Forum

CPU usage in connection concentrator

This is a discussion on CPU usage in connection concentrator within the DB2 forums, part of the Database Server Software category; --> I'm using the connection concentrator with db2 v8.2 on AIX 52 with this configuration: max_connections = 4000 maxagents = ...


Go Back   Unix Technical Forum > Database Server Software > DB2

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-27-2008, 01:52 AM
Mark Blacks
 
Posts: n/a
Default CPU usage in connection concentrator

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 = max_coordagents
intra_parallel = yes, but default degree is 1

the average number of applications connected to the database is about
1500. these applications do very short transactions and many file transfer
so
that most of the time they are decoupled.

the only problem I noticed is that the 3 db2disp processes allocates use
more or less one cpu each... Power4+ 1.1 Ghz (regatta, p690).

another info is the number of "agent stolen from other applications" that is
about 150~200 per second.

is there any doc or suggestion I can use to understand how to limit the CPU
usage,
or a better configuration?

thanks in advance,
marco
---
Marco Negri, I.NET s.p.a +39 02 32863 ext 1


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 09:06 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com