Home | About Us | Courses | Schedules | Our Clients | News and Events | Contact Us | Careers  
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
      •

     
    Home | About Us | Courses | Schedules | Our Clients | News and Events | Contact Us
     

      to top
    © 2004-2018 Verhoef Training. All Rights Reserved.


    This Site Tracked by OneStat.com