Home >
DB2 for z/OS >
DB2 Batch Design for Performance
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.
|
Detailed Outline |
|