求教：db2實例宕掉

xray26

最近早上上班經(jīng)常發(fā)現(xiàn)實例在晚上宕掉，有dump生成，晚上只做一個三點的自動備份，望高手指點迷津！

DB2 V8.1 fix5
AIX  V5.1
HA   V4.5

下附db2diag.log內(nèi)容。

[ 本帖最后由 xray26 于 2007-3-22 09:24 編輯 ]

xray26

2007-03-22-03.01.21.210565   Instance:db2inst1   Node:000
PID:48172(db2loggr (SHDATA) 0)   TID:1   Appid:none
data protection  sqlpghck Probe:1390

ExtNum 5288, state 401, baselsn 0000004BD3220000 nextlsn 0000004BD7249D15

2007-03-22-03.01.33.532974   Instance:db2inst1   Node:000
PID:43100(db2agent (LOSHDATA) 0)   TID:1   Appid:GA398003.BE74.0D8F91190126
base sys utilities  sqle_remap_errors Probe:100   Database:SHDATA

ZRC 0x80040003 remapped to SQLCODE -1044

2007-03-22-03.01.33.600498   Instance:db2inst1   Node:000
PID:43100(db2agent (LOSHDATA) 0)   TID:1   Appid:GA398003.BE74.0D8F91190126
base sys utilities  sqlesrsu Probe:140   Database:SHDATA

DIA8003C The interrupt  has been received.
ZRC=0x80040003

xray26

在日志中看到3點的自動備份操作正常啊，怎么在6點50多就宕了呢？
ADM7009E  An error was encountered in the "TCPIP" protocol support.  A possible cause is that the maximum number of agents has been exceeded.晚上沒人用啊，怎么會超過最大代理數(shù)？

xray26

日志中到早上7點5分的時候產(chǎn)生了dump文件
……
2007-03-22-07.05.15.692359   Instance:db2inst1   Node:000
PID:24450(db2stop2)   TID:1   Appid:none
base sys utilities  sqleKillNode Probe:90

Sending sigdump and waiting for 1 min to complete

2007-03-22-07.05.16.485541   Instance:db2inst1   Node:000
PID:55142(db2agent 0)   TID:1   Appid:none
DRDA Application Server  sqljsSignalHandler Probe:10

DIA0505I Execution of a component signal handling function has begun.

2007-03-22-07.05.16.183814   Instance:db2inst1   Node:000
PID:45256(db2agent 0)   TID:1   Appid:none
DRDA Application Server  sqljsSignalHandler Probe:10

DIA0505I Execution of a component signal handling function has begun.

PID:45256 TID:1 Node:000 Title: **** DRDA ASCB ****
Dump File:/home/db2inst1/sqllib/db2dump/452561.000

PID:45256 TID:1 Node:000 Title: **** DRDA CMNMGR CB ****
Dump File:/home/db2inst1/sqllib/db2dump/452561.000

2007-03-22-07.05.17.072541   Instance:db2inst1   Node:000
PID:30298(db2agent 0)   TID:1   Appid:none
DRDA Application Server  sqljsSignalHandler Probe:10

DIA0505I Execution of a component signal handling function has begun.

PID:30298 TID:1 Node:000 Title: **** DRDA ASCB ****
Dump File:/home/db2inst1/sqllib/db2dump/302981.000

PID:30298 TID:1 Node:000 Title: **** DRDA CMNMGR CB ****
Dump File:/home/db2inst1/sqllib/db2dump/302981.000

PID:30298 TID:1 Node:000 Title: **** RECEIVE BUFFER ****
Dump File:/home/db2inst1/sqllib/db2dump/302981.000

PID:30298 TID:1 Node:000 Title: **** SEND BUFFERS ****


PID:30298 TID:1 Node:000 Title: **** CONNECTION HANDLE ****
Dump File:/home/db2inst1/sqllib/db2dump/302981.000

PID:30298 TID:1 Node:000 Title: **** DRDA ATTRIBUTES ****
Dump File:/home/db2inst1/sqllib/db2dump/302981.000

PID:30298 TID:1 Node:000 Title: **** AS UCINTERFACE ****
Dump File:/home/db2inst1/sqllib/db2dump/302981.000

2007-03-22-07.05.17.767869   Instance:db2inst1   Node:000
PID:30298(db2agent 0)   TID:1   Appid:none
DRDA Application Server  sqljsSignalHandler Probe:20

DIA0506I Execution of a component signal handling function is complete.
……

Jens

關(guān)注中,,,高手快來.

huyuhui001

lock情況呢？
ZRC=0x80040003 的意思是 USER INTERRUPT DETECTED

xray26

