The limit for database shared memory is around 3.5GB.
数据库共享内存的限制大约是 3.5GB。
The database shared memory, in green, starts at 0x50000000.
绿色是数据库共享内存,始于0x50000000。
These limits dictate how we configure each of the memory pools in the database shared memory set.
这些限制规定了我们该如何配置数据库共享内存集中的每个内存池。
The database buffer pool(s) area is normally the largest component of the database shared memory.
数据库缓冲池通常是数据库共享内存中最大的一块内存。
This forces DB2 to use segment E for local connections, thus freeing one segment for database shared memory.
这样便迫使DB2将段E用于本地连接,从而为数据库共享内存空出一个段。
Segments 4 to B -The database shared memory starts at segment 4 and the segments must be attached contiguously.
段4到段B-数据库共享内存始于段 4,这些段必须紧挨在一起。
This will allow an additional 500 MB of memory available for database shared memory, pushing total utilization slightly above 2 GB to about 2.2 GB.
这样可以为数据库共享内存增加 500MB的可用内存,从而使内存使用总量从2GB 多一点儿增加到 2.2 GB。
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.
注意,日志缓冲区位于数据库的共享内存中,这种机制确保每个事务被记录到日志文件中。
There is one database Shared memory set per database.
每个数据库有一个数据库共享内存集。
By default, the database Shared memory is 1.75gb minus the Stack.
在默认情况下,数据库共享内存的大小是1.75GB减去堆栈大小。
Use the formula given earlier to calculate the database Shared memory.
可以使用前面给出的公式来计算数据库共享内存。
This article explains instance Shared memory and database Shared memory.
本文将介绍实例共享内存和数据库共享内存。
It is important that the database Shared memory and stack do not collide.
使数据库共享内存和堆栈不发生冲突,这一点很重要。
Potentially, all 8 segments (2 GB) can be used for database Shared memory.
所有这8个段(2gb)可能都被用于数据库共享内存。
These resources are found within the database Shared memory (See Figure 1).
这些资源在数据库共享内存中(参见图1)。
Figure 2 shows the various memory pools within the database Shared memory set.
图2展示了数据库共享内存集内的各种内存池。
The instance Shared memory and database Shared memory combined is around 3.7gb.
实例共享内存和数据库共享内存合起来大约是3.7GB。
This leaves more room for other memory sets such as the database Shared memory.
这样就将更多的空间留给了其他内存集,例如数据库共享内存。
The application group memory set is allocated from the database Shared memory set.
应用程序组内存集是从数据库共享内存集中分配的。
However, keep in mind that buffer pools are part of the database Shared memory set.
但是请记住,缓冲池是数据库共享内存集中的一部分。
The database Shared memory (including buffer pools) starts at 0x50000000 (default).
数据库共享内存(包括缓冲池)始于0x50000000(默认值)。
Limit: In this configuration, the limit for database Shared memory is 2gb, or 8 segments.
限制:在此配置中,对于数据库共享内存的限制是2gb或8个段。
Total database Shared memory (controlled by the database_memory configuration parameter).
总体数据库共享内存(由database_memory配置参数控制)。
Note: On 32-bit Solaris, we normally limit the DB2 database Shared memory to around 3.5gb.
注意:在32位Solaris中,我们通常将DB 2数据库共享内存限制在大约3.5GB。
For example, the locklist is a memory pool that belongs to the database Shared memory set.
例如,locklist是属于数据库共享内存集的一个内存池。
For example, the lock list is a memory pool that belongs to the database Shared memory set.
例如,locklist是属于数据库共享内存集的一个内存池。
Failure to initialize the database Shared memory properly results in the following problems.
初始化数据库共享内存失败可能产生如下问题。
If ESTORE is enabled, then it will take another segment away from the database Shared memory.
如果启用了ESTORE,那么还要从数据库共享内存中拿出另一个段。
Database Shared memory is allocated when a database is activated or connected to for the first time.
数据库共享内存是在数据库被激活或者第一次被连接上的时候分配的。
Problem: the database Shared memory is 1.66gb; it is less then the 3.35gb database Shared memory limit.
问题:数据库共享内存是1.66GB。这个数小于3.35 GB的数据库共享内存限制。
应用推荐