代理私有内存集由以下内存池组成。
The agent private memory set consist of the following memory pools. Their sizes are specified in the database configuration parameters enclosed in parenthesis.
如果代理闲置了较长的一段时间,则其代理私有内存将被调出。
Agent private memory may be paged out if the agent has been idle for a long time.
不过,也可以将其改为一个更高的地址,以便有更多的空间留给代理私有内存。
However, it can be changed to a higher address so more room is left for agent private memory.
除了共享内存外,DB 2还允许为代理私有内存自定义配置16 MB的页面。
In addition to Shared memory, DB2 also allows custom configuration of agent private memory into 16-megabyte pages.
第一个段始于0x00010000,这个段被预留给db2sysc可执行程序和代理私有内存。
The first segment starts at 0x00010000 and it is reserved for db2sysc executables and the agent private memory.
至此,我们已经讨论了实例共享内存、数据库共享内存和应用程序组共享内存以及代理私有内存。
So far we have discussed the instance Shared memory, the database Shared memory, the application group Shared memory and the agent private memory.
代理私有内存的常见消费者是排序堆内存,代理在查询执行期间使用这部分内存来对记录行进行排序。
The typical consumer of agent private memory is the sort heap memory that is used by the agent to sort rows during query execution.
代理私有内存的大小(由'heap' 标出)从 220MB (图10)增加到了 252 MB。
The size of the agent private memory (indicated by 'heap') is increased to from 220MB (Figure 10) to 252 MB. (0x12000000 - 0x023F6000 = 0xFC0A000 = 264282112 (in decimal) = ~252MB)
之前我们曾提到过,代理私有内存包括一些内存池,例如应用程序堆大小、排序堆大小和语句堆大小。
As we have mentioned earlier, the agent private memory includes several memory pools such as the application heap size, sort heap size and statement heap size. (See Figure 1).
data/heap区域包含动态分配的内存和可全局访问的程序数据(例如DB2代理私有内存)。
The data/heap region contains dynamically allocated memory and some globally accessible program data (for example, DB2 agent private memory).
橙色的那部分(堆),即从0x023f 8000到0x10000000,被用于代理私有内存(~ 220MB)。
The section in orange (heap), from 0x023f8000 to 0x10000000, is used for the agent private memory. (~ 220mb).
在这个段内,db2sysc可执行程序只占用很小的一片内存,剩下的用于代理私有内存(200MB +)。
Within this segment, the db2sysc executables take only a small fraction, the rest is used for agent private memory (200mb +).
我们可以通过设置DB2DBMSADDRDB 2注册表变量,将实例共享内存移到更高的地址,从而增加代理私有内存。
The agent private memory can be increased by moving the instance Shared memory to a higher address by setting the DB2DBMSADDR DB2 registry variable.
然而,DB 2目前不会自动为代理私有内存启用64KB的页面大小,也不允许为代理私有内存自定义配置16 GB的页面大小。
However, DB2 currently does not automatically enable 64 kilobytes for agent private memory, nor does it allow custom configuration of agent private memory configuration with 16-gigabyte pages.
这样设计是为了提高性能,因为当代理被再次调用时,它便有准备好的私有内存。
This is designed to improve performance, because the agent will have its private memory ready when it is called again.
这意味着每个闲置代理可以保留最多8MB的私有内存。
That means each idle agent can retain up to 8mb of its private memory.
应用程序堆大小参数定义了数据库管理器的一个特定代理或子代理所能使用的私有内存页数。
The application heap size parameter defines the number of private memory pages available to be used by the database manager on behalf of a specific agent or subagent.
查询堆用于在代理的私有内存中存储每个查询。
A query heap is used to store each query in the agent's private memory.
如果有很多的闲置代理,并且所有这些闲置代理都保留了它们的私有内存,那么就可能导致系统耗尽内存。
If there are many idle agents and all of them retain their private memory, it is possible that the system runs out of memory.
我们曾提到,私有内存是在一个DB 2代理被“指派”执行任务时分配给该代理的。
We have mentioned that private memory is allocated to a DB2 agent when the agent is "assigned" to perform work.
代理程序私有内存受表5中所示的数据库配置参数的影响。
Agent private memory is affected by the database configuration parameters shown in Table 5.
为了理解共享内存与私有内存之间的不同之处,首先让我们通过快速阅读DB 2进程model来了解一下DB 2代理进程。
To understand the difference between Shared and private memory, let's first learn about the DB2 agent processes by quickly reviewing the DB2 process model.
为了理解共享内存与私有内存之间的不同之处,首先让我们通过快速阅读DB 2进程model来了解一下DB 2代理进程。
To understand the difference between Shared and private memory, let's first learn about the DB2 agent processes by quickly reviewing the DB2 process model.
应用推荐