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

On May 4, 10:53*am, "Berry, J \(Joan\)" <j.be...@dl.ac.uk> wrote:
> Thanks Paul, this is really helpful.
>
> Joan.
>
> -----Original Message-----
> From: info-ingres-boun...@kettleriverconsulting.com
>
> [mailto:info-ingres-boun...@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.
Hi Paul,
Do you think you could post this on the ingres community wiki? I use
google groups to read this list and cannot seem to find the files.

Thanks,

Mike


>
> strip_auditdbcan 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.txtstrip_auditdblots*.txt > nice.txt
>
> Good luck
>
> Paul