我的db2diag.log 中有如下错误。。。

cklea

问题一：
2003-。。。    Instance:*** Node:000
PID:19092(db2tcpcm) Appid:none
common_communication   sqlcctcponnnmgr_child probe:125
DIA3003E Error encountered in "TCPIP" protocol support
Return code from "sqlGetAgent" was "-1226"

问题二：
。。。。
。。。。
base_sys_utilities  sqleGetAgentFromPool Probe:97
DIA3847C An error occurred in a database page header

请问这些问题是由什么原因造成的，如何才能解决！？

大连老K

第一个问题好像是由于内存小而产生的错误
第二个问题，看看下面的解释：
There is a very rare case where we try to prefetch object page  
-1, and this causes sqb warnings/errors to be written to the   
db2diag.log.  However processing is not affected (the database  
doesn't come down, applications are not affected).  This can   
occur when doing a select and ordering output in reverse        
clustering order, and a plan is chosen that uses a reverse scan
of the clustering index.  When this is done, the error can only
occur if sequential detection is suspended (i.e. a bunch of keys
don't qualify so the data pages aren't accessed), but then      
prefetching starts up again, and the sequential detection      
threshold is passed just as we reach data page 0, so we try to  
call sqldInitiatePrefetch with page -1 (as prefetching starts   
from the next lower page).

joy666

原帖由 "大连老K" 发表：
第二个问题，看看下面的解释：
There is a very rare case where we try to prefetch object page  
-1, and this causes sqb warnings/errors to be written to the    ..........

请问老K, 这些解释从何而来, 在那里能找到这些信息?你说在IBM网站了,可我找不到. 尤其是DIAC 错误代码, 在何处找到解释?
多谢您这位热心人!!!

大连老K

原帖由 "joy666" 发表：


请问老K, 这些解释从何而来, 在那里能找到这些信息?你说在IBM网站了,可我找不到. 尤其是DIAC 错误代码, 在何处找到解释?
多谢您这位热心人!!!

可以到db2页面，在搜索的地方输入要查找的内容就可以了