Results 1 to 9 of 9

Thread: OnLog

  1. #1
    Join Date
    Jan 2002
    Posts
    11

    Unanswered: OnLog

    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

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    What do you need ?

  3. #3
    Join Date
    Jan 2002
    Posts
    11
    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

  4. #4
    Join Date
    Feb 2002
    Posts
    2,232
    Can you post a snapshot of the output ?

  5. #5
    Join Date
    Jan 2002
    Posts
    11
    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

  6. #6
    Join Date
    Feb 2002
    Posts
    2,232
    Is this a partial dump ? How many updates were made ?

  7. #7
    Join Date
    Jan 2002
    Posts
    11
    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

  8. #8
    Join Date
    Feb 2002
    Posts
    2,232
    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.

  9. #9
    Join Date
    Jan 2002
    Posts
    11
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •