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.
- 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
You should have:
- Familiarity with DB2 for z/OS application programming and SQL.
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.