Guys,
Thanks a lot for your valuable suggestions and help.
Best Regards
Parthahs
>
>
> 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]
>
>
>
>
>




__________________________________
Do you Yahoo!?
Yahoo! Mail Address AutoComplete - You start. We finish.
http://promotions.yahoo.com/new_mail

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