Make the number secondary logs larger and also make sure that the size and
number that you make them can be
accomodated in the file system.

Dan Callahan IT Specialist
603-472-4121 t/l 525-4121
[Email address protected]
[Email address protected]




"Parthasarathy
\[Partha\] "
<db2udbdba-ezmlms To
hield-x34213294.x "LazyDBA Discussion"
[Email Address Removed] <[Email address protected]
a.com> cc

06/15/2004 12:14 Subject
AM Log full error message- need some
help










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/


---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: db2udbdba-[Email address protected]



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