Db2

 View Only
Expand all | Collapse all

Instant logging and log file generation.

  • 1.  Instant logging and log file generation.

    Posted Thu February 02, 2023 09:23 AM
    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
    ------------------------------


  • 2.  RE: Instant logging and log file generation.

    Posted Sat February 04, 2023 01:05 PM
    Hello Ankhur,

    It looks like what you need is an activity event monitor rather than the audit facility :
    Activity event monitoring

    Regards
    --
    Yves-Antoine Emmanuelli

    ------------------------------
    Yves-Antoine Emmanuelli
    ------------------------------