Connection concentrator is enabled when you set max_connections greater than max_coordagents. By default this feature is not enabled and this feature helps in applications where there are many idle connection at any given point of time.For example, any webapplication that has lot of users connected to database but are not performing any table level transactions might be benifited by enabling connection concentrator.
Connection concentrator architecture is illustrated on the left.Db2dispatcher process is the key component in the architecture and it plays the role of multiplexing the agents.Any agent associated with an idleconnection might be used to service any connection in the queue.This feature helps in handling huge set of connections with limited agents thereby saving memory allocated.
Reference::http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0511lam/
No comments:
Post a Comment