Results 1 to 3 of 3

Thread: Onlog command

  1. #1
    Join Date
    Aug 2011
    Posts
    5

    Unanswered: Onlog command

    Could you please give me an example on how to find the Table name, Primary key which has been deleted in Informix Log file?

    I tried to use Onlog, got the following information, but I don't know the table name and which record.

    2a02048 588 HDELETE 1243 0 2a02018 4002e7 22001 532
    2a02294 56 DELITEM 1243 0 2a02048 400193 22001 1 1 4

    Please let me know how to link the log information with the data.

    Thanks.

  2. #2
    Join Date
    Sep 2011
    Location
    Pont l'Abbé, Brittany, France
    Posts
    381
    Provided Answers: 1
    Hi,

    HDELETE means Header DELETE ie row delete
    the database key in hexadecimal is the 7th column
    and the table key in hexadecimal is in the 8th column
    followed by the rowid in 9th

    you can find the object names with the following queries

    Code:
    select name,hex(partnum) from sysdatabases;
    for the db name
    and

    Code:
    select hex(partnum), dbsname,tabname from systabnames
    for the tables name

    link the 'link' column with the 'addr' column to proceed to transaction sequence
    Last edited by begooden-it; 04-05-12 at 12:30.

  3. #3
    Join Date
    Aug 2011
    Posts
    5
    Thanks Begooden-it. It is very helpful.

Posting Permissions

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