IBM DB2: Performance and Tuning for LUW (Linux, Unix, Windows) Training Course

To speak to a training advisor please call

0800 40 848 40

training@coursemonster.co.uk

Show all IBM Courses

Scheduled Dates (sort by: location | date)

Request availability or book by selecting a date:

England

Somerset

Bath (BA1) 26/04/10 £ 1,150

Bath (BA1) 28/06/10 £ 1,150

Bath (BA1) 13/09/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 is designed to instruct those delegates attending the course how to develop and implement DB2 applications using SQL in an efficient and effective manner.

This course has been classified as IT Technical Training.

Audience

The course is ideal for Systems Administrators, Developers, Database Administrators and technical personnel who are involved in all stages of designing, planning, implementing and maintaining a DB2 for LUW Database, but wish to ensure that they are using the language efficiently. The course is delivered up to DB2 9.

Prerequisites

A reasonable working knowledge of DB2 on the appropriate platform (ie. Linux, UNIX or Windows).

Course Outline

Introduction to DB2

The DB2 family
The Big Picture
Basic Terms
DB2 System Catalog
Attributes
Consolidation of DDL with regard to efficiency up to and including DB2 9
Consolidation of operating system commands including db2look
Practical Exercise

Indexing

Cluster Ratio
Effect on sorting
MDC
Design Advisor
Practical Exercises

Volatile

RUNSTATS
REORG
Access Strategies
Practical Exercise

Explain

Visual Explain
Practical Exercise

Complex SQL with regard to efficiency

Table joins
EQ JOIN
SUBSELECT
CORRELATED SUBSELECT
UNION
Practical exercise

Left/Right/Full Joins

In Line Tables
CASE
Remainder of DML statements
UPDATE/DELETE/INSERT/MERGE
CTE's
Embedded SQL
Static and Dynamic SQL
Cursors
Development cycle
Precompile
DBRMs
BIND
PLANS/PACKAGES
Execution of executable program
Block Fetches

TRIGGERS

STORED PROCEDURES
Utilities
BACKUP
RESTORE
LOAD
IMPORT/EXPORT
Introduction to Automatic Computing
Configuration Parameters
Collecting Catalog Statistics
Activity Monitor
Memory Visualization
Health Center
Remote Administration
DB2 Administration Server
Configuration Assistant
Instance Attachment
Connection
The Governor and Audit

How to make a booking for the DB2UPSQ 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.