Cisco, Prince2, Microsoft, ITIL & ISEB IT Training Courses – CourseMonster
To speak to a training advisor please call
0800 40 848 40
training@coursemonster.co.uk
Browse IBM Training Courses

IBM DB2: SQL Performance and Tuning for z/OS

Course Code: DB2PSQ (Also known as: DB2PSQGB)      Days: 3
Show all IBM Courses
Scheduled Dates (sort by: location | date)
Request availability or book by selecting a date:
England
Somerset
Bath (BA1) 19/04/10 £ 1,150
Bath (BA1) 05/07/10 £ 1,150
Prices exclude VAT.
No suitable dates?
I'd like a different date/location

Please click above and we will take care of the rest.

I’d like an onsite/bespoke course

Please click above and we will be happy to discuss the benefits of onsite and bespoke courses with you.

If suitable dates or locations are not available, click this link and we will arrange one for you

Course Overview

The course has been designed, to consolidate on the students knowledge of SQL, understand all aspects of EXPLAIN, be aware of efficiency, and to understand the new facilities available up to UDB/390 version 8. The course will contain numerous practical exercises to consolidate the theory.

This course has been classified as IT Technical Training.

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.

Prerequisites

Those attending the course should have used DB2 in the past, and preferably attended our DB2 SQL Programming course.

Course Outline

System architecture

  • DBA
  • EDM pool

Data transfer

Storage

  • Tablespace
  • Global Tables
  • Tables

Log Manager

  • Traces
  • Catalog and History Tables
  • Directory

Advanced SQL

  • Coding efficient SQL
  • Scalar functions
  • DATE/TIME functions
  • Column functions
  • Special registers
  • FETCH only
  • CASE
  • Table joins
  • SUBSELECTS
  • Correlated SUBSELECTS
  • UNIONS
  • Joins
  • Nested tables

Indexes and performance

  • Page
  • Record identifier
  • Indexes
  • Type1/2
  • Splits

Explain & Filter factor

  • Optimizer
  • EXPLAIN

DSN_STATEMNT_TABLE

  • Catalog statistics
  • Single column/ Multiple columns
  • Filter factor

Access paths

  • Single table access
  • Multiple table access
  • Types of access paths

Coding efficient SQL

  • Data Handling
  • Modification of SQL by DB2
  • Coding additional predicates
  • Using indexes
  • Coding efficient Joins
  • SUBQUERIES
  • VIEWS

PLAN analysis

  • Influencing Access Paths

Online Performance Guidelines

  • Coding techniques
  • Efficient Browse
  • Multiple columns indexes
  • Online updates

Batch performance guidelines

  • Locking & Performance
  • Understanding locking
  • Contention
  • Locking in a shared environment
  • Global deadlocks

Packages/Plans

  • Terms/terminology
  • BIND OPTIONS
  • Data structures

Triggers

Stored Procedures


How to make a booking for the DB2PSQ course
 

CourseMonster books thousands of public training courses, classes and boot camps both in London and throughout the UK including: Berkshire, Birmingham, Bristol, Bournemouth, Bucks, Cambridge, Derby, Devon, Edinburgh, Glasgow, Hampshire, Ipswich, Leeds, Leicester, Luton, Manchester, Middlesex, Milton Keynes, Norfolk, Nottingham, Reading, Surrey, Sussex, Tyne and Wear, Midlands and Yorkshire. Topics range from software to administration and development.