Learn: in:
» back to Search Results

Course rating of 0 Vendor rating of 0

This 5-day, hands-on course examines DB2 for OS/390 UDB performance issues from the application programmer"s perspective.

Course Outline
 The course is primarily intended for application designers, programmer analysts, and programmers who design and/or code DB2 for OS/390 UDB-based applications.
The course discusses the factors effecting DB2 performance and includes practical tips and techniques for designing and implementing efficient DB2 applications. The course includes an examination of advanced SQL and an in-depth study of efficient coding techniques. Hands-on exercises ensure an effective learning experience.
ObjectiveUnderstand the major factors contributing to DB2 performance.Learn about database design (including tablespace, table, and index design) and its effects on application performance.Have a comprehensive understanding of how application design effects performance.Understand the impact of concurrency on performance.Learn to code complex SQL statements involving DB2 data conversion, summarization, and multiple table access.Be able to judge the efficiency of SQL statements and tune ineffective queries.Understand how the Optimizer works and gain an in-depth knowledge of DB2 Access Paths.Become fully conversant in the use of the Explain facility including Optimizer Hints.Learn to use utilities as part of the performance tuning process.
Prerequisites & Certificates

Familiarity with the SQL language and DB2 application programming, or equivalent knowledge, is assumed. Ideally, students have taken Information Balance's "DB2 Application Programming Workshop", a 5-day introduction to DB2 programming.

Certificates offered

Cancellation Policy
Up to the 11th business day prior to class, a registration may be cancelled or rescheduled without charge. Thereafter the full course fee will be invoiced whether it's a cancelled or rescheduled. In which case a reschedule credit, valid for 1 year, will be issued. Substitutions may be made at any time prior to the start of the course.
Map & Reviews
[ View Provider's Profile ]


This course has not yet been rated by one of our members.

If you have taken a course through this vendor please log into your account and leave feedback for this vendor. You will be helping ensure our members get directed to the best training facilities.


This course currently does not have any dates scheduled. Please call 1-877-313-8881 to enquire about future dates or scheduling a private, in house course for your team.

This page has been viewed 269 times.