哪位高手救救我啊,我们的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 Execution 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 Execution 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 Execution 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
......
那位大侠救救我啊,项目很快就要上线了,不敢交付客户啊!!!
泪奔中......