G524: DB2 Version 8 Differences

TTFlogo2.gif (2585 bytes)

DB2 Version 8 Differences - Topical Outline

Introduction
   The Big picture
        64-bit virtual storage
        Unicode
   Migration basis
The Sample Application
SQL changes
    Limit changes
    DISTINCT and NOT DISTINCT
    Scalar Fullselect
    INSERT within SELECT
    GROUP BY
    FETCH FIRST with ORDER BY
    New Built-in Functions
   Computer Exercise: SQL Changes - 1

Scrollable cursors
    Version 7 Review
    SENSITIVE DYNAMIC cursors
    ASENSITIVE cursors
    FETCH syntax
    Update and locking
Multiple Row SQL
    Rowsets
    FETCH / INSERT / UPDATE / DELETE
    Multi-row INSERT within SELECT
GET DIAGNOSTICS
New Special Registers
    Computer Exercise: Programming Environment Changes

Nested Table Expressions Review
Common Table expressions
Recursive SQL
PLAN_TABLE and EXPLAIN enhancements
Computer Exercise: SQL Changes - 2

Data Base Administration Enhancements - 1
    Identity column enhancements
    Sequence objects
    Sequences and cursors
    LOBs and transparent ROWIDs
    Materialized Query Tables
    Computer Exercise: Sequences, LOBs, and MQTs

Data Base Administration Enhancements - 2
    Table-controlled partitioning
    Partitioning Indexes
    Secondary Indexes
    Data-partitioned Secondary Indexes
    Clustering Indexes
    Computer Exercise: Table-controlled partitioning

Data Base Administration Enhancements - 3
    Adding Partitions
    Rotating Partitions
    Online Schema Changes
    Versioning
    Index enhancements
    Computer Exercise: Schema and Partition Changes

Utility Enhancements
    BACKUP / RESTORE SYSTEM
    Default changes
    REORG, REBUILD, COPY, and REPAIR
    Informational referential integrity and utilities
    DSN1COPY and DSN1PRNT
    Unicode and utilties
    LOAD / UNLOAD
    RUNSTATS
    REORG
    Utilities for DPSIs
   Computer Exercise: Utility Features

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

Miscellaneous Changes
    Online ZPARMs
    Unicode in DB2
    Performance enhancements
    JDBC and SQLJ improvements
    Integrated XML
    Security labels and multilevel security
    Data sharing

Course Objectives
Course description
Home page