Logical Log usage 
Author Message
 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



Wed, 18 Jun 1902 08:00:00 GMT
 Logical Log usage

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


Quote:

> 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



Wed, 18 Jun 1902 08:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Logical log usage and long transactions

2. Freeing logical logs (log usage script)

3. Calculating Usage of Logical Logs

4. logical restore - end log marked as end log ?

5. Physical Log and Logical Log

6. Log buffer usage and log page splits

7. DB2 6.1 Usage of logical volumes as container ...

8. Changing the logical name of data and log files

9. Change logical data/log file name

10. How do you rename logical data/log files in sql server 7.0

11. deciding on logical log backup strategy - advice, anyone?

12. ISA slow with logical logs


 
Powered by phpBB® Forum Software