DB2 Universal Database - Monitoring DB2 Performance

Summary:

This course shows learners how to use various tools to monitor and tune the performance of a database to get optimal performance.

This lesson is part of our DB2 Universal Database online training series which contains over 32 hours of self-paced courseware. Our web-based training provides 6 months of unlimited access.

Objectives:

After completing this course you will be able to:

• Use the health monitor, database system monitor, and visual explain to determine database performance
• Improve database performance through configuration parameters and the configuration advisor
• Use the DB2 information center
• Use tracing facilities to understand how to troubleshoot DB2

Outline:

• The health monitor and database system monitor
• The event monitor
• Using visual explain
• Collecting statistics and reorganizing tables
• Controlling the DB2 environment
• The configuration advisor
• The design advisor
• Input/output performance
• The DB2 information center and error-logging facilities
• Tracing facilities
• The ODBC driver manager trace

Applicability:
This course is for anyone who wants to get the most out of using DB2 Universal Database.

Prerequisites: None:

Technical Requirements:

• Internet connection
• Browser: Internet Explorer, FireFox, Chrome, Safari, Opera or any standards compliant browser.
• Authorware and Macromedia Flash player recommended but not required.
• JavaScript must be enabled.

Retake any or all of our computer training as often as you want. Our online tutorials allow you to learn anywhere, anytime from any computer with internet access. All courses allow for 6 months of unlimited access (1 user), includes a variety of features and all courses qualify for Continuing Education Unit credit.

StaffKit is an e-learning leader in providing computer training tutorials and online education. We have satisfied customers in over 75 countries using our online training courses. We have been a leading provider of self-paced web based training for the past 10 years.