资料db2课程5 monitor pd

1、Monitoring and Problem DeterminationGrow market shareThrive for excellenceSucceed with smarter solutionsIBM Confidential 2009 IBM Corporation9 slidesGIBloMbIanlfoTremcahtnioonloMgaynSaegrevmiceenstWhy use database monitors?Page 2Page 2PI+E |IBM DB2 AdministrationIBM Confidential 2009 IBM Corporation

2、Global Technology ServicesGrowth ? Thrive for excellence ? Smarter solutionsWays to monitor the database?List applications?Snapshot?Event Monitor?db2pdPage 3Page 3PI+E |IBM DB2 AdministrationIBM Confidential 2009 IBM CorporationGlobal Technology ServicesGrowth ? Thrive for excellence ? Smarter solut

3、ionsLIST APPLICATIONS commandPage 4IBM DB2 AdministrationIBM Confidential 2009 IBM CorporationGlobal Technology ServicesGrowth ? Thrive for excellence ? Smarter solutionsFORCE APPLICATION commandPage 5IBM DB2 AdministrationIBM Confidential 2009 IBM CorporationGlobal Technology ServicesGrowth ? Thriv

4、e for excellence ? Smarter solutionsDatabase monitor When?Page 6Page 6PI+E |IBM DB2 AdministrationIBM Confidential 2009 IBM CorporationGlobal Technology ServicesGrowth ? Thrive for excellence ? Smarter solutionsDatabase monitor When?Page 7Page 7PI+E |IBM DB2 AdministrationIBM Confidential 2009 IBM C

5、orporationGlobal Technology ServicesGrowth ? Thrive for excellence ? Smarter solutionsSnapshot Monitor CLP commandsPage 8Page 8PI+E |IBM DB2 AdministrationIBM Confidential 2009 IBM CorporationGlobal Technology ServicesGrowth ? Thrive for excellence ? Smarter solutionsSnapshot Monitor taking snapshot

6、sPage 9Page 9PI+E |IBM DB2 AdministrationIBM Confidential 2009 IBM CorporationGlobal Technology ServicesGrowth ? Thrive for excellence ? Smarter solutionsEvent MonitorPage 10Page1P0I+E|IBM DB2 AdministrationIBM Confidential 2009 IBM CorporationGlobal Technology ServicesGrowth ? Thrive for excellence

7、 ? Smarter solutionsIntroduction of db2pdPage 11IBM DB2 AdministrationIBM Confidential 2009 IBM CorporationGlobal Technology ServicesGrowth ? Thrive for excellence ? Smarter solutionsWhat to think when you face a problemPage 12Page1P2I+E|IBM DB2 AdministrationIBM Confidential 2009 IBM CorporationGlo

8、bal Technology ServicesGrowth ? Thrive for excellence ? Smarter solutionsWhat data should I collect? Diagnostic data and data checklistPage 13Page1P3I+E|IBM DB2 AdministrationIBM Confidential 2009 IBM CorporationGlobal Technology ServicesGrowth ? Thrive for excellence ? Smarter solutionsDiag levelsP

9、age 14 Page 14IBM DB2 AdministrationIBM Confidential 2009 IBM CorporationGlobal Technology ServicesGrowth ? Thrive for excellence ? Smarter solutionsDiagnostic Log Analysis Tool: db2diag?db2diag A?db2diag -t 2011-09-17-13.00.00?db2diag -l error,severe?db2diag t 2011-09-17-13.00.00 -lerror,severePage

10、 15Page1P5I+E|IBM DB2 AdministrationIBM Confidential 2009 IBM CorporationGlobal Technology ServicesGrowth ? Thrive for excellence ? Smarter solutionsdb2support对 DB2问题收集信息时，您需要运行的最重要的 DB2 实用程序是db2support。db2support 实用程序将自动收集所有可用的 DB2 诊断信息和系统诊断信息。它还有一个可选的交互式“问与答”会话，该会话会 提出有关问题的详情。 对于调试问题所需的大多数信息的收集而言，

11、以下基本调用通常已经足 够（注意，如果使用 -c 选项，那么该实用程序将建立与数据库的连接）：db2support -d -c输出的收集非常方便，并且会存储在压缩的 ZIP 归档 db2support.zip 中， 以便可以很轻松地在任何系统上对其进行传送和解压缩。 Page 16IBM DB2 AdministrationIBM Confidential 2009 IBM CorporationGlobal Technology ServicesGrowth ? Thrive for excellence ? Smarter solutionsDB2 TracePage 17Page1P7I+E|IBM DB2 AdministrationIBM Confidential 2009 IBM CorporationGlobal Technology ServicesGrowth ? Thrive for excellence ? Smar