Memory set to minimum frequency.
内存设为最小频率。
There is one database Shared memory set per database.
每个数据库有一个数据库共享内存集。
For other environments, this memory set does not exist.
对于其他环境,这种内存集不存在。
There is one instance Shared memory set per DB2 instance.
每个DB 2实例都有一个实例共享内存。
Table 1. DB2 memory set limits based on 32-bit memory structure.
表1 -基于32位内存结构的DB 2内存集限制。
The unit or system has now been balanced and the memory set.
这个装置或系统现在已经平衡,并且记忆设置。
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内存集限制。
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.
但是请记住,缓冲池是数据库共享内存集中的一部分。
This is much less then any database Shared memory set available to other UNIX platforms.
这比其他UNIX平台上可用的任何数据库共享内存集要少得多。
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 UDB is configured to create a database Shared memory set which is larger than this, the request will fail.
如果将UDB配置为创建一个大于该值的数据库共享内存集,则请求将遭到失败。
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字节/页)
Limit: Because the physical RAM is only 1gb, the database Shared memory set can only map to what is physically available to it, which is 1gb + swap space.
限制:由于物理ram只有1gb,数据库共享内存集只能映射到它在物理上可以使用的空间,即1gb +交换空间。
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.
实际上,预留为幸存者空间的内存量会根据在每次收集中幸存下来的对象的百分比进行实时调整。
The agent private memory set consist of the following memory pools. Their sizes are specified in the database configuration parameters enclosed in parenthesis.
代理私有内存集由以下内存池组成。
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.
经常访问该内存集(目前限制为数据库工作集)中的数据的应用程序将极有可能体验到性能改善。
应用推荐