Advanced DB2 For OS/390 Application Development
Duration
Three Days
Pre-requisite
Students should have at least six months experience using DB2.
Who Should Attend
Applications developers who wish a thorough understanding of the performance aspects of DB2 as applied to the development process.
Course Description
Advanced DB2 broadens the skills of a DB2 applications developer by going in-depth into DB2 SQL’s performance and tuning ramifications. Various access paths are discussed as well as the use of the PLAN_TABLE to determine the access path. The students are given ample opportunity for practice in a series of exercises designed around the curriculum.
Course Topics
- Review of DB2
- DB2 In-Depth
- DB2 Performance Monitoring
- DB2 Performance Tuning
