DB2 Batch Design for Performance

Course Code: DZOBDP
Duration: 2 days
Audience: Application Designers, Application Programmers and Capacity Planners.
Prerequisites: At least one (1) year of application development experience.
Summary: For Developers, this presentation summarises effective batch application design. In the interest of performance and availability, special emphasis will be placed on:
  • Efficient SQL
  • Index design in general
  • Clustered indexes in particular
  • Massive update alternatives
  • Checkpoint/restart
  • Parallelism
  • Prefetch (sequential and dynamic)
Objectives: Upon completion of this presentation, the delegate should be able to make use of batch application design guidelines which, when adopted, can improve overall batch program performance on system availability.
View full outline in PDF formatDetailed Outline

print  |  top of page