DB2 Version 9 Differences - Topical Outline

Introduction
    The Big picture
        Hardware exploitation – zIIPs
        XML
        SQL family consistency
    Migration basis
        What’s gone
        Coexistence
    The Sample Application

SQL changes
    INTERSECT and EXCEPT
    ORDER BY and FETCH FIRST in subselect
TRUNCATE TABLE
MERGE
    SELECT FROM UPDATE/DELETE/MERGE
    New built-in functions
    Computer Exercise: SQL Changes 

INSTEAD OF Triggers
    FETCH CONTINUE
    LOB file reference variables
    REOPT AUTO
    New special registers
    SKIP LOCKED DATA clause
    Computer Exercise: Programming Environment Changes

Native SQL procedures
    CREATE/ALTER PROCEDURE
    Language extensions
    Computer Exercise: Native SQL Procedures

Data Base Administration Enhancements - 1
    Departure of simple table spaces
    Universal table spaces
        Partition by growth
        Partition by range
    SMS and storage groups
    Clone tables
    Reordered row format
    Index compression
    Index page sizes
    Index on expressions
    CREATE TABLE ... APPEND
    New data types: BIGINT, BINARY, VARBINARY, DECFLOAT
    Implicit data bases
    Computer Exercise: Data Base Admininstration – 1

Data Base Administration Enhancements - 2
    NOT LOGGED table spaces
        XML and LOB table spaces
        Recovery implications
        Utility implications
        Programming considerations
        Operational considerations
    RENAME INDEX
    RENAME COLUMN
    CATMAINT ... UPDATE SCHEMA
    Computer Exercise: Data Base Administration – 2

Data Base Administration Enhancements - 3
    XML data type
    XML and SQL
    Xpath
    XML Indexing
    XML schema support
    Utility impacts
    Computer Exercise: Working with XML Data

Utility Enhancements
    REORG
    RECOVER
    LOAD
    COPY
    MODIFY RECOVERY
    CHECK
    REORG
    Standalone utilities
    Computer Exercise: Utility features

Command Enhancements
    Catalog Table changes
    Optional Computer Exercise: Commands and Catalog Tables

Miscellaneous Topics
    Spatial support
    Unified debugger
    IP V6 support
    Private protocol
    JDBC / SQLJ drivers
    Optimistic concurrency control
    Cultural sort
    Network trusted contexts
    Optimization

Course information: G-526 / 3 Days   These Materials © Copyright 2008 by Hunter Cobb    V1.x

Course Objectives
Course description
Home page

this page last updated: 28 January, 2008
this page copyright © 2008 by The Trainer's Friend, Inc.