How the connection concentrator works?
连接集中器的工作原理。
Connection concentrator (transaction pooling).
连接集中器(事务池)。
Must connection pooling be on with concentrator enabled?
启用连接集中器必须将连接池打开?
Databases for which the connection concentrator is enabled.
支持连接集中器的数据库。
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.
在连接集中器场景中,只有在事务需要时才产生代理。
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.
这表示自您的实例以启用连接集中器开始以来的所有时间点上存在的最大代理数。
If the database is partitioned, or intra-parallel enabled, or connection concentrator enabled, then one segment is used for Application Group Shared Memory.
如果数据库是分区的,或者启用了intra - parallel或连接集中器,那么数据库共享内存中有一个段被预留给应用程序组共享内存。
When the connection concentrator is enabled, max_connections limits the number of user connections, and max_coordagents limits the number of agents serving transactions.
当连接集中器是启用的时,max_connections限制用户连接的数量,max_coordagents 限制服务于事务的代理的数量。
This will create a large overhead of allocation and deallocation of agents upon reaching transaction boundaries, which defeats the purpose of the connection concentrator.
这样会导致到达事务边界时的代理分配和解除分配这一巨大开销,这会影响连接集中器的功能。
DB2 9.7 introduces the statement concentrator feature that improves the performance of programs that use dynamic SQL, and are developed in languages such as Ruby and PHP.
DB 2 9.7引入了语句集中器特性,提高了使用动态sql以及Ruby和php语言开发的程序的性能。
Without the statement concentrator feature, prior releases of DB2 would treat each statement in the above example as unique, and would compile and execute each statement separately.
由于没有语句集中器,DB2之前的版本需要单独处理上面例子中的每个语句,单独编译和执行每个语句。
应用推荐