Thanks Paul, this is really helpful.

Joan.

-----Original Message-----
From: info-ingres-bounces@kettleriverconsulting.com
[mailto:info-ingres-bounces@kettleriverconsulting.com] On Behalf Of Paul
White
Sent: Friday, May 02, 2008 2:58 PM
To: Ingres and related product discussion forum
Subject: Re: [Info-Ingres] Journal Analyzer.

Ok ok, Due to the high demand, I'll post it
No warranty implied. Sorry bout the unix flavour. (not)

This version just outputs the first x characters of the record. You can
use this tool to find potential problems then the target specific
date/time range to see the whole transaction with the full auditdb
output. One day I'll debug v2 which, almost working, neatly prints out
the entire record.


strip_auditdb can be used in a pipe directly from auditdb

auditdb ... | strip_auditdb > nice.txt

Or by specifying one or more files.

auditdb ... > lots1.txt
auditdb ... > lots2.txt
strip_auditdb lots*.txt > nice.txt

Good luck

Paul