How to trace the database transactions?

Coolhard · #1 (**permalink**) 12-06-06, 01:34

Dear All,

How to track the database transactions in log file?
If someone delete some records from the table,may I know how to check who delete this and when?How to trace it?
May I know we can trace or not?

Thanks,

grofaty · #2 (**permalink**) 12-06-06, 02:10

Hi,
try using event monitor. See administration guide book for details.
Hope this helps,
Grofaty

guyprzytula · #3 (**permalink**) 12-06-06, 02:25

I think audit will be the tool to use
Check infocenter for activate of audit and handling this output

Coolhard · #4 (**permalink**) 12-11-06, 05:07

Hi grofaty,

May I know where can I get the event monitor?
Do u mean window event viewer?

Thanks.

Quote:

Originally Posted by grofaty

Hi,
try using event monitor. See administration guide book for details.
Hope this helps,
Grofaty

guyprzytula · #5 (**permalink**) 12-11-06, 07:28

event monitor is the db2 tool that will monitor some events
(as indicated by the name)
this tool will take snapshots (db2 get snapshot......) to gather specific information from db and clients
see online infocenter or db2 books about this tool / command

Coolhard · #6 (**permalink**) 12-14-06, 03:31

OkThanks a lot for your info,guyprzytula.

Quote:

Originally Posted by guyprzytula

event monitor is the db2 tool that will monitor some events
(as indicated by the name)
this tool will take snapshots (db2 get snapshot......) to gather specific information from db and clients
see online infocenter or db2 books about this tool / command

Internet Services

Web Development

Digital Marketing

Consumer Tech