Read DB2 UDB logs

Deepak Goyal

Read DB2 UDB logs
Hi,

I would like to know, how we can read the DB2 UDB logs means need to find
out the DML operations happened on a database during some timeframe.

How can we do this ? Please do let me know the solution that I can use it now
(means no tool solution, if tool is free then I would prefer that ). I have the
log files stored on unix box.

It's quite urgent. Really appreciate your help.

Thanks

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Leila Hosseini

Re: Read DB2 UDB logs
(in response to Deepak Goyal)
HI
IN unix ,i don't know ,but on z/os you can start trace on STATMENTS.
START TRACE (PERFM) CLASS(3) IFCID(063) DEST(SMF)

although there is lots of information but you can extract statment by RECTRACE from gathered data.I gues on unix will be  the same .
 
L.S.H

--- On Fri, 12/5/08, Deepak Goyal <[login to unmask email]> wrote:

From: Deepak Goyal <[login to unmask email]>
Subject: [DB2-L] Read DB2 UDB logs
To: [login to unmask email]
Date: Friday, December 5, 2008, 1:23 AM

Hi,

I would like to know, how we can read the DB2 UDB logs means need to find
out the DML operations happened on a database during some timeframe.

How can we do this ? Please do let me know the solution that I can use it now
(means no tool solution, if tool is free then I would prefer that ). I have the

log files stored on unix box.

It's quite urgent. Really appreciate your help.

Thanks

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L
list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug
under the Listserv tab. While at the site, you can also access the IDUG Online
Learning Center, Tech Library and Code Place, see the latest IDUG conference
information and much more. If you have not yet signed up for Basic Membership
in IDUG, available at no cost, click on Member Services at
http://www.idug.org/lsms





______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

DB2 DBA Jeffrey Benner

Re: Read DB2 UDB logs
(in response to Leila Hosseini)
I believe there is a db2audit option that tracks DML actions. Otherwise this
is not routinely logged.

On Thu, Dec 4, 2008 at 15:53, Deepak Goyal <[login to unmask email]> wrote:

> Hi,
>
> I would like to know, how we can read the DB2 UDB logs means need to find
> out the DML operations happened on a database during some timeframe.
>
> How can we do this ? Please do let me know the solution that I can use it
> now
> (means no tool solution, if tool is free then I would prefer that ). I have
> the
> log files stored on unix box.
>
> It's quite urgent. Really appreciate your help.
>
> Thanks
>
> ______________________________________________________________________
>
> * IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
> ______________________________________________________________________
>
>
>
> The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L
> list archives, FAQ, and delivery preferences are at
> http://www.idug.org/lsidug under the Listserv tab. While at the site, you
> can also access the IDUG Online Learning Center, Tech Library and Code
> Place, see the latest IDUG conference information and much more. If you
> have not yet signed up for Basic Membership in IDUG, available at no cost,
> click on Member Services at http://www.idug.org/lsms
>
>

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms