DB2 Batch Design for Performance
Course
In Gatwick
Description
-
Type
Course
-
Location
Gatwick
-
Duration
2 Days
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.
Facilities
Location
Start date
Start date
About this course
At least one (1) year of application development experience.
Reviews
Course programme
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)
DB2 Batch Design for Performance