DB2 Performance Tuning and Monitoring Workshop培训
DB2 Performance Tuning and Monitoring Workshop培训
授课对象
This is an advanced course for database designers, database administrators, and application developers working with DB2 for Linux, UNIX, and Windows who are concerned about performance.
预备技能
DB2 9 Database Administration Workshop for Linux (CL201) or
DB2 9 Database Administration Workshop for UNIX (CL211) or
DB2 9 Database Administration Workshop for Windows (CL231) or
DB2 9 for Linux, UNIX, and Windows Quickstart for Experienced Relational DBAs (CL481)
课程目标
After completing this course, you should be able to:
Define the impact of database design (tables, indexes, and data placement) on database performance
Describe database application programming considerations and how they affect performance
Identify and describe the parameters (database and non-database) that affect performance
Tune parameters to achieve optimum performance
Identify and use the tools that assist in monitoring and tuning