Re: [Info-Ingres] Journal Analyzer.

[Berry, J (Joan)]

Thanks Paul, this is really helpful.

Joan.

-----Original Message-----
From: info-ingr...@kettleriverconsulting.com
[mailto:info-ingr...@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

[ingres...@gmail.com]

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

[Paul White]

Mike wrote

> 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.

Maybe emails with attachments are not allowed in comp.databases.ingres.
There does not seem to be a provision for adding attachments via the
groups.google interface.
I've registered for the community wiki, waiting on a response.
If someone else has time to publish it at the wiki I'd be very happy. Please
feel free to improve on it.
otherwise I'll be back in my office in a couple of days.

If you are a list member you can see it here.
http://www.kettleriverconsulting.com/mailman/private/info-ingres/2008-May/00
2567.html

Maybe someone can consider opening the archives to the community?

Paul

[Michael Leo]

Paul White wrote:

Mike wrote

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.

Maybe emails with attachments are not allowed in comp.databases.ingres.
There does not seem to be a provision for adding attachments via the
groups.google interface.

Attachments to newsgroup articles are usually achieved via some sort of encoding mechanism.
Various advanced news readers can re-assemble such attachments even if they are split
across multiple posts.

As for info-ingres, there is a 600kb limit to the size of attachments.

Although many are fans of attachments, other than the occasional screen shot
in compressed jpg or png, are huge attachments useful?

I've registered for the community wiki, waiting on a response.
If someone else has time to publish it at the wiki I'd be very happy. Please
feel free to improve on it.
otherwise I'll be back in my office in a couple of days.

If you are a list member you can see it here.
http://www.kettleriverconsulting.com/mailman/private/info-ingres/2008-May/00
2567.html

Maybe someone can consider opening the archives to the community?

This archive has been made public.  It can be reached at

  http://www.kettleriverconsulting.com/pipermail/info-ingres/

However, there shouldn't be more there than there is in Google Groups.  Certainly
not time-wise.  I wish I could have brought the 10 years of archive from Caribou Lake,
but alas it was overlooked and now it is too late.

Paul

Cheers,

Mike Leo