求教：db2实例宕掉

lizhuo

有可能，不完全是。

xray26

那实例不定期宕掉，是不是跟锁升级有关系呢，是不是需要调整一下那几个关于锁的参数？

mymm

看了一下您的DIAG，就该是如下步骤：

[quote]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

mymm

原帖由 xray26 于 2007-3-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 ha ...

这个提示是STOP、START的正常提示？

在近七点时有没有应用连接DB呢？

xray26

回13楼

crontab里制定的是每天凌晨3点的数据库脱机备份，数据库备份映像文件我已经用db2ckbkp检查了，是可用的。

[ 本帖最后由 xray26 于 2007-3-28 13:58 编辑 ]

xray26

回14楼

一般是在7点30分左右开始进行业务的。那天早上发现连不上数据库了，而且start、 stop都不可用，管理员在7点左右把小机重起了。

[ 本帖最后由 xray26 于 2007-3-28 13:58 编辑 ]

xray26

今天凌晨0点30分有个TSM的数据库自动备份任务，备份成功了，但是之后3点的自动脱机备份没有成功，3点自动脱机备份的日志里提示：“SQL1032N  No start database manager command was issued.  SQLSTATE=57019
DB20000I  The TERMINATE command completed successfully.
SQL1032N  No start database manager command was issued.”
看db2diag应该是在做完0点30分的TSM数据库备份之后，3点自动脱机备份之前的这段时间（1点04分左右），实例宕掉了。。

下边是今天凌晨的db2diag.log:

2007-03-28-00.30.11.465737   Instance:db2inst1   Node:000
PID:55938(db2loggr (SHDATA) 0)   TID:1   Appid:none
data protection  sqlpghck Probe:1390

ExtNum 5340, state 401, baselsn 0000004C91900000 nextlsn 0000004C9550BA0A

2007-03-28-00.30.24.355217   Instance:db2inst1   Node:000
PID:51096(db2agent (LOSHDATA) 0)   TID:1   Appid:*LOCAL.db2inst1.0FD137163009
database utilities  sqlubcka Probe:0   Database:SHDATA

Starting a full database backup.

2007-03-28-01.02.51.525154   Instance:db2inst1   Node:000
PID:25542(db2hmon 0)   TID:1   Appid:none
base sys utilities  sqleagnt_sigsegvh Probe:1

Error in agent servicing application with coor_node:
0x2FF1B04C : 0x0000                                     ..

2007-03-28-01.02.51.732177   Instance:db2inst1   Node:000
PID:25542(db2hmon 0)   TID:1   Appid:none
base sys utilities  sqleagnt_sigsegvh Probe:2

Error in agent servicing application with coor_agent_index:
0x2FF1B04E : 0x0001                                     ..

2007-03-28-01.02.51.828163   Instance:db2inst1   Node:000
PID:25542(db2hmon 0)   TID:1   Appid:none
base sys utilities  sqleagnt_sigsegvh Probe:3

Error in agent servicing application with CLIENT PID:
0x2FF1B054 : 0x30                                       0

2007-03-28-01.02.51.924171   Instance:db2inst1   Node:000
PID:25542(db2hmon 0)   TID:1   Appid:none
base sys utilities  sqleagnt_sigsegvh Probe:4

Error in agent servicing application with INBOUND APPLICATION ID:
0x20239763 : 6462 3268 6D6F 6E                          db2hmon

2007-03-28-01.02.52.032175   Instance:db2inst1   Node:000
PID:25542(db2hmon 0)   TID:1   Appid:none
base sys utilities  sqleagnt_sigsegvh Probe:5

Error in agent servicing application with INBOUND SEQUENCE NUMBER:
0x20239784 : 0x0000                                     ..

2007-03-28-01.02.52.116224   Instance:db2inst1   Node:000
PID:25542(db2hmon 0)   TID:1   Appid:none
base sys utilities  sqleagnt_sigsegvh Probe:8

Error in agent servicing application with AUTHORIZATION ID:
0x30116E39 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
0x30116E49 : 0000 0000 0000 0000 0000 0000 0000 00      ...............

2007-03-28-01.02.52.218166   Instance:db2inst1   Node:000
PID:25542(db2hmon 0)   TID:1   Appid:none
base sys utilities  sqleagnt_sigsegvh Probe:9

Error in agent servicing application with PRODUCT SIGNATURE:

2007-03-28-01.02.52.286395   Instance:db2inst1   Node:000
PID:25542(db2hmon 0)   TID:1   Appid:none
base sys utilities  sqleagnt_sigsegvh Probe:10

Error in agent servicing application with APPLICATION NAME:

2007-03-28-01.02.52.359640   Instance:db2inst1   Node:000
PID:25542(db2hmon 0)   TID:1   Appid:none
oper system services  sqloEDUCodeTrapHandler Probe:10

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.