謝謝樓上回復(fù)！
看下邊日志白天有鎖升級的情況。
參數(shù)：LOCKLIST 5000   
         DLCHKTIME 10000  
         MAXLOCKS 20
         LOCKTIMEOUT 60
還有就是下邊日志中中午出現(xiàn)的“errno: 0x2FF00E98 : 0x00000009”是什么意思？   

2007-03-21-09.58.11.885248   Instance:db2inst1   Node:000
PID:51960(db2agent (LOSHDATA) 0)   TID:1   Appid:GA398003.OD94.085D61000105
data management  sqldEscalateLocks Probe:3   Database:SHDATA

ADM5502W  The escalation of "102402" locks on table "DB2INST1.CALL_LOG_LINE" to
lock intent "S" was successful.

2007-03-21-13.14.38.167198   Instance:db2inst1   Node:000
PID:50424(db2agent (LOSHDATA) 0)   TID:1   Appid:GA398003.OD92.07DD21000051
data management  sqldEscalateLocks Probe:3   Database:SHDATA

ADM5502W  The escalation of "102401" locks on table "DB2INST1.CALL_LOG_LINE" to
lock intent "S" was successful.

2007-03-21-13.52.11.583564   Instance:db2inst1   Node:000
PID:21360(db2)   TID:1   Appid:none
oper system services  sqloclose Probe:110

errno:
0x2FF00E98 : 0x00000009                                 ....

2007-03-21-13.57.13.019356   Instance:db2inst1   Node:000
PID:26818(db2)   TID:1   Appid:none
oper system services  sqloclose Probe:110

errno:
0x2FF20D98 : 0x00000009                                 ....

2007-03-21-14.43.19.733558   Instance:db2inst1   Node:000
PID:26840(db2)   TID:1   Appid:none
oper system services  sqloclose Probe:110

errno:
0x2FF20D88 : 0x00000009                                 ....

2007-03-21-19.21.29.464752   Instance:db2inst1   Node:000
PID:29814(db2agent (LOSHDATA) 0)   TID:1   Appid:GA398003.BCC2.0D7971105623
data management  sqldEscalateLocks Probe:3   Database:SHDATA

ADM5502W  The escalation of "27770" locks on table "DB2INST1.ITEM_SLSMAN_MONTH"
to lock intent "X" was successful.

2007-03-21-19.21.29.565837   Instance:db2inst1   Node:000
PID:29814(db2agent (LOSHDATA) 0)   TID:1   Appid:GA398003.BCC2.0D7971105623
data management  sqldEscalateLocks Probe:3   Database:SHDATA

ADM5502W  The escalation of "26576" locks on table
"DB2INST1.ITEM_DPT_SALE_MONTH" to lock intent "X" was successful.

2007-03-21-19.24.28.435010   Instance:db2inst1   Node:000
PID:29814(db2agent (LOSHDATA) 0)   TID:1   Appid:GA398003.BCC2.0D7971105623
data management  sqldEscalateLocks Probe:3   Database:SHDATA

ADM5502W  The escalation of "54349" locks on table
"DB2INST1.ITEM_SALESMAN_MONTH" to lock intent "X" was successful.

2007-03-21-19.31.06.525802   Instance:db2inst1   Node:000
PID:39322(db2agent (LOSHDATA) 0)   TID:1   Appid:*LOCAL.db2inst1.0C7BD1000225
data management  sqldEscalateLocks Probe:3   Database:SHDATA

ADM5502W  The escalation of "52070" locks on table "TSCD   
.CDITEM_SLSMAN_MONTH" to lock intent "X" was successful.

2007-03-21-19.31.19.781498   Instance:db2inst1   Node:000
PID:39322(db2agent (LOSHDATA) 0)   TID:1   Appid:*LOCAL.db2inst1.0C7BD1000225
data management  sqldEscalateLocks Probe:3   Database:SHDATA

ADM5502W  The escalation of "52070" locks on table "TSCD   
.CDITEM_SALESMAN_MONTH" to lock intent "X" was successful.

xray26

原帖由 huyuhui001 于 2007-3-24 07:32 發(fā)表
lock情況呢？
ZRC=0x80040003 的意思是 USER INTERRUPT DETECTED

ZRC=0x80040003 是不是由于自動備份腳本里的“db2 force applications all”命令所致呢？

[ 本帖最后由 xray26 于 2007-3-26 09:27 編輯 ]

lizhuo

db2 force applications all會殺掉所有當(dāng)前數(shù)據(jù)庫的應(yīng)用。

xray26

原帖由 lizhuo 于 2007-3-26 16:13 發(fā)表
db2 force applications all會殺掉所有當(dāng)前數(shù)據(jù)庫的應(yīng)用。

我知道呀，我的意思是ZRC=0x80040003 這個信息是不是由于執(zhí)行了force applications 命令而產(chǎn)生的呢。