缓冲池操作。
Db2pclnr: For buffer pool page cleaners.
db2pclnr:缓冲池页面清除程序。
Number of table spaces using the buffer pool
使用缓冲池的表空间数
This allows buffer pool caching to take place.
这允许发生缓冲池的缓存。
Each database requires at least one buffer pool.
每个数据库都至少需要一个缓冲池。
In this example, the buffer pool cluster was used.
本例使用了缓冲池集群。
DB2 reserves a slot in the buffer pool for the page.
DB 2在用于该页的缓冲池中预留一个位置。
Buffer pool occupies the largest part of resident portion.
缓冲池占用了常驻区中最大的部分。
The buffer pool hit ratio is now showing excellent results.
现在的缓冲池命中率就显示了较好的结果。
This requires the appropriate index pages to be in the buffer pool.
这要求在缓冲池中存在适当的索引页。
Create DB2 database, buffer pool, and tablespace with more than 4k.
创建DB 2数据库、缓冲池和表空间,使用大于4k的页面大小。
In this case, we will trace only the buffer pool services component.
在本例中,我们将只跟踪缓冲池服务组件。
Database records are read and updated in the buffer pool area of memory.
数据库记录是在内存的缓冲池区域里被读取和更新的。
For other platforms, the buffer pool size is 250 pages with a 4k pagesize.
而在其他平台上,缓冲池大小为250个页大小为4k的页。
Subsequent users may often find some of these resources in the buffer pool.
随后的用户则常常可以发现有些资源已经在缓冲池中。
You can filter on buffer pool name, partition number, and other properties.
您可以根据缓冲池名称、分区编号和其他属性进行过滤。
Buffer pool contention can be a significant factor in database performance.
缓冲池竞争可以成为数据库性能中的重要因素。
It then scans each record in the buffer pool to apply the stage-1 predicate.
然后其在缓冲池上扫描每一条记录以便应用阶段1谓词。
This means they use the same page size and are buffered in the same buffer pool.
这意味着它们将使用相同的页宽并在同一个缓冲池中进行缓冲。
Buffer pool data writes is much greater than Asynchronous pool data page writes.
缓冲池数据写远远大于异步池数据页写。
These types of columns are unique in that they are not cached in the buffer pool.
这些类型的列是惟一的,它们不会缓存在缓冲池中。
Buffer pool index writes is much greater than Asynchronous pool index page writes.
缓冲池索引写远远大于异步池索引页写。
When a tablespace is created, it is assigned to the default buffer pool IBMDEFAULTBP.
在创建表空间的时候,会指派一个默认的缓冲池IBMDEFAULTBP。
Use one buffer pool, but increase its size until the index hit ratio stops increasing.
使用一个缓冲池,但是增加其大小直至索引命中率停止增长。
The accounting reports show the number of GETPAGES and synchronous reads per buffer pool.
会计报表显示对应于每个缓冲池的GETPAGES和同步读的数量。
We recommend you keep increasing the buffer pool size until you see diminishing improvements.
我们建议您不断增加缓冲池大小,直到看到不再有性能提高。
That means DB2 cannot start the database, because a database must have at least one buffer pool.
这意味着DB 2无法启动数据库,因为一个数据库至少必须有一个缓冲池。
This means that DB2 fetches every data page in the table space sequentially into the buffer pool.
这意味着DB2按顺序在表空间上提取每一个数据页面到缓冲池。
Where -l generates the DDL statements for tablespace, database partition, groups, and buffer pool.
在这里,- l创建了表空间、数据库分区、组和缓存池的ddl语句。
Besides the buffer pool, sort is another significant factor that impacts the database performance.
除了缓冲池,排序是影响数据库性能的另一重要因素。
应用推荐