Process taking most of Logcal Log

Version: IDS 10 Is there a way to tell which process on the box is filling up the logs. I was thinking if there is a way to tell which process / thread is writing the logical logs or filling up the logical logs

mohitanchlia@gmail.com wrote: > Version: IDS 10 > > Is there a way to tell which process on the box is filling up the > logs. I was thinking if there is a way to tell which process / thread > is writing the logical logs or filling up the logical logs > It's the lio vp, except when the logical logs are placed in dbspaces on raw devices - then it's cpu vp using kaio.

Claus Samuelsen wrote: > mohitanchlia@gmail.com wrote: > >> Version: IDS 10 >> >> Is there a way to tell which process on the box is filling up the >> logs. I was thinking if there is a way to tell which process / thread >> is writing the logical logs or filling up the logical logs >> > > It's the lio vp, except when the logical logs are placed in dbspaces on > raw devices - then it's cpu vp using kaio. I think what the poster is asking is which session is filling up the logical logs, not what is actually writing to the logical logs. onstat -g tpf will show the number of log records each thread has written : > onstat -g tpf IBM Informix Dynamic Server Version 10.00.FC6 -- On-Line -- Up 6 days 16:22:11 -- 179276 Kbytes Thread profiles tid lkreqs lkw dl to lgrs isrd iswr isrw isdl isct isrb lx bfr bfw lsus lsmx seq So, do this a few times to see which thread is writing all the "lgrs" : onstat -g tpf | sort -rnk 7 | head | awk '{print $1 " " $7}' Once you know the thread, back track it to the session.