论坛徽章:: 0

电梯直达

1楼 [收藏(0)] [报告]

发表于 2007-03-22 09:14 |只看该作者 |倒序浏览

最近早上上班经常发现实例在晚上宕掉，有dump生成，晚上只做一个三点的自动备份，望高手指点迷津！

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

下附db2diag.log内容。

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

文库|博客

xray26

白手起家

论坛徽章:: 0

2楼 [报告]

发表于 2007-03-22 09:14 |只看该作者

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

实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？

xray26

白手起家

论坛徽章:: 0

3楼 [报告]

发表于 2007-03-22 09:19 |只看该作者

在日志中看到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.晚上没人用啊，怎么会超过最大代理数？

实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？

xray26

白手起家

论坛徽章:: 0

4楼 [报告]

发表于 2007-03-22 09:33 |只看该作者

日志中到早上7点5分的时候产生了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.
……

实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？

Jens

稍有积蓄

论坛徽章:: 0

5楼 [报告]

发表于 2007-03-24 01:50 |只看该作者

关注中,,,高手快来.

实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？

huyuhui001

版主

论坛徽章:: 0

6楼 [报告]

发表于 2007-03-24 07:32 |只看该作者

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

实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？

xray26

白手起家

论坛徽章:: 0

7楼 [报告]

发表于 2007-03-26 09:16 |只看该作者

谢谢楼上回复！
看下边日志白天有锁升级的情况。
参数：LOCKLIST 5000
      DLCHKTIME 10000
      MAXLOCKS 20
      LOCKTIMEOUT 60
还有就是下边日志中中午出现的“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.