Logical Log usage

Hello, Is there a way to identify what processes are filling out the logical logs?. We have made a software change yesterday, and we have gone from filling out a log file every 45 minutes on average to fill out a log file every 5 minutes. I need to identify and correct the culprit of this behavior. I have been looking at onlog but have not find any clue yet. TIA Tino PS. Informix 7.31 AIX 4.3

Look at sysrstcb.upf_lgrecs. This will give you a count of how many log records have been written by that thread. If you need more detail, you probably will have to correlate the onlog output with the sessions currently running in the server (yuk! this is a bit messy ...) In onlog, transactions are identified by transaction id - labeled "xid". Unfortunately, this isn't visible in onstat. But it is accessible in sysmaster as systxptab.txid. You can join this with sysrstcb to find out which thread has which transaction id at the moment: select t.txid xid, hex(r.address) rstcb, r.username[1,8], r.sid session, r.upf_lgrecs num_log_recs from systxptab t, sysrstcb r where t.address=r.txp; xid rstcb username session num_log_recs 1 0x0A2D1018 informix 1 0 2 0x0A2D1638 informix 0 0 3 0x0A2D1C58 informix 6 0 4 0x0A2D2278 informix 7 0 6 0x0A2D2EB8 kevin 24 686 7 0x0A2D34D8 informix 10 0 8 0x0A2D3AF8 kevin 22 323 7 row(s) retrieved. - Kevin Beck Tino Cremidis <ccremid@saa.noaa.gov> wrote in message news:8inudn$kp5$1@news.xmission.com... > > Hello, > > Is there a way to identify what processes are > filling out the logical logs?. > > We have made a software change yesterday, > and we have gone from filling out a log file every 45 minutes on > average to fill out a log file every 5 minutes. I need > to identify and correct the culprit of this behavior. > > I have been looking at onlog but have not find any clue yet. > > TIA > > Tino > > PS. Informix 7.31 AIX 4.3 > >