tag:blogger.com,1999:blog-1063887191564592297.post2723377843305086538..comments2022-02-19T18:06:39.375-08:00Comments on DB2 Nerd: DB2 Audit Facility for DummyUnknownnoreply@blogger.comBlogger3125tag:blogger.com,1999:blog-1063887191564592297.post-5774921509421102812012-08-09T21:35:53.951-07:002012-08-09T21:35:53.951-07:00Hi,
I have archived the audit logs and imported t...Hi,<br /> I have archived the audit logs and imported to the audit tables created. But I am not able to get the output what I am requiring. I mean I am expecting the which user has logged in,from which ip, what query he/she has fired, is that insert,updated,delete etc.<br /><br />Can you please guide me.<br /><br />Regards,<br />Kiran.M.K.CoolKiranhttps://www.blogger.com/profile/00934902079715568610noreply@blogger.comtag:blogger.com,1999:blog-1063887191564592297.post-82928164080886951272010-04-12T14:27:24.377-07:002010-04-12T14:27:24.377-07:00The extract command now works only with archived l...The extract command now works only with archived log files. It is no longer possible to extract from the active log.Unknownhttps://www.blogger.com/profile/12607481695626442427noreply@blogger.comtag:blogger.com,1999:blog-1063887191564592297.post-63706598657745693312009-09-09T04:02:17.155-07:002009-09-09T04:02:17.155-07:00Hi,
I have db2 v9.7 on linux RH5.
The command : ...Hi, <br />I have db2 v9.7 on linux RH5.<br /><br />The command : <br />db2audit extract delasc ';' , category checking, validation database<br /><br />return an error :<br /><br />AUD0002N Syntax error. Usage: ...<br />AUD0001N Operation failed.Carlitohttps://www.blogger.com/profile/05359144352738733397noreply@blogger.com