【在線求助】- DB2 停止不了，不能使用

pjj0618

詳見(jiàn)：
$ db2start
SQL6036N  START or STOP DATABASE MANAGER command is already in progress.

db2diag.log 片段
2008-06-30-15.36.42.742833+480 I2200494A375       LEVEL: Error
PID     : 467182               TID  : 1           PROC : db2logmgr (YNDCDB) 0
INSTANCE: db2admin             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogFile, probe:3160
MESSAGE : Failed to archive log file S0005875.LOG to USEREXIT from
          /db2_log/DBLOGS/YNDCDB/NODE0000/ with rc = 8.

2008-06-30-15.36.42.743128+480 I2200870A373       LEVEL: Warning
PID     : 467182               TID  : 1           PROC : db2logmgr (YNDCDB) 0
INSTANCE: db2admin             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgRetryFailedArchive, probe:4780
MESSAGE : Still unable to archive log file 5875 due to rc 8 for LOGARCHMETH1
          using method 4 and target .

2008-06-30-15.36.43.869228+480 E2201244A421       LEVEL: Error
PID     : 282796               TID  : 1           PROC : db2tcpcm 0
INSTANCE: db2admin             NODE : 000
FUNCTION: DB2 UDB, common communication, sqlcctcpconnmgr_child, probe:125
MESSAGE : ADM7009E  An error was encountered in the "TCPIP" protocol support.  
          A possible cause is that the maximum number of agents has been
          exceeded.

2008-06-30-15.36.43.869491+480 I2201666A386       LEVEL: Error
PID     : 282796               TID  : 1           PROC : db2tcpcm 0
INSTANCE: db2admin             NODE : 000
FUNCTION: DB2 UDB, common communication, sqlcctcpconnmgr_child, probe:126
MESSAGE : Return code from sqleGetAgent =
DATA #1 : Hexdump, 4 bytes
0x0FFFFFFFFFFF6684 : FFFF E86C   

癥狀
$ db2 connect to yndcdb
SQL30081N  A communication error has been detected.  Communication protocol
being used: "*".  Communication API being used: "*".  Location where the error
was detected: "".  Communication function detecting the error: "create_agent".
Protocol specific error code(s): "54", "*", "*".  SQLSTATE=08001

pjj0618

補(bǔ)充：
DB CFG 片段
(NEWLOGPATH) = /db2_log/DBLOGS/YNDCDB/NODE0000/
First active log file = S0005805.LOG
LOGRETAIN = RECOVERY
USEREXIT = ON
LOGARCHMETH1 = USEREXIT

pjj0618

有知道怎么解決這個(gè)問(wèn)題的兄弟在嗎？
或者，碰到過(guò)類似問(wèn)題的兄弟？

我老婆黑社會(huì)

好象你agent滿了吧
2008-06-30-15.36.43.869228+480 E2201244A421       LEVEL: Error
PID     : 282796               TID  : 1           PROC : db2tcpcm 0
INSTANCE: db2admin             NODE : 000
FUNCTION: DB2 UDB, common communication, sqlcctcpconnmgr_child, probe:125
MESSAGE : ADM7009E  An error was encountered in the "TCPIP" protocol support.  
          A possible cause is that the maximum number of agents has been
          exceeded.

pjj0618

問(wèn)題已解決，重新啟動(dòng)數(shù)據(jù)庫(kù)服務(wù)器，并手動(dòng)歸檔日志解決。

smallzqsky

請(qǐng)問(wèn)怎樣手動(dòng)歸檔日志啊?

fck

應(yīng)該是解決了userexit的問(wèn)題了吧？

huyuhui001

原帖由 smallzqsky 于 2008-7-7 15:47 發(fā)表
請(qǐng)問(wèn)怎樣手動(dòng)歸檔日志啊?

db2 archive log for database DBNAME

huyuhui001

原帖由 pjj0618 于 2008-7-1 15:10 發(fā)表
問(wèn)題已解決，重新啟動(dòng)數(shù)據(jù)庫(kù)服務(wù)器，并手動(dòng)歸檔日志解決。

是不是USEREXIT出了問(wèn)題，比如空間問(wèn)題等？ FAILARCHPATH設(shè)定了嗎？ 把你的解決方案share一下吧，大家都可以從中學(xué)習(xí)。