Reading the UDB logs

[login to unmask email]

Reading the UDB logs
On UDB, does anyone know if there's a way to extract INSERTs from the logs
using what's shipped with the product (no 3rd party tools)? In this case,
restoring the tablespace and rolling forward won't give what we need
because shortly after the data is inserted into the table, it's deleted.

Thanks.

Bill



Mark Ruhe

Re: Reading the UDB logs
(in response to wjmartin@HOUSEHOLD.COM)
The only method for doing this would be to write your own program. UDB does
not ship with a log analysis tool. It only supplies an API to allow you to
read from it. You would have to write a program to access this API.

-----Original Message-----
From: William J. Martin [mailto:[login to unmask email]
Sent: Thursday, December 12, 2002 2:32 PM
To: [login to unmask email]
Subject: [DB2-L] Reading the UDB logs


On UDB, does anyone know if there's a way to extract INSERTs from the logs
using what's shipped with the product (no 3rd party tools)? In this case,
restoring the tablespace and rolling forward won't give what we need
because shortly after the data is inserted into the table, it's deleted.

Thanks.

Bill





Steve Westfall

Re: Reading the UDB logs
(in response to Mark Ruhe)
William,

Have you considered using an event monitor to capture information about
INSERTs? An event monitor can capture the text of dynamic SQL statements.

(You didn't say what you're trying to accomplish, so this may or may not
provide what you need.)

Steve Westfall
Equifax, Inc.
Lombard, Illinois



|---------+---------------------------->
| | Mark Ruhe |
| | <[login to unmask email]|
| | COM> |
| | Sent by: DB2 Data|
| | Base Discussion |
| | List |
| | <[login to unmask email]|
| | LASSOC.COM> |
| | |
| | |
| | 12/12/2002 03:05 |
| | PM |
| | Please respond to|
| | DB2 Data Base |
| | Discussion List |
| | |
|---------+---------------------------->
>---------------------------------------------------------------------------------------------------------------|
| |
| To: [login to unmask email] |
| cc: |
| Subject: Re: Reading the UDB logs |
| |
>---------------------------------------------------------------------------------------------------------------|



The only method for doing this would be to write your own program. UDB
does not ship with a log analysis tool. It only supplies an API to allow
you to read from it. You would have to write a program to access this API.


-----Original Message-----
From: William J. Martin [mailto:[login to unmask email]
Sent: Thursday, December 12, 2002 2:32 PM
To: [login to unmask email]
Subject: [DB2-L] Reading the UDB logs





On UDB, does anyone know if there's a way to extract INSERTs from the logs
using what's shipped with the product (no 3rd party tools)? In this case,
restoring the tablespace and rolling forward won't give what we need
because shortly after the data is inserted into the table, it's deleted.


Thanks.


Bill




the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list
can