Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
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.
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.