Hi Paul
I would like a copy of your nawk script please.
Stephen
-----Original Message-----
From: info-ingres-bounces@[EMAIL PROTECTED]
On Behalf Of Paul
White
Sent: 02 May 2008 13:00
To: Ingres and related product discussion forum
Subject: Re: [Info-Ingres] Journal Analyzer.
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 re****t, 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@[EMAIL PROTECTED]
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 re****t
> 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@[EMAIL PROTECTED]
mailing list
Info-Ingres@[EMAIL PROTECTED]
information contained in this e-mail is confidential and is intended
only for the named recipient(s). If you are not the intended recipient,
you must not copy, distribute or take any action or reliance on it. If you
have received this e-mail in error, please notify the sender. Any
unauthorised disclosure of the information contained in this e-mail is
strictly prohibited.
The views and opinions expressed in this e-mail are the senders own and do
not necessarily represent the views and opinions of Falkirk Council.
*********************************************************************************************
|
