This Application Performance and Tuning course is designed to teach the students how to prevent application performance problems and to improve the performance of existing applications. Students will learn about indexes, table design, locking, and other issues relevant to application performance. This course includes paper exercises and machine exercises designed to reinforce the lecture content.
What You'll LearnTOP
- Design better indexes
- Determine how to live with the optimizer (avoid pitfalls, help when necessary)
- Avoid locking problems
- Use accounting trace information to find significant performance problems in an operational application
Viewing outline for:
You should have:
- Familiarity with DB2 for z/OS application programming and SQL.
Who Should AttendTOP
This intermediate course is designed for DB2 for z/OS application developers, DB2 for z/OS DBAs, and anyone else who is responsible for application performance and tuning in a DB2 for z/OS environment.