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.
Thank you,
Silviu Stoica

What do you need ?

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,
Silviu Stoica

Can you post a snapshot of the output ?

Of course. Here you are:

27b018 40 BEGIN 121 11582 0 09/09/2002 16:29:47 9031 stipr5
27b040 56 HUPDAT 121 0 27b018 20072e 3630e 0 129 129 1
27b078 52 DELITEM 121 0 27b040 2001b0 3630e 28 1 4
27b0ac 52 ADDITEM 121 0 27b078 2001b0 3630e 30 1 4
27b0e0 56 HUPDAT 121 0 27b0ac 20072e 27e04 0 129 129 1
27b118 52 DELITEM 121 0 27b0e0 2001b0 27e04 32 1 4

addr len type xid id link
27b14c 52 ADDITEM 121 0 27b118 80000001002001b0 8000000100027e04 30 1 4
27b180 56 HUPDAT 121 0 27b14c 800000010020072e 8000000100027e05 8000000100000000 129 129 1
27b1b8 52 DELITEM 121 0 27b180 80000001002001b0 8000000100027e05 32 1 4
27b1ec 52 ADDITEM 121 0 27b1b8 80000001002001b0 8000000100027e05 30 1 4
27b220 56 HUPDAT 121 0 27b1ec 800000010020072e 8000000100027e06 8000000100000000 129 129 1
27b258 52 DELITEM 121 0 27b220 80000001002001b0 8000000100027e06 32 1 4
27b28c 52 ADDITEM 121 0 27b258 80000001002001b0 8000000100027e06 30 1 4
27b2c0 56 HUPDAT 121 0 27b28c 800000010020072e 8000000100027e0c 8000000100000000 129 129 1
27b2f8 52 DELITEM 121 0 27b2c0 80000001002001b0 8000000100027e0c 32 1 4
27b32c 52 ADDITEM 121 0 27b2f8 80000001002001b0 8000000100027e0c 30 1 4
27b360 56 HUPDAT 121 0 27b32c 800000010020072e 8000000100027e0d 8000000100000000 129 129 1
27b398 52 DELITEM 121 0 27b360 80000001002001b0 8000000100027e0d 32 1 4
27b3cc 52 ADDITEM 121 0 27b398 80000001002001b0 8000000100027e0d 30 1 4
27b400 56 HUPDAT 121 0 27b3cc 800000010020072e 8000000100027e0e 8000000100000000 129 129 1
27b438 52 DELITEM 121 0 27b400 80000001002001b0 8000000100027e0e 32 1 4
27b46c 52 ADDITEM 121 0 27b438 80000001002001b0 8000000100027e0e 30 1 4
27b4a0 56 HUPDAT 121 0 27b46c 800000010020072e 8000000100027f01 8000000100000000 129 129 1
27b4d8 52 DELITEM 121 0 27b4a0 80000001002001b0 8000000100027f01 32 1 4


I hope this will help you. Thank you in advance.
Silviu Stoica

Is this a partial dump ? How many updates were made ?

Yes. This is a partial dump. A lot of updates was made. I thought that only a partial dump can be suggestive. If you want the total dump I'll sent you.
Thank you in advance.
Silviu Stoica

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.
Silviu Stoica