Hi! I have IDS 2000 Version 9.21 FC4 on HP-UX 11.00 and I'm trying to understand the output of onlog -l. Precisely I need to find a row in a table where an update has done. I found the records in the log related to the transaction of my colleague who made the update but now i need a hint to interpret them.
We have a table with about 500000 records and my colleague made, based on a trigger, some updates on it. I need the id of the modified rows in that table to know which of them were modified.
Thank you in advance,
The last part of each record that is updating references the chunk/page/rowid. You need to decipher it. I am referring to the following:
27b14c 52 ADDITEM 121 0 27b118 80000001002001b0 8000000100027e04 30 1 4
If you need help with that, let me know - I will need additional information from you.
Thank you for your response but i'm still in fog . I read the references about onlog -l but this is what i didn't understand. How can I identify chunk/page/rowid. Let me be more clear: How can i find the rowid of a table that was modified when I now chunk/page/rowid from onlog -l?
I hope i was more clearly.