有关包缓存溢出的问题 [英] Question on Package Cache Overflows
问题描述
在AIX 5.1上运行DB2 8.1.6A
我们遇到包缓存溢出。
包缓存的高水位标记是显示为16,108,513字节，
或
约3933 4K页。
包缓存大小设置为Maxapples * 8 < br $>
Maxapples为500.
使包缓存大小为4000（4K页）。
我们不是明确我们如何在高水位显示低于cfg参数时遇到溢出。
我们是不是在考虑页面上的开销？
提前致谢。
格里
Running DB2 8.1.6A on AIX 5.1
We are experience package cache overflows.
The high water mark for package cache is showing as 16,108,513 bytes,
or
approximately 3933 4K pages.
The package cache size is set at Maxapples * 8
Maxapples is at 500.
Makes the package cache size 4000 (4K pages).
We are not clear on how we can be experiencing overflows when the high
water mark is showing as less than the cfg parameter.
Is it that we are not accounting for overhead on the page?
Thanks in advance.
Gerry
推荐答案
是不是因为最后一次插入包缓存请求更多
而不是67（4000-3933）页缓存会导致它发出信号
溢出。
它必须推足够大的东西可以为请求腾出空间。
我相信这会导致溢出信号。
HTH，皮埃尔。
-
Pierre Saint-Jacques
SES顾问公司
514-737-4515
<哒******* @ yahoo.com> écritdansle message de news：
11**********************@f14g2000cwb.googlegroups。 com ...
Would it not be because the last insert into package cache requested more
than 67 (4000-3933)pages of cache that it would cause it to signal an
overflow.
It would have to "push" something large enough to make room for the request.
I believe that would cause an overflow to be signalled.
HTH, Pierre.
--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
<da*******@yahoo.com> a écrit dans le message de news:
11**********************@f14g2000cwb.googlegroups. com...
在AIX 5.1上运行DB2 8.1.6A
我们经验包缓存溢出。
高水包缓存的标记显示为16,108,513字节，
或
约3933个4K页。
包缓存大小设置为Maxapples * 8
Maxapples为500 。
使包缓存大小为4000（4K页）。
我们不清楚当高水位标记显示时我们如何遇到溢出小于cfg参数。
是不是我们不考虑页面上的开销？
提前致谢。
Gerry
Running DB2 8.1.6A on AIX 5.1
We are experience package cache overflows.
The high water mark for package cache is showing as 16,108,513 bytes,
or
approximately 3933 4K pages.
The package cache size is set at Maxapples * 8
Maxapples is at 500.
Makes the package cache size 4000 (4K pages).
We are not clear on how we can be experiencing overflows when the high
water mark is showing as less than the cfg parameter.
Is it that we are not accounting for overhead on the page?
Thanks in advance.
Gerry
Pierre Saint-Jacques写道：
Pierre Saint-Jacques wrote:
是不是因为最后一次插入包缓存请求
超过67（4000-3933）页面的缓存会导致它发出溢出信号。
它必须推出来。足够大的东西，以便为
请求腾出空间。
我相信这会导致溢出信号。
HTH，皮埃尔。
Would it not be because the last insert into package cache requested
more than 67 (4000-3933)pages of cache that it would cause it to signal
an overflow.
It would have to "push" something large enough to make room for the
request.
I believe that would cause an overflow to be signalled.
HTH, Pierre.
我我不知道缓存实现的细节，但是它可能也没有足够的连续空间
（碎片）。
干杯
Serge
-
Serge Rielau
DB2 SQL编译器开发
IBM多伦多实验室
I''m not privy to the details of the implementation of the cache, but it
may also be that there isn''t sufficient contigeous space available
(fragmentation).
Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
Serge Rielau写道：
Serge Rielau wrote:
Pierre Saint-Jacques写道：
Pierre Saint-Jacques wrote:
是不是因为最后一次插入包缓存请求超过67（4000-3933）页缓存会导致它发出溢出信号。
它必须推出来。足够大的东西，以便为
请求腾出空间。
我相信这会导致溢出信号。
HTH，皮埃尔。
Would it not be because the last insert into package cache requested
more than 67 (4000-3933)pages of cache that it would cause it to
signal an overflow.
It would have to "push" something large enough to make room for the
request.
I believe that would cause an overflow to be signalled.
HTH, Pierre.
我不是知道缓存的实现细节，但它也可能是没有足够的连续空间
（碎片）。
I''m not privy to the details of the implementation of the cache, but it
may also be that there isn''t sufficient contigeous space available
(fragmentation).
旁白..你使用SQL程序吗？如果是这样，我建议慷慨地使用
缓存。
干杯
Serge
-
Serge Rielau
DB2 SQL编译器开发
IBM多伦多实验室
Aside.. Do you use SQL Procedures? If so I recommend being generous with
the cache.
Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
这篇关于有关包缓存溢出的问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
