Platform Instance Shared Memory Database Shared Memory Agent Private Memory.
平台实例共享内存数据库共享内存代理私有内存。
Limit: In this configuration, the limit for database Shared memory is 2gb, or 8 segments.
限制:在此配置中,对于数据库共享内存的限制是2gb或8个段。
These limits dictate how we configure each of the memory pools in the database shared memory set.
这些限制规定了我们该如何配置数据库共享内存集中的每个内存池。
This effectively frees up one segment for database Shared memory.
这将有效地为数据库共享内存一个段。
It is important that the database Shared memory and stack do not collide.
使数据库共享内存和堆栈不发生冲突,这一点很重要。
There is one database Shared memory set per database.
每个数据库有一个数据库共享内存集。
Application group Shared memory set is not listed because it is allocated from the database Shared memory set.
应用程序组共享内存集没有列出,因为它是从数据库共享内存集中分配的。
This is much less then any database Shared memory set available to other UNIX platforms.
这比其他UNIX平台上可用的任何数据库共享内存集要少得多。
This forces DB2 to use segment E for local connections, thus freeing one segment for database shared memory.
这样便迫使DB2将段E用于本地连接,从而为数据库共享内存空出一个段。
So far we have discussed the instance Shared memory, the database Shared memory, the application group Shared memory and the agent private memory.
至此,我们已经讨论了实例共享内存、数据库共享内存和应用程序组共享内存以及代理私有内存。
Since the end address of the instance Shared memory is not fixed, the starting address for the database Shared memory is not fixed either.
因为实例共享内存的结束地址不固定,所以数据库共享内存的起始地址也是不固定的。
This is well under the 1.75gb Shared memory limit, and each database Shared memory segment can safely map contiguously to a quadrant.
这低于1.75GB的共享内存限制,并且每个数据库共享内存段可以安全地连续映射到一个象限。
Database Shared memory is allocated when a database is activated or connected to for the first time.
数据库共享内存是在数据库被激活或者第一次被连接上的时候分配的。
If ESTORE is enabled, then it will take another segment away from the database Shared memory.
如果启用了ESTORE,那么还要从数据库共享内存中拿出另一个段。
The application group memory set is allocated from the database Shared memory set.
应用程序组内存集是从数据库共享内存集中分配的。
Note this amount includes both the instance Shared memory and database Shared memory, and their memory segments must be contiguous.
注意这个数量同时还包括实例共享内存和数据库共享内存,并且它们的内存段必须是邻接的。
Though FCM communication becomes faster, it reduces the database Shared memory by one segment.
虽然FCM通信变得更快,但是它也令数据库共享内存减少了一个段。
The limit for database shared memory is around 3.5GB.
数据库共享内存的限制大约是 3.5GB。
This leaves more room for other memory sets such as the database Shared memory.
这样就将更多的空间留给了其他内存集,例如数据库共享内存。
Database Shared memory: This refers to the database global memory, which is allocated when the database is activated or connected to for the first time.
数据库共享内存:这是数据库全局内存,是在激活数据库或者第一次连接到数据库时分配的。
However, keep in mind that buffer pools are part of the database Shared memory set.
但是请记住,缓冲池是数据库共享内存集中的一部分。
This article explains instance Shared memory and database Shared memory.
本文将介绍实例共享内存和数据库共享内存。
Following the instance Shared memory is the database Shared memory.
紧接着实例共享内存的是数据库共享内存。
Therefore, we can only allocate up to 1gb (physical RAM available) of Shared memory for database use.
因此,我们只能分配最多1gb(可用的物理ram)的共享内存给数据库使用。
Use the formula given earlier to calculate the database Shared memory.
可以使用前面给出的公式来计算数据库共享内存。
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。
The database buffer pool(s) area is normally the largest component of the database shared memory.
数据库缓冲池通常是数据库共享内存中最大的一块内存。
By default, the database Shared memory is 1.75gb minus the Stack.
在默认情况下,数据库共享内存的大小是1.75GB减去堆栈大小。
应用推荐