DB2 Performance Tuning for Production DBAs

Wise

Course

In Gatwick

Price on request

The best Other Database courses

See all

See all

Description

  • Type

    Course

  • Location

    Gatwick

  • Duration

    4 Days

Upon completion of this presentation, the participant should be able to use DB2 related accounting, statistics and EXPLAIN reports to monitor and tune: SQL. Index usage and design. The DB2 subsystem in general. The DB2 I/O subsystem. The DB2 buffer pools. Sort pools. IRLM (lock manager). Applications

Facilities

Location

Start date

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

Start date

On request

About this course

A working knowledge of DB2 objects, architecture and
basic SQL.

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

Environment:Non-data sharingAudience:Production DBAs, Capacity Planners, Database Administrators and System Administrators.Prerequisites:A working knowledge of DB2 objects, architecture and basic SQL.Summary:This course is designed mainly for DB2 Production DBAs in particular and DB2 DBAs in general. It imparts the necessary knowledge to monitor and tune areas that have a medium-to-high impact on DB2 subsystem performance:

  • Application and SQL design
  • DB2 subsystem and operating system dependencies
  • Workloads in terms of threads, etc.
  • Data set placement and management
  • Index design and usage
  • Buffer pool usage
  • Locking and concurrency
  • Controlling sorts
  • Batch application design
  • Online (CICS) application design
Objectives:Upon completion of this presentation, the participant should be able to use DB2 related accounting, statistics and EXPLAIN reports to monitor and tune:
  • SQL
  • Index usage and design
  • The DB2 subsystem in general
  • The DB2 I/O subsystem
  • The DB2 buffer pools
  • Sort pools
  • IRLM (lock manager)
  • Applications

See related categories

DB2 Performance Tuning for Production DBAs

Price on request

The best Other Database courses

See all

See all