db2数据库实例对应进程不明原因自动shutdown
数据库版本：DB2 v9.7.0.9，数据库实例对应进程不明原因shutdown。跪求原因和处理方法。 已通过db2dart 进行诊断。诊断报告最后是：看报告最后的输出都是： The requested DB2DART processing has completed successfully! All operation completed without error; no problems were detected in the database. 小机errpt报错： # errpt 标识 时间戳记 T C 资源名 描述 A924A5FC 0527185115 P S SYSPROC 软件程序异常终止 数据库日志如下： 2015-05-27-18.45.31.744735-300 E49147403A1008 LEVEL: Error (OS) PID : 32964710 TID : 1 PROC : db2 INSTANCE: db2admin NODE : 000 EDUID : 1 FUNCTION: DB2 UDB, oper system services, sqloclose, probe:20 MESSAGE : ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not found." DIA8411C A file "" could not be found. CALLED : OS, -, close OSERR : EBADF (9) "文件描述符没有指向一个打开的文件。" DATA #1 : File handle, PD_TYPE_SQO_FILE_HDL, 8 bytes File Handle = 4 File System Block Size = 0 bytes File System Type = UNKNOWN File Handle Flags : Require Sector Align = No DIO/CIO Mode = No Raw Block Device = No Reserved Handle = No Flush On Close = No Thread-Level Lock = No Write-through Mode = No File Not Tracked = No DATA #2 : String, 105 bytes Search for ossError*Analysis probe point after this log entry for further self-diagnosis of this problem. 2015-05-27-18.51.30.823457-300 I49148412A552 LEVEL: Error PID : 41091090 TID : 1 PROC : db2vend (PD Vendor Process - 258 INSTANCE: db2admin NODE : 000 EDUID : 1 EDUNAME: db2vend (PD Vendor Process - 258 FUNCTION: DB2 UDB, oper system services, DB2VEND_main, probe:1040 MESSAGE : ZRC=0x870F0009=-2029060087=SQLO_EOF "the data does not exist" DIA8506C Unexpected end of file was reached. DATA #1 : String, 63 bytes Fenced vendor process pipe failure, terminating vendor process. 2015-05-27-18.51.31.631206-300 E49148965A546 LEVEL: Severe PID : 36569238 TID : 258 PROC : db2wdog 0 INSTANCE: db2admin NODE : 000 EDUID : 258 EDUNAME: db2wdog 0 FUNCTION: DB2 UDB, base sys utilities, sqleWatchDog, probe:20 MESSAGE : ADM0503C An unexpected internal processing error has occurred. All DB2 processes associated with this instance have been shutdown. Diagnostic information has been recorded. Contact IBM Support for further assistance. |
5同行回答
/home/db2admin/sqllib/db2dump/26017802.000.core
# ls -ltr
total 52530856
-rw-r--r-- 1 db2admin db2grp1 26895748142 5月27 18时51 core收起
# ls -ltr
total 52530856
-rw-r--r-- 1 db2admin db2grp1 26895748142 5月27 18时51 core收起
浏览1367
db2dump 如下 ：
-rw-r--r-- 1 db2admin db2grp1 88901 5月27 01时32 19398816.2326.000.app_trap.txt
-rw-r--r-- 1 db2admin db2grp1 88652 5月27 03时38 36176104.1662.000.app_trap.txt
-rw-r--r-- 1 db2admin db2grp1 88652 5月27 05时43 36176114.1654.000.app_trap.txt
-rw-r--r-- 1 db2admin db2grp1 88652 5月27 07时48 36700402.1654.000.app_trap.txt
-rw-r--r-- 1 db2admin db2grp1 88652 5月27 09时53 34472066.1682.000.app_trap.txt
-rw-r--r-- 1 db2admin db2grp1 88652 5月27 11时59 34472070.1192.000.app_trap.txt
-rw-r--r-- 1 db2admin db2grp1 88652 5月27 15时36 40894554.1140.000.app_trap.txt
-rw-r--r-- 1 db2admin db2grp1 88652 5月27 17时41 27590680.1140.000.app_trap.txt
drwxr-s--- 2 db2admin db2grp1 256 5月27 18时47 26017802.000.core
18时47 分产生了一个25G的core文件收起
-rw-r--r-- 1 db2admin db2grp1 88901 5月27 01时32 19398816.2326.000.app_trap.txt
-rw-r--r-- 1 db2admin db2grp1 88652 5月27 03时38 36176104.1662.000.app_trap.txt
-rw-r--r-- 1 db2admin db2grp1 88652 5月27 05时43 36176114.1654.000.app_trap.txt
-rw-r--r-- 1 db2admin db2grp1 88652 5月27 07时48 36700402.1654.000.app_trap.txt
-rw-r--r-- 1 db2admin db2grp1 88652 5月27 09时53 34472066.1682.000.app_trap.txt
-rw-r--r-- 1 db2admin db2grp1 88652 5月27 11时59 34472070.1192.000.app_trap.txt
-rw-r--r-- 1 db2admin db2grp1 88652 5月27 15时36 40894554.1140.000.app_trap.txt
-rw-r--r-- 1 db2admin db2grp1 88652 5月27 17时41 27590680.1140.000.app_trap.txt
drwxr-s--- 2 db2admin db2grp1 256 5月27 18时47 26017802.000.core
18时47 分产生了一个25G的core文件收起
浏览1355
看看FODC TRAP 文件里有什么收起
浏览1294