Help with logical logs.
Posted in 2000
Topics: Logging & Checkpoints
Hi all, On one of our servers, the logical logs are getting filled up very quickly. It started happening recently. What is best way to identify wich session causing the problem., Please help. Regards Aboo
First off, how big are you logical logs. It should take some time to
completely fillup you logical logs, unless they're configured way too small.
Any process that fills the logical logs should stand out by running a
'onstat -u'. The process will have lots of writes and will have been running
for longer than a normal process. Good luck.
"Aboobacker V V" <aboo@syd-co.au.dhl.com> wrote in message
news:8oodlm$h9r$1@news.xmission.com...
>
> Hi all,
>
> On one of our servers, the logical logs are getting filled up very
> quickly. It started happening recently. What is best way to identify
> wich session causing the problem.,
>
> Please help.
>
> Regards
>
> Aboo
>
>
>
try using 'onlog' to look at what's stored in the log, then work
backwards from there...
In article <8oodlm$h9r$1@news.xmission.com>, Aboobacker V V <aboo@syd-
co.au.dhl.com> writes
>
>Hi all,
>
>On one of our servers, the logical logs are getting filled up very
>quickly. It started happening recently. What is best way to identify
>wich session causing the problem.,
>
>Please help.
>
>Regards
>
>Aboo
>
>
>
Andrew Lennard andy@kontron.demon.co.uk