Figure 10 shows the information about the database objects that were changed. These dropped indexes indicate the cause for the many table scans and the reason for the impact on  performance. In IBM Data Server Manager, you can set the threshold value for SQL so that if any of the SQL is running  for a long time, the user is notified. Figure 10. IBM Data Server Manager Track Change feature being used to capture an object update Setting the threshold value for SQL performance 7 IBM Data Server Manager Overview and Performance Analysis