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 9.x: Migration: LUW (Linux, UNIX, Windows) - Differences

Course Code: DB2M9 (Also known as: DB2M9GB)      Days: 2
Show all IBM Courses
Scheduled Dates (sort by: location | date)
Request availability or book by selecting a date:
England
Somerset
Bath (BA1) 22/04/10 £ 700
Bath (BA1) 08/07/10 £ 700
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 who are fairly confident in designing, writing and testing DB2 applications and now need to know the facilities that are available to them with the new DB2 9 release.

This course has been classified as IT Technical Training.

Audience

IT personnel who need to know the new DB2 9 facilities and how they might affect them. The emphasis on certain subjects will be adjusted to reflect the audience; for example if the delegates on the course are all applications programmers then less in depth teaching will begiven for the UTILITIES part of the course!

Prerequisites

Those attending the course should be confident in writing DB2 applications in previous releases of DB2

Course Outline

Introduction Environment/System Changes

  • XML
  • Tablespace types
  • DECFLOAT
  • BIGINT
  • VARBINARY
  • Simple tablespaces

SQL

  • INTERSECT
  • EXCEPT
  • MERGE
  • TRUNCATE
  • SELECT from DELETE, UPDATE and MERGE

PERFORMANCE

  • INSERT
  • Logging
  • Index page changes
  • Append options
  • Not logged tablespaces
  • Optimization changes
  • Optimization support center
  • Variable length

OTHER

  • Online schema changes (Database Definition On Demand)
  • Online table space reorganization
  • Table cloning
  • Instead of triggers
  • Stored procedure changes
  • OLAP changes
  • Security changes
  • Utility changes


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