DB2 Version 9 Differences - Topical Outline

Introduction
    The Big picture
        Hardware exploitation – zIIPs
        XML
        SQL family consistency
    Migration basis
        What’s gone
        Coexistence
The Course Database
        Computer Exercise: Course setup

SQL changes - 1
    EXCEPT and INTERSECT
    ORDER BY and FETCH FIRST in subselect
    TRUNCATE TABLE
    Computer Exercise: SQL Changes - Round 1

SQL changes - 2
    MERGE
    SELECT FROM UPDATE / DELETE / MERGE
    New built-in functions
    OLAP-related functions
    Computer Exercise: SQL Changes - Round 2

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

Native SQL procedures
    CREATE/ALTER PROCEDURE
    Versioning
    Command and subcommand changes
    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
    Clone tables
    Implicit data bases and object creation
    Computer Exercise: Data Base Administration - 1

Data Base Administration Enhancements - 2
    Data base, storage group, and tablespace new features
        SMS and storage groups
        NOT LOGGED table spaces
    Tables - new features
        Reordered row format
        CREATE TABLE ... APPEND
        Row change timestamps
        RENAME COLUMN
        ALTER TABLE … LONG VARCHAR
        New data types: BIGINT, BINARY, VARBINARY, DECFLOAT
    Indexes
        Renaming
        Page size
        Compression
    Indexing on expressions
    CATMAINT ... UPDATE SCHEMA
    Computer Exercise: Data Base Administration – 2

Data Base Administration Enhancements - 3
    XML Overview
    XML and DB2
    XML and SQL
    XML in application programs
    XML Indexing
    XML schema support
    XML catalog tables
    XML impact on utilities
    Computer Exercise: Working with XML Data

Utility Enhancements
    REORG
    RECOVER
    LOAD / UNLOAD
    COPY / MODIFY RECOVERY / RECOVER
    CHECK DATA / CHECK LOB / CHECK INDEX
    RUNSTATS
    REORG
    Miscellaneous
    Computer Exercise: Utility features

Command Enhancements
Catalog Table changes
Data Sharing changes
Performance enhancements
Network trusted contexts
Miscellaneous Topics
    Optional Computer Exercise: Commands and Catalog Tables

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: 24 September, 2008
this page copyright © 2008 by The Trainer's Friend, Inc.