There is one database Shared memory set per database.
每个数据库有一个数据库共享内存集。
For other environments, this memory set does not exist.
对于其他环境,这种内存集不存在。
Table 1. DB2 memory set limits based on 32-bit memory structure.
表1 -基于32位内存结构的DB 2内存集限制。
There is one agent private memory set per DB2 agent (or process).
每个代理(或进程)都有一个代理私有内存集。
Table 1 - DB2 memory set limits based on 32-bit memory structure.
表1-基于32位内存结构的DB 2内存集限制。
It is not necessary to change the memory set point.
不需要改变记忆设置点。
The sortheap is a memory pool that belongs to the agent private memory set.
sortheap是属于代理私有内存集的一个内存池。
The sort heap is a memory pool that belongs to the agent private memory set.
sortheap是属于代理私有内存集的一个内存池。
Each memory set consists of various memory pools (also referred to as heaps).
每种内存集由各种不同的内存池(亦称堆)组成。
Figure 2 shows the various memory pools within the database Shared memory set.
图2展示了数据库共享内存集内的各种内存池。
The application group shared memory set is: 40000 pages * 4K per page = 160 MB
应用程序组共享内存集是: 40000页 *4K/页 = 160 MB
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.
但是请记住,缓冲池是数据库共享内存集中的一部分。
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是属于数据库共享内存集的一个内存池。
These limits dictate how we configure each of the memory pools in the database shared memory set.
这些限制规定了我们该如何配置数据库共享内存集中的每个内存池。
If DB2 is configured to create a database Shared memory set which is larger than this, the request will fail.
如果把DB2配置成创建大于这个值的数据库共享内存,那么请求就会失败。
Application group Shared memory set is not listed because it is allocated from the database Shared memory set.
应用程序组共享内存集没有列出,因为它是从数据库共享内存集中分配的。
For example, the buffer pools and the database heaps are two separate memory pools within the database memory set.
例如,缓冲池和数据库堆是数据库内存集内的两个不同的内存池。
To resolve the problem, run UDF in an unfenced mode or reduce database Shared memory set to no more than 5 segments.
要解决这个问题,可以在unfenced模式下运行udf,或者将数据库共享内存减少至不多于5个段。
The following output indicates 42 MB of memory is reserved for the instance shared memory set (10313 pages * 4096 bytes per page)
下面的输出表明有 42MB 的内存被预留给实例共享内存集(10313页 * 4096字节/页)
In practice, the amount of memory set aside for survivor space is adjusted on the fly depending on the percentage of objects that survive each collection.
实际上,预留为幸存者空间的内存量会根据在每次收集中幸存下来的对象的百分比进行实时调整。
Depending on the type and size of the segment, DB2 can specify to create it in quadrant 4. The database Shared memory set is still limited to approximately 1gb.
根据段的类型和大小,DB 2可以指定在象限4中创建段。数据库共享内存集仍然有大约1gb的限制。
Applications that frequently access the data in this memory set (currently limited to the database working set) will likely experience a performance improvement.
经常访问该内存集(目前限制为数据库工作集)中的数据的应用程序将极有可能体验到性能改善。
The above example showed that although 42 MB is memory is reserved for the instance Shared memory set, only about 21 MB is being used at the time db2mtrk is run.
上面的例子表明,虽然预留给实例共享内存集的内存有42MB,但在db2mtrk运行时只用到了大约21 MB。
Limit: Any request by DB2 to create a database share memory set which is larger then the shmmax value (2gb in this case) will fail with an out of memory type error.
限制:DB2发出的任何创建大于shmmax值(这里是2gb)的数据库共享内存集的请求都将失败,并返回一个outofmemorytype错误。
Memory set to minimum frequency.
内存设为最小频率。
For example, if you want 128 MB of shared memory, set kern.sysv.shmmax=134217728 and set kern.sysv.shmall=32768.
例如,假设需要 128MB的共享内存,那么设定 kern.sysv.shmmax=134217728并设定 kern.sysv.shmall=32768。
For example, if you want 128 MB of shared memory, set kern.sysv.shmmax=134217728 and set kern.sysv.shmall=32768.
例如,假设需要 128MB的共享内存,那么设定 kern.sysv.shmmax=134217728并设定 kern.sysv.shmall=32768。
应用推荐