SEO

Hi Joan,

I found the journal analyser to be very slow when trying to retrieve
more than few thousand transactions. Auditdb is several magnitudes
faster. You run auditdb on the server. Capture the output to text file
and transfer it to the analysis tool of your choice. The output will
give you just insert/delete/update. If you want to track queries you'll
need to turn on auditing. Something like this:

Under windows
auditdb mydb #c123 -b02-may-2008:00:00:00 -e03-may-2008:00:00:00 >
audit20030502.txt

Under unix
auditdb mydb \#c123 -b02-may-2008:00:00:00 -e03-may-2008:00:00:00 >
audit20030502.txt

If you wanted to track changes for user pwhite on table customer

auditdb mydb -b01-may-2008:07:30:00 -e01-may-2008 -ijpwhite
-table=customer > customer.txt


A drawback of auditdb when you are filtering by user or table is that
all transaction ids are recorded in the report, not just for the
particular table / user you are searching. I have a nawk script which
strips these out and summarises just the data. Let me know if you want
a copy.


Paul

-----Original Message-----
From: info-ingres-bounces@kettleriverconsulting.com
[mailto:info-ingres-bounces@kettleriverconsulting.com] On Behalf Of
Betty & Karl Schendel
Sent: Friday, 2 May 2008 8:54 PM
To: Ingres and related product discussion forum
Subject: Re: [Info-Ingres] Journal Analyzer.


On May 2, 2008, at 4:02 AM, Berry, J (Joan) wrote:

>
> I'm using the Ingres Journal Analyzer and remote desk topping from a
> XP which is using 9.2.0 client to a 2.6 IngresII database, ...

It's possible that the more recent IJA is looking for some feature that
isn't in the
2.6 installation?

>
> What I'm after is a audit of who's doing what over a 24 hour
> period, is it the right piece of Ingres to use, or am I completely
> in the wrong area and I should be looking at a different report
> method?
>

IJA is a reasonable thing to want to use for this. You could try
auditdb as well, which will
give you more or less the same information from the command line.

Karl

_______________________________________________
Info-Ingres mailing list
Info-Ingres@kettleriverconsulting.com
http://www.kettleriverconsulting.com...fo/info-ingres