How the connection concentrator works?
连接集中器的工作原理。
Connection concentrator (transaction pooling).
连接集中器(事务池)。
See the behavior of the connection concentrator.
参见连接集中器的行为。
Must connection pooling be on with concentrator enabled?
启用连接集中器必须将连接池打开?
Databases for which the connection concentrator is enabled.
支持连接集中器的数据库。
The connection concentrator is a feature that is unique to DB2 connect.
连接集中器(connectionconcentrator)是DB 2connect特有的一个功能。
WebSphere ACTS as a connection concentrator in front of the database server.
WebSphere作为数据库服务器前面的一个连接集线器。
The connection concentrator is associated with context switching of agents.
连接集中器与代理的上下文切换相关联。
Connection concentrator ACTS upon transaction boundaries (commit and rollback).
连接集中器的工作取决于事务边界(提交和回滚)。
What happens if the parameters aren't set properly when the concentrator is enabled?
如果在启用了连接集中器时参数没有设置正确会怎么样呢?
In a connection concentrator scenario, agents are spawned only when needed for transactions.
在连接集中器场景中,只有在事务需要时才产生代理。
Note: connection concentrator is enabled when max_connections is greater than max_coordagents.
注意:当max_connections的值大于max_coordagents的值时,连接集中器便被启用。
Connection concentrator helps reduce the resources each agent allocates when the connection is idle.
连接集中器有助于减少当连接空闲时每个代理分配的资源。
Set the following parameters in the database manager configuration to enable the connection concentrator
在数据库管理器配置中设置以下参数以启用连接集中器
When both the INTRA_PARALLEL parameter is OFF and the concentrator is disabled, all sorts are private.
当 INTRA_PARALLEL参数是OFF,并且禁用集中器(concentrator)时,所有的排序就都是私有的。
The statement concentrator looks for SQL statements that look exactly the same except for their parameter values.
语句集中器寻找除参数值之外完全相同的sql语句。
With the connection concentrator enabled, the database agent is "hot" only for the duration of an SQL transaction.
一旦启用了连接集中器,数据库代理就只在SQL事务期间是“热的”。
By default the max_connections parameter is equal to max_coordagents and the connection concentrator is not enabled.
默认情况下,max_connections参数等于max_coordagents,因而连接集中器是不启用的。
If you cannot correct this problem, then your environment is not suitable for the use of the connection concentrator.
如果您不能纠正这个问题,那么您的环境就不适合于使用连接集中器。
The value of max_connections must be greater than the value of max_coordagents to turn on the connection concentrator.
max_connections的值必须大于max_coordagents的值,以打开连接集中器。
Thus, this high water mark number is roughly how many agents you need simultaneously at peak when the concentrator is on.
因此,这个最高数字基本上就是在启用连接集中器时您同时需要的最大代理数。
A frequent question about the connection concentrator is, "What's a good value to set for max_connections and max_coordagents?"
有关连接集中器的一个常见问题是,“将max_connections和max_coordagents设为多大才最好?”
With connection concentrator enabled, upon reaching transaction boundaries, the db2agent is free and ready to service other requests.
启用了连接集中器之后,一旦到达事务边界,db2agent就是自由的,可以服务于其他请求。
The connection concentrator function in DB2 connect on the other hand does not require an application disconnect for the resources to be reused.
而DB 2Connect中的连接集中器功能不要求应用程序断开连接就可以实现资源重用。
The connection concentrator allows users to appear connected to the database while the actual database agent is free to service incoming requests.
连接集中器允许用户看起来是连接到数据库的,而实际的数据库代理仍然可以服务入站请求。
DB2 UDB V7 clients cannot take advantage of the DB2 UDB V8 connection concentrator, which only works with V8 clients and local V8 server connections.
DB 2UDBV7客户机不能利用DB 2 UDBV 8连接集中器的优势,它只对V8客户机和本地V 8服务器连接起作用。
With the statement concentrator feature, DB2 9.7 now compiles the statement only once to obtain the access plan for the statement, and then reuses it.
现在有了语句集中器特性,DB 2 9.7只编译一次语句就可获得访问计划,然后重用它即可。
This indicates the highest number of agents that existed at any point during the entire time since your instance was started with concentrator enabled.
这表示自您的实例以启用连接集中器开始以来的所有时间点上存在的最大代理数。
This indicates the highest number of agents that existed at any point during the entire time since your instance was started with concentrator enabled.
这表示自您的实例以启用连接集中器开始以来的所有时间点上存在的最大代理数。
应用推荐