3163 - IBM Db2 查询监视器 - Web 客户端界面研讨会.pdf

1、 IBM Db2 Query Monitor for z/OS-CAE Highlights and Hands-on-Lab Session Code:3163 October 2025 Tom Glaser Contents OVERVIEW INSTRUCTOR LEAD DISCUSSION OF THE WEB CLIENT.2 SETUP LOGGING INTO THE IBM CLIENT CENTER.7 LAB 1 LOGGING ONTO Db2 QUERY MONITOR AND WORKING WITH PROFILES 9 LAB 2 GETTING STARTED

2、.17 LAB 3 CUSTOM VIEWS.28 LAB 4 CHARTING.33 LAB 5 EXPORTING DATA.37 LAB 6 WORKLOAD COMPARISON.39 LAB 7 CONNECTING TO THE PERFORMANCE DATABASE/ARCHIVED DATA 43 LAB 8 ALERTS 46 LAB 9 BUILDING DASHBOARDS WITH OMEGAMON DATA PROVIDER(ODP).81 APPENDIX A.NOTICES.87 APPENDIX B.IBM CLOUD SERVICES DESCRIPTION

3、:TRIAL CLOUD SERVICES.89 APPENDIX C.TRADEMARKS AND COPYRIGHTS.90#TechXchange 2025 Page 2 Overview.These instructions will guide you through the labs for the IBM Db2 Query Monitor for z/OS CAE(Consolidation and Analysis Engine)Highlights;also referred to as the Web Client Interface.Introduction IBM D

4、b2 Query Monitor for z/OS,V3.4(5655-V42)offers current and historical views of query activity throughout Db2 subsystems.It gives you the ability to efficiently customize and tune your SQL workload and Db2 objects to validate the effectiveness of your Db2 subsystems and improve overall performance.It

5、 also offers you extensive choices so you can determine what monitoring information you will gather,and when.Db2 Query Monitor for z/OS enables you to identify problem SQL activity and applications,allowing you to focus your efforts on improvement.Db2 Query Monitor enables you to do the following:o

6、Proactively manage Db2 resources o React quickly and effectively to supply and demand-related Db2 problems(such as those resulting from inefficient SQL or inadequate object structures)o Identify SQL requests that prevent critical requests from completing on schedule o Perform in depth analysis of in