| 发表于：2007-02-25 22:39:10 楼主 |
哪位高手救救我啊，我们的db2跑在ibm p595机器上，操作系统aix5.3,内存64g。
8个node的bi系统
db2 v8.2 ese with dpf
跑5个存储过程，主要是插入删除更改，db2每天都宕机，经查是
实例目录下的db2dump目录下存在大量dump文件！这些文件少的有60m大的超过200m
$ ls db2dump
10080861.005 a3715096.001 l070936.000 l5353863.007
10896141.007 a3785180.002 l075593.001 l537615.001
13929841.000 a3789170.005 l0758513.002 l5378771.000
14582721.005 a3801454.002 l0768251.005 l538397.005......
db2diag.log dwinst.nfy......
用db2diag查看诊断日志，发现有大量这样的信息，因为内容太多，摘选如下:
2007-02-25-09.57.56.391003+480 i48327892a294 level: event
pid : 204892 tid : 1 proc : db2flacc
instance: dwinst node : 000
function: db2 udb, config/install, sqlflogupdatecfgparam, probe:30
change : cfg dbm: "dft_mon_bufpool " from: "72 " to: "1 "
2007-02-25-09.58.33.867465+480 i48328187a477 level: severe
pid : 3785180 tid : 1 proc : db2agntp （masa15) 2
instance: dwinst node : 002 db : masa15
apphdl : 0-307 appid: gafb0446.b4dc.0c04b5192308
function: db2 udb, data management, sqldloadtcb, probe:4551
retcode : zrc=0x87040055=-2029780907=sqld_prgerr "unknown program error "
dia8576c a data management services programming error occurred.
2007-02-25-09.58.33.950656+480 i48328665a468 level: severe
pid : 3785180 tid : 1 proc : db2agntp （masa15) 2
instance: dwinst node : 002 db : masa15
apphdl : 0-307 appid: gafb0446.b4dc.0c04b5192308
function: db2 udb, data management, sqldloadtcb, probe:4551
message : error loading tcb. tcbflags =
data #1 : hexdump, 4 bytes
0x0fffffffffff62c0 : 0000 1000 ....
2007-02-25-09.58.33.951064+480 i48329134a360 level: severe
pid : 3785180 tid : 1 proc : db2agntp （masa15) 2
instance: dwinst node : 002 db : masa15
apphdl : 0-307 appid: gafb0446.b4dc.0c04b5192308
message : sqld_tcb:
data #1 : string, 41 bytes
perm table（21:19)=tbspaceid=21.tableid=19
2007-02-25-09.58.33.951357+480 i48329495a163 level: severe
pid:3785180 tid:1 node:002 title: sqld_tcb
dump file:/db2home/gsbiinst/sqllib/db2dump/37851801.002
2007-02-25-09.58.34.235806+480 i48329659a415 level: severe
pid : 3785180 tid : 1 proc : db2agntp （masa15) 2
instance: dwinst node : 002 db : masa15
apphdl : 0-307 appid: gafb0446.b4dc.0c04b5192308
function: db2 udb, query gateway, sqlqg_signal_handler, probe:10
message : dia0505i ＥＸＥＣution of a component signal handling function has begun.
2007-02-25-09.58.34.241448+480 i48330075a163 level: severe
pid:3785180 tid:1 node:002 title: qg sqlca
dump file:/db2home/gsbiinst/sqllib/db2dump/37851801.002
2007-02-25-09.58.34.242106+480 i48330568a428 level: severe
pid : 3785180 tid : 1 proc : db2agntp （masa15) 2
instance: dwinst node : 002 db : masa15
apphdl : 0-307 appid: gafb0446.b4dc.0c04b5192308
function: db2 udb, query gateway, sqlqg_signal_handler, probe:20
message : dia0506i ＥＸＥＣution of a component signal handling function is
complete.
2007-02-25-09.58.34.242470+480 i48330997a420 level: severe
pid : 3785180 tid : 1 proc : db2agntp （masa15) 2
instance: dwinst node : 002 db : masa15
apphdl : 0-307 appid: gafb0446.b4dc.0c04b5192308
function: db2 udb, relation data serv, sqlrr_signal_handler, probe:50
message : dia0505i ＥＸＥＣution of a component signal handling function has begun.
2007-02-25-09.58.34.246387+480 i48331418a167 level: severe
pid:3785180 tid:1 node:002 title: rds agent cb
dump file:/db2home/gsbiinst/sqllib/db2dump/37851801.002
......
那位大侠救救我啊，项目很快就要上线了，不敢交付客户啊！！！
泪奔中......
|
|
|
|
|
