Q: monitoring transaction with onlog

hi everybody, We're using IUS 9.14.UC4 on solaris 2.6 sparc. We're faced to a problem: Our logical files grow too fast. As there 's a lot of bases on this server accessed through Internet, so we'd like to find out which base got the most of transaction. But we can't find enough information on informix Administrator's guide. using the command: onlog -d /var/tmp/informix/ltapedev -u webdb | morehere is our display's sample: addr len type xid id link 1018 40 BEGIN 21 224 0 08/19/99 14:45:34 61064 webdb 1040 56 HUPDAT 21 0 1018 500316 102 0 29 29 1 1078 84 HINSERT 21 0 1040 50031f 4440e 37 10cc 52 ADDITEM 21 0 1078 500320 4440e 1391 1 4 1100 52 ADDITEM 21 0 10cc 500338 4440e 92 1 2 1134 52 ADDITEM 21 0 1100 500339 4440e 92 1 2 1168 100 HINSERT 21 0 1134 500ba6 f91c 55 11cc 52 ADDITEM 21 0 1168 500ba7 f91c 772 1 4 1200 52 ADDITEM 21 0 11cc 500ba8 f91c 28 1 2 1234 88 HINSERT 21 0 1200 500317 124521 43 2018 32 COMMIT 21 0 1234 08/19/99 14:45:35 3018 40 BEGIN 40 224 0 08/19/99 14:45:35 61072 webdb 3040 56 HUPDAT 40 0 3018 500316 102 0 29 29 1 3078 84 HINSERT 40 0 3040 50031f 4440f 37 30cc 52 ADDITEM 40 0 3078 500320 4440f 1391 1 4 3100 52 ADDITEM 40 0 30cc 500338 4440f 92 1 2 3134 52 ADDITEM 40 0 3100 500339 4440f 92 1 2 3168 100 HINSERT 40 0 3134 500ba6 f91d 55 . . . I presume type is the type of transaction, xid is the transaction's id, id is the user 's id. link give us the date and the timestamp. So what does it mean addr, len and the other informations below link? How can we know which base the transaction is attached? thanks for your answer. georges

i apologize: i found a lot of information on the book. Nevertheless i'm trying to find out the base with the tblspace ID. is it possible? georges georges Chaleunsinh a 'crit dans le message <7pjqas$2pq$1@news.imaginet.fr>... >hi everybody, > >We're using IUS 9.14.UC4 on solaris 2.6 sparc. >We're faced to a problem: Our logical files grow too fast. >As there 's a lot of bases on this server accessed through Internet, so we'd >like to find out which base got the most of transaction. >But we can't find enough information on informix Administrator's guide. > >using the command: > onlog -d /var/tmp/informix/ltapedev -u webdb | more>here is our display's sample: >addr len type xid id link >1018 40 BEGIN 21 224 0 08/19/99 14:45:34 61064 >webdb >1040 56 HUPDAT 21 0 1018 500316 102 0 29 >29 1 >1078 84 HINSERT 21 0 1040 50031f 4440e 37 >10cc 52 ADDITEM 21 0 1078 500320 4440e 1391 1 4 >1100 52 ADDITEM 21 0 10cc 500338 4440e 92 1 2 >1134 52 ADDITEM 21 0 1100 500339 4440e 92 1 2 >1168 100 HINSERT 21 0 1134 500ba6 f91c 55 >11cc 52 ADDITEM 21 0 1168 500ba7 f91c 772 1 4 >1200 52 ADDITEM 21 0 11cc 500ba8 f91c 28 1 2 >1234 88 HINSERT 21 0 1200 500317 124521 43 >2018 32 COMMIT 21 0 1234 08/19/99 14:45:35 >3018 40 BEGIN 40 224 0 08/19/99 14:45:35 61072 >webdb >3040 56 HUPDAT 40 0 3018 500316 102 0 29 >29 1 >3078 84 HINSERT 40 0 3040 50031f 4440f 37 >30cc 52 ADDITEM 40 0 3078 500320 4440f 1391 1 4 >3100 52 ADDITEM 40 0 30cc 500338 4440f 92 1 2 >3134 52 ADDITEM 40 0 3100 500339 4440f 92 1 2 >3168 100 HINSERT 40 0 3134 500ba6 f91d 55 >. >. >. >I presume type is the type of transaction, xid is the transaction's id, id >is the user 's id. >link give us the date and the timestamp. So what does it mean addr, len and >the other informations below link? >How can we know which base the transaction is attached? > >thanks for your answer. > >georges > >