Verhoef  Training

DB :: DB2 for z/OS SQL Performance and Tuning

"Going the extra mile with ICT"

PO Box 2466, Cape Town 8000, South Africa
tel: 0861-102017 • fax: +27 21 856-0042 • e-mail: training@verhoef.co.za

Related Courses
» DB2 Fundamentals
» DB2-SQL Application Programming
» Advanced SQL Workshop
» DB2 Administration

Curricula Info
» MVS - z/OS - z/VM
» DB2 - SQL
» CICS TS
» IBM MQ
» Programming
» UNIX - Linux
» Networking
» Web Technologies
» Business Skills

Resources
» IBM Support
» IBM Redbooks
» Mainframe Month
» Mainframes.com
» z/Journal
» CIO Magazine
» Search390.com
» Linux Links
» XML Writer

Links
» CICS Central
» Programmer's Heaven
» Develoment Guru
» COBOL Centre
» COBOL User Groups
» REXXLA Home
» XML.com

Verhoef Sites:
» Verhoef USA
» Verhoef UK

 

Curriculum Description | Curriculum Roadmap | Curriculum Schedule | Course Enrolment

3 days   *   Advanced   *   Lecture and Labs

Course Summary:
The course is designed to instruct delegates how to develop and maintain existing applications in an efficient manner, up to and including DB2 11. It is intended for DBA's, analysts and programmers.

Target Audience:
IT personnel and developers who have been exposed to using DB2 under z/OS and wish to understand more of the SQL performance and tuning aspects of the product.

Recommended Prerequisites:
Those attending the course should have used DB2 in the past, and preferably attended our DB2-SQL Application Programming course. A good working knowledge of DB2 SQL is a requirement.

Course Objectives:
The course is designed to instruct delegates how to develop and maintain existing applications in an efficient manner, up to and including DB2 11. The course will look at existing SQL to see if it is performing poorly, and to identify why this is the case, and how to reconstruct it so that it can perform better. The course contains practical exercises to consolidate the theory sessions.

Key Topics:

The different DB2 versions

DB2 Architecture

System Performance Overview

Single Table Access Paths

Multiple Table Access

Using EXPLAIN to Analyse Access Paths

Indexes and Performance

Reorganising Table Spaces and Indexes

On-line and Batch Performance Guidelines

Transaction Locking

Locking and Performance

Other Serialisation Mechanisms

Packages, Plans and Bind options

Using XML and XML in DB2 11

Last modified: 20-Dec-2017

Site Map

 Home
  |
  •-- About Us
  |----Our Mission
  |----BEE Strategy
  |----Complaints
  |----Careers
  |----PAIA manual
  •-- Courses
  •-- Schedules
  •-- Our Clients
  •-- News and Events
  •-- Contact Us
  •-- Your Privacy
  |
  •-- MVS - z/OS - z/VM
  |----Roadmaps
  |----Schedule
  |
  •-- DB2 - SQL
  |----Roadmaps
  |----Schedule
  |
  •-- CICS TS
  |----Roadmaps
  |----Schedule
  |
  •-- IBM MQ
  |----Roadmaps
  |----Schedule
  |
  •-- Programming
  |----Roadmaps
  |----Schedule
  |
  •-- UNIX - Linux
  |----Roadmaps
  |----Schedule
  |
  •-- Networking
  |----Roadmaps
  |----Schedule
  |
  •-- Web Technologies
  |----Roadmaps
  |----Schedule
  |
  •-- Business Skills
  |----Roadmaps
  |----Schedule
  •