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.
这将有效地为数据库共享内存一个段。
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的共享内存限制,并且每个数据库共享内存段可以安全地连续映射到一个象限。
In addition to the above parameters, there is another parameter which also affects the amount of database Shared memory.
除了上述参数以外,还有一个参数也会影响数据库共享内存的数量。
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,那么还要从数据库共享内存中拿出另一个段。
If UDB is configured to create a database Shared memory set which is larger than this, the request will fail.
如果将UDB配置为创建一个大于该值的数据库共享内存集,则请求将遭到失败。
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通信变得更快,但是它也令数据库共享内存减少了一个段。
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)的共享内存给数据库使用。
Note that the database Shared memory calculations show that we are still within available 1gb Shared memory limit.
注意,对数据库共享内存的计算表明,我们仍然没有超出1gb可用共享内存的限制。
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减去堆栈大小。
This leaves 5 segments, or 1.25g for database Shared memory.
这样还剩下5个段,或者1.25g给数据库共享内存。
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。
Calculation: Use the formula to calculate database Shared memory, we get.
计算:使用公式计算数据库共享内存,我们得到。
应用推荐