Return
-
Title
How to adjust the number of statements in the DB2 Top SQL Performance Tree -
Description
Can the number of statements in the DB2 Top SQL Performance Tree be increased from 25? -
Resolution
By default 25 Top SQL statements are displayed in the DB2 agent SQL Performance tree. This can be increased by changing the registry value DB2-History_Tree_Tops_Number_of_Tops- Navigate to Administration | Rules & Notifications | Manage Registry Variables
- Edit the Registry Variable DB2-History_Tree_Tops_Number_of_Tops
- Click the Change button next to Global Default
- Set the radio button to Status Value in the popup and enter the desired number of rows in the field Enter desired value
- Click the Finish button