Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2014
    Posts
    6

    Unanswered: DB2 audit performance impact

    Hi,

    Client requested to audit all user SQL statements to check who is accessing the data. We are going to implement `execute' audit policy. How much it will impact performance of the database??

  2. #2
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    Hi,

    You can analyse the impact of auditing on your system inspecting the following monitor elements:
    audit_subsystem_wait_time and audit_file_write_wait_time
    Regards,
    Mark.

  3. #3
    Join Date
    Jul 2014
    Posts
    6
    Mark,

    Thank you for the post.

    How I check performance with audit_subsystem_wait_time and audit_file_write_wait_time?

  4. #4
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    audit_subsystem_wait_time and audit_file_write_wait_time
    You can compare their values with the corresponding total_wait_time counter, for example, to understand the impact of auditing.
    Regards,
    Mark.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •