db cfg：CATALOGCACHE_SZ阻挠。 [英] db cfg: CATALOGCACHE_SZ obscurites.
问题描述
你好。
1）根据文件，设置
CATALOGCACHE_SZ = -1表示CATALOGCACHE_SZ =（MAXAPPLS * 4）
但MAXAPPLS设置为AUTOMATIC，这意味着无限制。或无价值。同样，根据文档，CATALOGCACHE_SZ在初始化数据库时被分配。因此，我很有意思，哪个值真的被分配而不是幻觉（< no limit> * 4）。
" get db cfg"命令在这里没有帮助，因为字面上显示（MAXAPPLS * 4）。
2）如果我有办法可靠的话，就没有问题的余地（1）检查CATALOGCACHE_SZ值。但是我的结果不一致：
_______________________________________________
| |目录| " catcacheh" （db2mtrk -d的标记）
MAXAPPLS | CACHE_SZ |显示|我期待......
-------- + -------- + -------- + --------- -----------
（忽略）100 192,0K 4K * 100 = 400K
20 -1 64,0K 4K *（20 * 4）= 320K
AUTOMAT -1 64,0K（无假设）
-------------------- ---------------------------
因此，我很有兴趣，怎么相关CATALOGCACHE_SZ db config参数，catcacheh db2mtrk的令牌和真实的目录缓存大小？
-
Konstantin Andreev。
< blockquote> Konstantin Andreev写道：
你好。
1）根据文件，设置
CATALOGCACHE_SZ = -1表示CATALOGCACHE_SZ =（MAXAPPLS * 4）
但MAXAPPLS设置为AUTOMATIC，这意味着无限制。或没有
值。同样，根据文档，当数据库初始化时，CATALOGCACHE_SZ被分配
。因此，我很有意思，它的价值实际上是分配给了b $ b而不是幻觉（< no limit> * 4）。
AUTOMATIC并不意味着没有限制或者没有价值。
您是否尝试过DB2 GET DB CFG FOR< aliasSHOW DETAIL？
Jan M. Nelken
Konstantin Andreev写道：
你好。
1）根据文件，设置
CATALOGCACHE_SZ = -1表示CATALOGCACHE_SZ =（MAXAPPLS * 4）
但MAXAPPLS设置为AUTOMATIC，这意味着无限制。或没有
值。同样，根据文档，CATALOGCACHE_SZ是初始化数据库时分配的
。因此，我很有意思，
哪个值真的被分配而不是幻觉（< no limit> * 4）。
AUTOMATIC并不代表无限制或者没有值，它表示值由DB2确定并根据情况动态调整。
>
" get db cfg"命令在这里没有帮助，因为字面上
显示（MAXAPPLS * 4）。
尝试使用autoconfigure命令，使用no-apply选项，如下所示：
db2 autoconfigure using MAXAPPLS CATALOGCACHE_SZ apply没有
它会显示公式和实际值。
HTH。
-
Jeroen
谢谢大家！
AUTOMATIC并不代表 ;没有限制或无价值。您是否尝试过DB2 GET DB CFG FOR< aliasSHOW DETAIL？
"显示详细信息，当然！我完全忘了它。
-
康斯坦丁安德列夫。
Hello there.
1) According to documentation, setting
CATALOGCACHE_SZ = -1 means CATALOGCACHE_SZ = (MAXAPPLS*4)
But MAXAPPLS is set to AUTOMATIC, this means "no limit" or "no value". Again, according to documentation, CATALOGCACHE_SZ is allocated "when the database is initialized". Hence, I''m interesting, which value is really allocated instead of illusion (<no limit>*4).
"get db cfg" command does not help here, because literally displays "(MAXAPPLS*4)".
2) There would be no room for question (1) if I have a way to reliably check CATALOGCACHE_SZ value. But I have inconsistent results:
_______________________________________________
| |CATALOG | "catcacheh" (token of db2mtrk -d)
MAXAPPLS|CACHE_SZ| shown | I would expect...
--------+--------+--------+--------------------
(ignore) 100 192,0K 4K*100 = 400K
20 -1 64,0K 4K*(20*4) = 320K
AUTOMAT -1 64,0K (no assumptions)
-----------------------------------------------
Hence, I''m intresting, how are related CATALOGCACHE_SZ db config parameter, "catcacheh" token of db2mtrk, and real catalog cache size ?
--
Konstantin Andreev.
Konstantin Andreev wrote:Hello there.
1) According to documentation, setting
CATALOGCACHE_SZ = -1 means CATALOGCACHE_SZ = (MAXAPPLS*4)
But MAXAPPLS is set to AUTOMATIC, this means "no limit" or "no
value". Again, according to documentation, CATALOGCACHE_SZ is allocated
"when the database is initialized". Hence, I''m interesting, which value
is really allocated instead of illusion (<no limit>*4).AUTOMATIC does not mean "no limit" or "no value".
Did you try DB2 GET DB CFG FOR <aliasSHOW DETAIL?
Jan M. Nelken
Konstantin Andreev wrote:Hello there.
1) According to documentation, setting
CATALOGCACHE_SZ = -1 means CATALOGCACHE_SZ = (MAXAPPLS*4)
But MAXAPPLS is set to AUTOMATIC, this means "no limit" or "no
value". Again, according to documentation, CATALOGCACHE_SZ is
allocated "when the database is initialized". Hence, I''m interesting,
which value is really allocated instead of illusion (<no limit>*4).AUTOMATIC doesn''t mean "no limit" or "no value", it means the value is
determined by DB2 and dynamically adapted depending on circumstances.
>
"get db cfg" command does not help here, because literally
displays "(MAXAPPLS*4)".Try the autoconfigure command instead, with the no-apply option, like this:
db2 autoconfigure using MAXAPPLS CATALOGCACHE_SZ apply none
It will show both the formula and the actual value.
HTH.
--
Jeroen
Thank everybody!
AUTOMATIC does not mean "no limit" or "no value". Did you try DB2 GET DB CFG FOR <aliasSHOW DETAIL?"Show detail", of course! I''ve absolutely forgotten it.
--
Konstantin Andreev.
这篇关于db cfg：CATALOGCACHE_SZ阻挠。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
