How to adjust the number of statements in the DB2 Top SQL Performance Tree (4375749)

지금 지원 담당자와 채팅

반품

피드백 제출됨

이 문서로 해당 문제가 해결되었습니까?

평가 결과 선택

제목

How to adjust the number of statements in the DB2 Top SQL Performance Tree
설명

Can the number of statements in the DB2 Top SQL Performance Tree be increased from 25?
해결 방안
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
1. Navigate to Administration | Rules & Notifications | Manage Registry Variables
2. Edit the Registry Variable DB2-History_Tree_Tops_Number_of_Tops
3. Click the Change button next to Global Default
4. Set the radio button to Status Value in the popup and enter the desired number of rows in the field Enter desired value
5. Click the Finish button

피드백 제출됨

이 문서로 해당 문제가 해결되었습니까?

평가 결과 선택

권장 콘텐츠

제품:: Foglight
7.1.0, 6.3.0, 6.1.0, 6.0.0, 5.9.8; Foglight for Databases
7.1.0, 6.3.0, 6.1.0, 6.0.0, 5.9.7

제목