[Info-Ingres] Journal Analyzer.

[Berry, J (Joan)]

Hello,

 

I wonder if anyone could point me in the right direction regarding the following problem I'm having with the Ingres Journal Analyzer? (Googling isn't proving very useful and the documentation is only basic !)

 

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, but I either get the following error message

System error, IJA_QueryDatabaseTransaction, failed to query transactions 

because I can't seem to set the right parameters or when I seem to get the right settings the whole thing just hangs and never comes back with anything and that's after picking an actually recent checkpoint.

 

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?

 

Joan.

------------------------------------------------------------------------------------

Joan Berry – Administrative Database Team Leader

STFC - Science & Technology Facilities Council, 
Corporate Information and Communications Technology, Business Technology Unit, S10,

Daresbury Laboratory, Daresbury, Warrington, Cheshire, WA4 4AD.

 

Telephone : +44 (0) 1925  60(3412)

­­­­­­­­­­­­­­­­­­------------------------------------------------------------------------------------

 

[Betty & Karl Schendel]

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

[Berry, J (Joan)]

I will try auditdb and see how far I get with that.

Thank You.

Joan.

Karl

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

[Paul White]

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

[McCulloch, Stephen]

Hi Paul

I would like a copy of your nawk script please.

Stephen

Hi Joan,

Paul

Karl

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