How do I Read Enterprise Database Sharing Logs?

[Robert Ameeti]

I have set my Database Sharing Logs to log daily 
to the Data Modification (Individual Records) 
level.  Woo Hoo! Now I have a reason to read them.

I have a record missing from a file and I need to 
find the contents of that record as it existed at 
a previous time. It appears that there are 2 
types of log records that might help me. One 
would be the 'Record Locked' and the other would 
be the 'Commit'. I am looking for the format of 
these log files and direction on what I must do 
to convert them to meaningful information.

Help? Direction? Documentation?





The locked file appears in this format:

Date	Time	Activity
Wed Mar 12 9:00:42 AM status+"OK: Record locked." record="/

The details of this type of record appear in this format:

	status="OK: Record locked."
record="/gaqACfuD0FtZWV0aSwgSW5mYW50BzE <lots of snipped nonsense>

==========================================================

The commit record appears in this format:

Date	Time	Activity
Wed Mar 12 9:00:44 AM commit --- SESSION=300 --- 
DATABASE=101-Visits --- RECORDID=323 --- RECORD=/

The details of this type of record appear in this format:

      COMMAND = commit
      SESSION = 300
     DATABASE = 101-Visits
    RECORD ID = 323
         DATA = œ¿©¿'Ó¿Ameeti, Infant¿1 Yr  ¿1 Yr 
¿-Ù¿¿¿ ¿F¿¿¿ä!¿Ÿ¿¿Adan, Olga¿10431 Lemon 
Ave¿Rancho Cucamonga¿CA¿91737¿Pediatrics¿(909) 
466-6579¿(909) 
466-1389¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿

<lots more of snipped data that in both text and odd characters>

-- 

<><><><><><><><><><><><><><><><><><>
Robert Ameeti

When you're through changing, you're through.
            -- Bruce Barton
<><><><><><><><><><><><><><><><><><>