Finding the length of a transaction

David Juiliano Hello Chris, Here is my solution to finding out the length of a transaction. The transaction must be running at the time you are trying to figure it out though. 1. Run onstat -u and get the address of the user with the transaction. address flags sessid user tty etc etc etc a12dda0 ------- 5 chris 18 ^^^^^^^ 2. Run onstat --x | grep a12dda0 This will return the address of the transaction. address flags userthread etc etc etc a1547f8 -------- a12dda0 ^^^^^^^ 3. Change the address to this format. 0x0A1547F8 basically added 0x0 and then capitalize the letters 4. Go into dbaccess and select sysmaster db. 5. Do the following query. select tx_id from systrans where hex(tx_addr) = '0x0A1547F8' This will return the transaction id. tx_id 10 >From there you should be able to figure out how to use onlog and add up the len column for all xid of 10. Or whatever you figure it to be. Hope this helps. Please feel free to ask any questions about this. Thanks, David Juiliano Informix Support