Setting SQL Archiver options
The SQL Statement Archiver collects data in the background for static SQL statements that have executed on the DB2 instance. You can view metrics for these statements in the Static SQL tab in the Top SQL drilldown.
The Archiver starts to collect data on static SQL as soon as you open the connection. The longer the Archiver runs, the more SQL history you can view on the drilldown. However, running the Archiver requires overhead. As a result, you might not want it activated at all times.
You can use SQL Archive options in the connection profile for a database to control whether the SQL Archiver is on or off. You can also use these options to set capacity for the SQL Archiver.
To change SQL archiving options
-
If Spotlight is currently connected to the database or partition connection for which you are changing archiving options, right-click the connection in the Spotlight browser and select Disconnect.
-
Click the Connect
icon in the Spotlight toolbar to open the Spotlight Connection Manager. -
In the Connections bar on the left, click the category from which to select the Spotlight connection to the database or database partition.
-
Right-click the connection in the list, and select Properties to open the Properties window for the connection. The Details tab on this window is in focus.
-
In the SQL Archive Options section, complete the following:
|
Archive Default Startup |
To turn the Archiver on or off, select Archive SQL statements or Do not archive SQL statements, respectively. |
|
Archive Capacity |
Enter the number of distinct static SQL statements that the Archiver will collect before it starts dropping statements. |
-
Click OK to save the changes.