hi frnds,

might be small for professionls like you but a big one fr me i have been trying to implement db2audit on my database to monitor the sql queries tat are being used to select update etc by application users as well as db level users i have configured all the parameter for capturing data and extracted the del file as well in to tables but i am not able get the queries that have been queried today since i started db2 audit. and most of the columns give null output and data is every where on the screen . all i need to know is it possible to get just the query executed by who when and where using audit facility if so how to ?