This paper introduces a buffer database access technology, and slow to resolve database access data buffer.
本文引入数据库缓冲访问技术,解决数据库访问慢和缓冲数据。
Database records are read and updated in the buffer pool area of memory.
数据库记录是在内存的缓冲池区域里被读取和更新的。
Each database requires at least one buffer pool.
每个数据库都至少需要一个缓冲池。
When you create a table space, you can associate it with a specific buffer pool (database cache) as well as to specific containers.
当创建表空间时,可以将它与特定的缓冲区池(数据库缓存)关联起来,并关联到特定的容器。
When you design buffer pools, you should consider the database memory requirements.
当您设计缓冲池时,您应该考虑数据库的内存需求。
Buffer pool contention can be a significant factor in database performance.
缓冲池竞争可以成为数据库性能中的重要因素。
Each DB2 database must have at least one single buffer pool.
每一个DB 2数据库都必须至少拥有一个缓冲池。
If the database is not started, you cannot connect to the database and change the buffer pool sizes.
如果数据库没有启动,那么就不能连接到数据库,也就不能更改缓冲池的大小。
The purpose of the buffer pool is to improve database system performance.
缓冲池的用途是为了提高数据库系统的性能。
Another configuration parameter that dramatically affects performance is the database buffer pool size.
另一个极大影响性能的配置参数是数据库缓冲池大小。
This is the layout for database partition groups, buffer pools and tablespaces.
这是用于数据库分区组、缓冲池和表空间的布局。
That means DB2 cannot start the database, because a database must have at least one buffer pool.
这意味着DB 2无法启动数据库,因为一个数据库至少必须有一个缓冲池。
Memory impacts the number of client connections and the size of the buffer pool and database cache allocated by the server.
内存影响客户端连接的数量、缓冲池的大小,以及服务器分配的数据库缓存的大小。
The log buffer size is defined by the LOGBUFSZ database parameter.
日志缓冲区大小是由LOGBUFSZ数据库参数定义的。
Compared to other memory buffers, buffer pools have the most significant impact on database performance.
与其他内存缓冲区相比,缓冲池对数据库性能的影响最为显著。
Where -l generates the DDL statements for tablespace, database partition, groups, and buffer pool.
在这里,- l创建了表空间、数据库分区、组和缓存池的ddl语句。
If this buffer size is exceeded, the database server discards saved data.
如果超过这个缓冲区大小,数据库服务器会丢弃保存的数据。
A buffer pool is associated with a single database, and can be used by more than one table space.
一个缓冲池是与单个数据库相关联的,可以被多个表空间使用。
Obviously, with availability of physical memory on the database server, a high buffer pool hit ratio is always better for your database performance.
显然,随着数据库服务器上物理内存的使用,高缓冲池命中率对于您的数据库性能而言始终比较好。
When increasing the value of the LOGBUFSZ parameter, you should also consider the DBHEAP parameter since the log buffer USES space from the database heap area.
在增加LOGBUFSZ参数的值时,您还应该考虑DBHEAP参数,因为日志缓冲区使用来自数据库堆区域中的空间。
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.
一个数据库必须至少有一个缓冲池,并且可以有多个缓冲池,这要视工作负载的特征、数据库中使用的数据库页面大小等因素而定。
However, keep in mind that buffer pools are part of the database Shared memory set.
但是请记住,缓冲池是数据库共享内存集中的一部分。
The size of the buffer is determined by the AUDIT_BUF_SZ database manager configuration parameter.
缓冲区的大小是由AUDIT _ BUF_SZ这个数据库管理器配置参数决定的。
All buffer pools are allocated when the database is activated.
而所有的缓冲池是在数据库被激活时被分配的。
Should the main buffer pools fail to start, DB2 will start the database with the small buffer pools.
这样,一旦主缓冲池无法启动,DB 2还可以使用这些小型的缓冲池来启动数据库。
The database buffer pool(s) area is normally the largest component of the database shared memory.
数据库缓冲池通常是数据库共享内存中最大的一块内存。
For example, the buffer pools and the database heaps are two separate memory pools within the database memory set.
例如,缓冲池和数据库堆是数据库内存集内的两个不同的内存池。
To determine the buffer pool size in the database, take a look at Listing 3.
为了确定数据库中的缓冲池大小,请查看清单3。
If your system is constrained on memory, you can reduce the size of buffer pools in the target database because the DB2 LOAD utility does not use buffer pools.
如果系统内存不充裕,那么可以减少目标数据库中缓冲池的大小,因为DB 2LOAD实用程序不使用缓冲池。
What essentially we can get away with is that log buffer located in database shared memory is the mechanism provided to ensure each transaction is logged to log files.
注意,日志缓冲区位于数据库的共享内存中,这种机制确保每个事务被记录到日志文件中。
应用推荐