RE: Tool to Record Database changes (inserts, deletes, etc.)
> -----Original Message-----
> From: informix-list-bounces@iiug.org
> [SMTP:informix-list-bounces@iiug.org] On Behalf Of Paul Watson
> Sent: Wednesday, January 11, 2006 5:22 PM
> To: informix-list@iiug.org
> Subject: Re: Tool to Record Database changes (inserts, deletes,
> etc.)
>
> Madison Pruet wrote:
>
> >
> > <pookguy88@gmail.com> wrote in message
> > news:1136849727.251928.189330@g43g2000cwa.googlegroups.com...
> > > Is there a tool that somehow records what activity there was in
> the
> > > database for a certain time period?
> > >
> > > I have a front-end program that has Informix on the backend and I
> want
> > > to record what changes it did to the database when I do certain
> things.
> > > So I need a program that I can start and stop recording when I do
> > > things and/or record a pre-set time period of database activity.
> > >
> > > Thanks
> > >
> >
> > Question --- would a log analysis utilty be a desirable thing to
> have? We
> > have onlog, but it only dumps the logs - it does not really perform
> any
> > analysis.
> >
> >
>
> A support tool that could extract information for the onlog output
> would
> be useful. It would beat having to write and maintain AND port
> scripts
>
> Cheers
> Paul
[Bill Dare]
I'll second that. Also, the capability to analyze logs that are
no longer available on-line would be nice. Just last week I had to do a
point-in-time restore to a test instance in order to get a look at some
old logs. Then the typical sed/awk scripts to find what I was looking
for and then dump the transaction in question. Found what I was looking
for, but a real pain.
Bill
> Paul Watson
> Oninit Ltd
> Tel : +44 1414161772
> Cell : +44 7818 003457
> Web : www.oninit.com
> _______________________________________________
> Informix-list mailing list
> Informix-list@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list
In version 10 onbar will extract logical logs from backup like onlog.
Here is some output for the onbar --
You have to use onbar but it does work.
LOGICAL-LOG(S) DISPLAY
======================
For IBM Informix Dynamic Server:
{-P} {-n <log unique identifier> | <starting log unique
identifier -
ending log unique identifier>} [-l] [-q] [-b] [-u <user name>]
[-t <TBLspace number>] [-x <transaction number]
-P Print backed up logical-log(s) information
-n Display the specified log identifier(s)
-l Display maximum information about each log record
-q Do not display program header
-b Display information about logged BLOB pages
-u Display the specified user(s)
-t Display the specified TBLspace(s)
-x Display the specified transaction(s)