Verhoef Training, Inc.

P.O.Box 1515, West Caldwell, NJ 07006
Phone:(800)631-0410 Fax:(973)403-3468



DB2 9 - Differences




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 be
given for the UTILITIES part of the course.

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

DURATION:   2 days. Hands on.

OBJECTIVES:   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.

COURSE CONTENT:  
  1. Introduction Environment/System Changes
    • XML
    • Tablespace types
    • DECFLOAT
    • BIGINT
    • VARBINARY
    • Simple tablespaces
  2. SQL
    • INTERSECT
    • EXCEPT
    • MERGE
    • TRUNCATE
    • SELECT from DELETE, UPDATE and MERGE
  3. PERFORMANCE
    • INSERT
    • Logging
    • Index page changes
    • Append options
    • Not logged tablespaces
    • Optimization changes
    • Optimization support center
    • Variable length
  4. 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
IC07

© 2007 Verhoef Training, Inc.