2007-03-28-01.02.52.596376   Instance:db2inst1   Node:000
PID:25542(db2hmon 0)   TID:1   Appid:none
oper system services  sqloEDUCodeTrapHandler Probe:20

Signal number received

0x2FF1B100 : 0x0000000B                                 ....

PID:25542 TID:1 Node:000 Title: siginfo_t...

0x2FF1B3B0 : 0000 000B 0000 0000 0000 0033 0000 0000    ...........3....
0x2FF1B3C0 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
0x2FF1B3D0 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
0x2FF1B3E0 : 0000 0000 0000 0000 0000 0000 0000 0000    ................

PID:25542 TID:1 Node:000 Title: SQLE_AGENTCB
Dump File:/home/db2inst1/sqllib/db2dump/255421.000

PID:25542 TID:1 Node:000 Title: SQLE_AGENT_PRIVATECB
Dump File:/home/db2inst1/sqllib/db2dump/255421.000

PID:25542 TID:1 Node:000 Title: SQLE_MASTER_APP_CB
Dump File:/home/db2inst1/sqllib/db2dump/255421.000

PID:25542 TID:1 Node:000 Title: SQLE_APP_CB
Dump File:/home/db2inst1/sqllib/db2dump/255421.000

PID:25542 TID:1 Node:000 Title: SQLE_COORDINATOR_CB
Dump File:/home/db2inst1/sqllib/db2dump/255421.000

2007-03-28-01.03.44.599230   Instance:db2inst1   Node:000
PID:16866(db2gds 0)   TID:1   Appid:none
oper system services  sqloEDUSIGCHLDHandler Probe:50

Detected the death of an EDU with process id 25542
The signal number that terminated this process was 11
Look for trap files (t25542.*) in the dump directory


2007-03-28-01.03.45.262033   Instance:db2inst1   Node:000
PID:16866(db2gds 0)   TID:1   Appid:none
oper system services  sqloEDUCodeTrapHandler Probe:10

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.

2007-03-28-01.03.45.437825   Instance:db2inst1   Node:000
PID:16866(db2gds 0)   TID:1   Appid:none
oper system services  sqloEDUCodeTrapHandler Probe:20

Signal number received

0x2FF20E10 : 0x00000006                                 ....

PID:16866 TID:1 Node:000 Title: siginfo_t...

0x2FF210C0 : 0000 0006 0000 0000 0000 0009 0000 0000    ................
0x2FF210D0 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
0x2FF210E0 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
0x2FF210F0 : 0000 0000 0000 0000 0000 0000 0000 0000    ................

2007-03-28-01.03.45.593677   Instance:db2inst1   Node:000
PID:51096(db2agent (LOSHDATA) 0)   TID:1   Appid:*LOCAL.db2inst1.0FD137163009
database utilities  sqlubcka Probe:128   Database:SHDATA

Estimated size of backup in bytes:

0x2FF173B8 : 0x00000004386F5000                         ....8oP.

2007-03-28-01.03.45.801191   Instance:db2inst1   Node:000
PID:51096(db2agent (LOSHDATA) 0)   TID:1   Appid:*LOCAL.db2inst1.0FD137163009
database utilities  sqlubcka Probe:128   Database:SHDATA

Actual size of backup in bytes:

0x2FF173C0 : 0x0000000439005000                         ....9.P.

2007-03-28-01.03.45.917927   Instance:db2inst1   Node:000
PID:51096(db2agent (LOSHDATA) 0)   TID:1   Appid:*LOCAL.db2inst1.0FD137163009
database utilities  sqlubcka Probe:130   Database:SHDATA

Backup Complete.

2007-03-28-01.03.46.341226   Instance:db2inst1   Node:000
PID:21890(db2sysc 0)   TID:1   Appid:none
base sys utilities  sqleChildCrashHandler Probe:15

DiagData
0x10008A4C : 416E 2045 4455 2063 7261 7368 6564 2E      An EDU crashed.

2007-03-28-01.03.46.563302   Instance:db2inst1   Node:000
PID:21890(db2sysc 0)   TID:1   Appid:none
base sys utilities  sqleChildCrashHandler Probe:16

DiagData
0x2FF212C4 : 0x000041E2                                 ..A?

2007-03-28-01.03.46.692058   Instance:db2inst1   Node:000
PID:21890(db2sysc 0)   TID:1   Appid:none
base sys utilities  sqleChildCrashHandler Probe:17

DiagData
0x2FF212C8 : 0x00000101                                 ....

2007-03-28-01.03.46.830061   Instance:db2inst1   Node:000
PID:21890(db2sysc 0)   TID:1   Appid:none
base sys utilities  sqleChildCrashHandler Probe:18

DiagData
0x2FF212CC : 0xFFFFFFFF                                 

itubie

不是这样的

你的锁还是有问题

估计connections也有问题
估计且费时间呢