Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2011
    Posts
    2

    Unanswered: Set Integrity start /end time

    Hi All

    How can i figure out the start /end time , that set integrity takes on tables.
    set integrity is taking too long some of the days and i would like to analyse the trend

    regards
    Rahul

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

    I don't have an access to any db2 system to check it but, you can try to get this information from the package cache or event monitor for activities.
    Moreover, SET INTEGRITY is an explainable statement, so you can try to analyze access plans of these statements over time.
    Regards,
    Mark.

Posting Permissions

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