Hi Team,
I am currently using Community version, have followed IBM documentation and have configured db2audit process
which generated audit files at respective location then user have to manually execute db2audit archive command to achieved logs file and
have to execute the db2 extract command to extract the archived files into flat ascIII files and then we have to load the files into respective tables.
After that only user can analyze the logs by query the tables. In this whole process lots of manual intervention is required.
Question :- Do we have any config settings or utility with the help of which we can generate logs flat files which include SQL statement event, host, session id, Timestamp and all instantly and automatically. We need instant level logging mechanism to generate flat files for logs of any SQL execution happened or any event triggered in database level.
------------------------------
Ankur Singh
------------------------------