Reading log records.

Posted in 2000

James_Roach@tnt.com.au — Thu, 7 Dec 2000 18:36:53 +1100 — source: Informix-list mailing list archive (1991-1998)

Hi, I need to be able to interpret the output of onlog -l for some records that were deleted from a production table. (a user accidently deleted 26,000 odd records they should not have :( ) I have all the HDELETE log entries from an onlog -l output for the user/transaction/tablespace affected. I can interpret the char, integer and date fields o.k. but not the DECIMAL(8,2) field. Does anyone know its storage format (apart from being 6 bytes total in size). HP-UX 11.00, IDS 7.31FC4. (Omniback II Ver 3.0) If not I'll have to level 0 archive/restore before delete on dbspace/restore level 0 archive on Sunday :( (30GB database using onbar and hope I don't get a bad tape :(( ) Or is there a utility for restoring a table from an onbar backup? Thanks in advance, James