var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
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.
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
for the db name
select name,hex(partnum) from sysdatabases;
for the tables name
select hex(partnum), dbsname,tabname from systabnames
link the 'link' column with the 'addr' column to proceed to transaction sequence
Last edited by begooden-it; 04-05-12 at 12:30.
Thanks Begooden-it. It is very helpful.