Increase the buffer pool size.
增加缓冲池大小。
Increase the buffer pool size online as follows.
联机增加缓冲池大小,如下。
To determine the buffer pool size in the database, take a look at Listing 3.
为了确定数据库中的缓冲池大小,请查看清单3。
What happens if you increase the buffer pool size to 20,000 4K pages and run PERFORMER again?
如果将缓冲池大小增加到 20,000 个4K页面并重新运行 PERFORMER,那将会发生什么情况呢?
We recommend you keep increasing the buffer pool size until you see diminishing improvements.
我们建议您不断增加缓冲池大小,直到看到不再有性能提高。
Another configuration parameter that dramatically affects performance is the database buffer pool size.
另一个极大影响性能的配置参数是数据库缓冲池大小。
(buffer pool size in the db2exfmt output is discussed further in the buffer pool size section below.).
db 2 exfmt输出中的缓冲池大小将在下面的缓冲池大小一节中进行进一步的讨论。
This makes it easier to update and report the buffer pool size along with other DB2 database configuration parameters.
这使得更新和报告缓冲池大小以及其它DB 2数据库配置参数变得更加方便。
With the buffer pool size of 250 pages, the application test run experienced very poor buffer pool hit ratio of 48.69%.
通过250个页面的缓冲池大小,应用程序测试运行呈现了48.69%的糟糕的缓冲池命中率。
The figures that follow show the effect of buffer pool size when the amount of concurrency was increased with smaller databases.
下图演示当小型数据库的并发性上升时,缓冲池的大小产生的影响。
Our second hypothesis was that specifying the buffer pool size affects memory utilization differently at various user loads (Test Case #2).
我们的第二个假设是指定缓冲池大小对内存利用率的影响因用户负载不同而不同(测试案例 #2)。
After making sure that you can use the BUFFPAGE parameter in the database configuration to control the buffer pool size, set it to a proper value.
确保可以使用数据库配置中的BUFFPAGE参数来控制缓冲池大小之后,将该参数设置成合适的值。
We can see from the figures that there appears to be a significant benefit to managing the buffer pool size when there's a high degree of concurrency.
从这些图可以看到,当并发性程度很高时,管理缓冲池的大小能够获得显著的性能提升。
If each buffer pool has an NPAGES value of -1, then the buffer pool size is being controlled through the BUFFPAGE parameter in the database configuration.
如果每个缓冲池都有一个为“-1”的npages值,那么缓冲池大小是由数据库配置中的BUFFPAGE参数控制的。
This is important information for you, as an administrator, because you control the buffer pool size specification and you can decide what size to specify.
这些信息对您很重要,因为作为一名管理员,您要控制缓冲池大小规格和决定要指定的缓冲池大小。
In fact, depending on the type of SQL performed by your application, increasing the buffer pool size over a certain limit may not improve performance any further.
实际上,取决于应用程序所执行的SQL的类型,将缓冲池的大小增加到某个极限之后就可能不会再提高性能了。
To take advantage of the increased buffer pool, you must rebind the applications for the optimizer to consider the buffer pool size when deciding its access strategy.
要利用增加的缓冲池,您必须重新绑定应用程序,以使优化器在决定其访问策略时考虑缓冲池大小。
To take advantage of the increased buffer pool, you must rebind the applications for the optimizer to consider the buffer pool size when deciding its access strategy.
要利用增加的缓冲池,您必须重新绑定应用程序,以使优化器在决定其访问策略时考虑缓冲池大小。
应用推荐