Re: Process taking most of Logcal Log

Claus Samuelsen wrote: > mohitanchlia@gmail.com wrote: >> >> onlog commands give different information about COMMIT, DELETE etc. >> with the transaction id. Is there a way to tell on which tables these >> transactions are working on or something which gives more information >> about the data in logical log. I was thinking that onlog would show >> the data in the logical log, may be it does and I am just not aware >> of displaying the data in logical log. I was thinking something that >> tells me what data got deleted or inserted and which table was >> affected. > > Output from onlog: > > 2ec044 76 HINSERT 6 0 2ec018 20004c 135 17 > > Column 7 (20004c) is the table's partnumber (in decimal: 2097228). You > can use the decimal value to find the table in the systables catalog table. No need to convert to decimal: where partnum = "0x20004c" ... will work fine.