Thanks Paul, this is really helpful.
Joan.
-----Original Message-----
From: info-ingres-bounces@[EMAIL PROTECTED]
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