yangshuaiyin 发表于 2006-06-26 16:21

求助！哪位DB2高手路过能帮忙看看。急！！

ADM1823EThe log is full.The active log is held by application handle "0".
Terminate this application by COMMIT, ROLLBACK or FORCE APPLICATION.

2006-06-25-23.08.51.385084   Instance:ldapdb2   Node:000
PID:3031188(db2bm.950280.0 0)   TID:1   Appid:*LOCAL.ldapdb2.0C08B5150324
data protectionsqlpWriteLR Probe:980   Database:ITIMDB

DIA8309C Log file was full.
ZRC=0x85100009
我用list applications 看就没有application handle "0"。我曾把日志加大过，感觉那样治标不治本。过短时间就 Log file was full。哪位好心人帮帮忙

yangshuaiyin 发表于 2006-06-26 16:47

在线等

yangshuaiyin 发表于 2006-06-26 17:11

在线等

yangshuaiyin 发表于 2006-06-26 17:34

怎么没人来呀
ADM1823EThe log is full.The active log is held by application handle "0".
Terminate this application by COMMIT, ROLLBACK or FORCE APPLICATION.

2006-06-25-23.08.51.385084   Instance:ldapdb2   Node:000
PID:3031188(db2bm.950280.0 0)   TID:1   Appid:*LOCAL.ldapdb2.0C08B5150324
data protectionsqlpWriteLR Probe:980   Database:ITIMDB

DIA8309C Log file was full.
ZRC=0x85100009
我用list applications 看就没有application handle "0"。我曾把日志加大过，感觉那样治标不治本。过短时间就 Log file was full。哪位好心人帮帮忙

mymm 发表于 2006-06-27 09:03

扩日志文件的数量或大小不行吗？

您做的什么操作？
能不能做到不记日志或多次提交？

dachun264 发表于 2010-03-05 11:25

haddle为0可能是你应用里有两阶段提交，产生了僵尸进程，僵尸进程hold了你的日志，可以通过ps -ef |grep defunct检查是否有僵尸进程，杀死这些僵尸进程就应该好了。
页: [1]
查看完整版本: 求助！哪位DB2高手路过能帮忙看看。急！！