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

    Unanswered: Monitoring on tables

    Hi,

    We have a concept in sql server as change tracking, that enables applications to obtain only changes(DML changes like Insert, Delete and Update) that have been made to the user tables, along with the information about those changes & we can easily disable these on a table in sql server.

    Is there any functionality in db2luw, as i can do the same.
    can some one kindly explain me this

    Is this the same applicable for this too
    ALTER TABLE tablename ACTIVATE NOT LOGGED INITIALLY
    Thanks
    Last edited by HABBIE; 12-19-14 at 03:58.

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

    Have a look at the following topics: Auditing DB2 activities and Identifying the statements that affect a table.
    Regards,
    Mark.

  3. #3
    Join Date
    Jul 2014
    Posts
    294
    Thanks mark , it's a great help.
    I found this from the above link.
    MON_OBJ_METRICS EXTENDED

    IF i disable this parameter at instance level((DFT_MON_TABLE)) . will it remove monitoring on all the table under that particular instance ?
    Last edited by HABBIE; 12-19-14 at 05:35.

  4. #4
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    DFT_MON_TABLE is unrelated to all above.

    You should read the 1-st link to achieve what you have in MSSQL. 2-nd link can be useful for performance investigations mostly.
    To start some particular table auditing you use AUDIT TABLE mytable USING POLICY mypolicy.
    To stop some particular table auditing you use AUDIT TABLE mytable REMOVE POLICY.

    You can audit entire database using the same policy with EXECUTE category but I wouldn't recommend it due to performance reasons.
    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
  •