DML Statments

d_mohan81 · #1 (**permalink**) 09-25-07, 04:08

Hi,
I want to track all the DML statments which are fired in the UDB database.Is there any tables available or any method ..?

For eg: In oracle we have v$sql table.Same thing do we have in UDB.
Iam using db2 v.8.1 and fix pack

rahul_s80 · #2 (**permalink**) 09-25-07, 04:15

look for db2audit

d_mohan81 · #3 (**permalink**) 09-25-07, 05:22

Thanks for the info.Is that db2audit is will consume memeory space..? Thanks.

rahul_s80 · #4 (**permalink**) 09-25-07, 05:40

yup, v9 viper2 beta db2audit is far more efficient and robust as that of its ancestor v8

d_mohan81 · #5 (**permalink**) 09-25-07, 05:50

Do we have only this method db2audit..? or else do we have any other method?

Internet Services

Web Development

Digital Marketing

Consumer Tech