DB2 Batch Design for Performance

Course

In Gatwick

£ 775 + VAT

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

Gatwick (London)
Regus Centre, First Point, Buckingham Gate, London Gatwick Airport, RH6 0NT

Start date

On request

About this course

At least one (1) year of application development experience.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

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)
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.

DB2 Batch Design for Performance

£ 775 + VAT