- 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
DB2 11 for z/OS Application Performance and Tuning Schulung
Prevent application performance problems
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.

IBM Global Training Provider
Mit einem Training von IBM erweiterst du das Know-how deiner Mitarbeiter – ein klarer Wettbewerbsvorteil für dein Unternehmen. Mit unseren Services und der neuesten Technologie für verteiltes Lernen aktualisierst du die Fähigkeiten deiner IT-Mitarbeiter.
Inhalte DB2 11 Schulung
Entscheidungshelfer DB2 11 Schulung
Zielgruppe
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.
Voraussetzungen
You should have:
- Familiarity with DB2 for z/OS application programming and SQL.