The accounting reports show the number of GETPAGES and synchronous reads per buffer pool.
会计报表显示对应于每个缓冲池的GETPAGES和同步读的数量。
Database records are read and updated in the buffer pool area of memory.
数据库记录是在内存的缓冲池区域里被读取和更新的。
Subsequent users may often find some of these resources in the buffer pool.
随后的用户则常常可以发现有些资源已经在缓冲池中。
This provides a means to exploit the various thresholds to favor certain types of data access within a buffer pool.
这为利用各种阈值处理缓冲池中某些类型的数据访问提供了一种方法。
Memory impacts the number of client connections and the size of the buffer pool and database cache allocated by the server.
内存影响客户端连接的数量、缓冲池的大小,以及服务器分配的数据库缓存的大小。
Rather, the page size for tables is determined by the page size of the buffer pool to which the table space containing the table is assigned.
相反,表的页宽是由相应的缓冲池的页宽来确定的,这个缓冲池也就是为包含该表的表空间所指定的缓冲池。
Buffer pool occupies the largest part of resident portion.
缓冲池占用了常驻区中最大的部分。
You can use the snapshot report to derive information such as the buffer pool hit ratio, amount of sort heap overflows, and the system workload.
您可以使用快照来获得诸如缓冲池命中率、排序堆溢出的次数以及系统工作负载之类的信息。
Information about system configuration can include the size of the buffer pool, the sort heap, and more.
关于系统配置的信息包括缓冲池的大小、排序堆的大小等等。
This finding demonstrates the effect of concurrent transactions on the buffer pool and how changes in the buffer pool affect server performance.
这个结果演示了并发事务对缓冲池的影响,以及缓冲池的大小如何影响服务器的性能。
Tune the federated system for local processing in the areas of application heap, statement heap, buffer pool, sort heap, and temp tablespace.
为应用程序堆、语句堆、缓冲池和临时表空间这些区域中的本地处理调优联邦系统。
A buffer pool is an area of storage in memory into which database pages (containing table rows or index entries) are temporarily read and changed.
缓冲池是内存中的一块存储区域,用于临时读入和更改数据库页(包含表行或索引项)。
This parameter determines the threshold percentage of dirty pages in the buffer pool at which page cleaning will be initiated.
这个参数决定缓冲池中脏页的阈值百分比,当脏页达到这个百分比时,就会启动页清除。
With the bigger buffer pool of 12000 4k pages, the performance result improves from 43 completed transactions per 10 seconds to 66 completed transactions, as shown in Figure 4.
通过12000个4K页面的更大缓冲池,性能结果从每10秒完成43个事务增加到完成66个事务,如图4中所示。
For applications that only use one buffer pool, change NPAGES to -1 so that BUFFPAGE controls the size of the buffer pool.
对于仅使用一个缓冲池的应用程序,将NPAGES更改成-1,这样BUFFPAGE就可以控制该缓冲池的大小。
A database must have at least one buffer pool, and can have a number of buffer pools depending on the workload characteristics, database page sizes used in the database, etc.
一个数据库必须至少有一个缓冲池,并且可以有多个缓冲池,这要视工作负载的特征、数据库中使用的数据库页面大小等因素而定。
The designation of buffer pool sizes is dependent upon the amount of storage (both central and expanded) that is available.
缓冲池大小的指定要取决于可用存储(包括中央存储和扩展存储)的容量。
This setting controls the size of the NSF buffer pool, a section of memory dedicated to buffering I/O transfers between the NIF indexing functions and disk storage.
这个设置控制NSF缓冲池的大小,后者是用于缓冲NIF索引函数与磁盘存储之间的I/O传输的一部分内存。
A database must have at least one buffer pool, and can have a number of buffer pools depending on such things as the workload characteristics and database page sizes used in the database.
一个数据库必须至少有一个缓冲池,并且可以有多个缓冲池,具体要视工作负载的特征、数据库中使用的数据库页面大小等因素而定。
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%的糟糕的缓冲池命中率。
During the test run, the actual amount of buffer pool used did not exceed 1 GB, even though the amount that the server could use was significantly above that.
在测试运行期间,实际使用的缓冲池不超过1GB,尽管服务器可以使用的大小远远超过这个数值。
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参数控制的。
The figures that follow show the effect of buffer pool size when the amount of concurrency was increased with smaller databases.
下图演示当小型数据库的并发性上升时,缓冲池的大小产生的影响。
For example, a table space with an 8kb page size can only use a buffer pool with page size of 8kb.
例如,页面大小为8kb的表空间只能使用页面大小为8kb的缓冲池。
If the hit ratio is low, increasing the number of buffer pool pages may improve performance.
如果命中率较低,则可以增加缓冲池页数来提高性能。
Note that the page sizes of 8K for the buffer pool and table space are the same.
请注意,缓冲池和表空间的页大小都是8K,两者是相同的。
When multiple buffer pools are in use, the buffer pool snapshot data can be used to calculate the buffer pool hit ratio of each pool to indicate the effectiveness of each buffer pool.
当多个缓冲池同时在用时,缓冲池快照数据可用于计算每个缓冲池的命中率,来表示每个缓冲池的有效性。
The goal of buffer pool tuning is to help DB2 make the best possible use of the memory available for buffers.
缓冲池调优的目标是帮助DB 2尽可能好地利用可用于缓冲区的内存。
Thus the number of concurrent transactions was relatively low. Because of that, the net effect of having more buffer pool was limited.
因此并发事务比较少,这又进一步限制了更大的缓冲池的实际影响。
It is mentioned earlier that ESTORE is used to extend the size of a buffer pool.
前面已提到,ESTORE是用于扩展缓冲池的大小。
应用推荐