Hi,
I am getting the error as 'Log full' in diaglog and nfy files.
The error message is as below. What should be done in order NOT
to see this message again. I have increased the LOGBUFFSZ to 8MB
from 2MB. I feel that this will help in resolving this issue.
Any suggestions..... For a 3rd party application where you don't
know waht SQLs they run, any advice in fixing the log size.
Pls help..
Thanks in advance.
Parthahs

ADM1823E The log is full. The active log is held by
application handle "636".
Terminate this application by COMMIT, ROLLBACK or FORCE
APPLICATION.
^^
2004-06-13-22.13.18.623811 Instance:pksdb2 Node:000
PID:126168(db2agent (PKSPRODL) 0) TID:1
Appid:NF000001.B0E8.040613165033
data protection sqlpgResSpace Probe:2860 Database:PKSPROD

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




__________________________________
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger.
http://messenger.yahoo.com/

DB2 & UDB email list listserv db2-l LazyDBA home page