Stat_heap_sz is part of agent private memory.
stat _ heap _ sz是代理私有内存的一部分。
Segment 2 - Reserved for agent private memory.
段2-预留给代理私有内存。
In addition, they have their own agent private memory.
此外,它们有其自己的代理私有内存。
Data contains user data (which is the agent private memory).
数据包含用户数据(即代理私有内存)。
When an agent becomes idle, it retains its agent private memory.
当代理变成闲置代理时,它仍然保留了其代理的私有内存。
There is one agent private memory set per DB2 agent (or process).
每个代理(或进程)都有一个代理私有内存集。
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是属于代理私有内存集的一个内存池。
If the sort is a private sort, then this parameter affects agent private memory.
如果排序是私有排序,那么该参数影响代理程序私有内存。
Agent private memory may be paged out if the agent has been idle for a long time.
如果代理闲置了较长的一段时间,则其代理私有内存将被调出。
Platform Instance Shared Memory Database Shared Memory Agent Private Memory.
平台实例共享内存数据库共享内存代理私有内存。
Agent private memory is affected by the database configuration parameters shown in Table 5.
代理程序私有内存受表5中所示的数据库配置参数的影响。
However, it can be changed to a higher address so more room is left for agent private memory.
不过,也可以将其改为一个更高的地址,以便有更多的空间留给代理私有内存。
The section in orange (heap), from 0x023f8000 to 0x10000000, is used for the agent private memory. (~ 220mb).
橙色的那部分(堆),即从0x023f 8000到0x10000000,被用于代理私有内存(~ 220MB)。
In addition to Shared memory, DB2 also allows custom configuration of agent private memory into 16-megabyte pages.
除了共享内存外,DB 2还允许为代理私有内存自定义配置16 MB的页面。
The first segment starts at 0x00010000 and it is reserved for db2sysc executables and the agent private memory.
第一个段始于0x00010000,这个段被预留给db2sysc可执行程序和代理私有内存。
Within this segment, the db2sysc executables take only a small fraction, the rest is used for agent private memory (200mb +).
在这个段内,db2sysc可执行程序只占用很小的一片内存,剩下的用于代理私有内存(200 MB +)。
The typical consumer of agent private memory is the sort heap memory that is used by the agent to sort rows during query execution.
代理私有内存的常见消费者是排序堆内存,代理在查询执行期间使用这部分内存来对记录行进行排序。
The data/heap region contains dynamically allocated memory and some globally accessible program data (for example, DB2 agent private memory).
data/heap区域包含动态分配的内存和可全局访问的程序数据(例如DB2代理私有内存)。
The agent private memory can be increased by moving the instance Shared memory to a higher address by setting the DB2DBMSADDR DB2 registry variable.
我们可以通过设置DB2DBMSADDRDB 2注册表变量,将实例共享内存移到更高的地址,从而增加代理私有内存。
So far we have discussed the instance Shared memory, the database Shared memory, the application group Shared memory and the agent private memory.
至此,我们已经讨论了实例共享内存、数据库共享内存和应用程序组共享内存以及代理私有内存。
The agent private memory set consist of the following memory pools. Their sizes are specified in the database configuration parameters enclosed in parenthesis.
代理私有内存集由以下内存池组成。
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).
之前我们曾提到过,代理私有内存包括一些内存池,例如应用程序堆大小、排序堆大小和语句堆大小。
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)
代理私有内存的大小(由'heap' 标出)从 220MB (图10)增加到了 252 MB。
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.
然而,DB 2目前不会自动为代理私有内存启用64KB的页面大小,也不允许为代理私有内存自定义配置16 GB的页面大小。
We have mentioned that private memory is allocated to a DB2 agent when the agent is "assigned" to perform work.
我们曾提到,私有内存是在一个DB 2代理被“指派”执行任务时分配给该代理的。
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.
应用程序堆大小参数定义了数据库管理器的一个特定代理或子代理所能使用的私有内存页数。
These are similar to private agent memory in DB2 LUW.
这些类似于DB2LUW 下的私有代理内存。
Each agent has its own private memory.
每个代理程序都拥有自己的私有内存。
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代理进程。
应用推荐