G118 Outline

TTFlogo2.gif (2585 bytes)

DB2 Version 6 Differences - Topical Outline

Introduction
   The Big picture
   Migration basis
The Sample Application
Built-in function extensions
Direct row access
SET, VALUES INTO, and SAVEPOINT
   Computer Exercise: New SQL

PLAN_TABLE changes
Optimization hings
DSN_STATEMENT_TABLE
Computer Exercise: PLAN_TABLEs and EXPLAIN

Schemas
Distinct types
User-defined functions
DSN_FUNCTION_TABLE
Computer Exercise: Distinct Types and User-Defined Functions

Programming Environment changes
   DSNSTEP2 in object form
   Declared global temporary tables
   Improved query optimization
        Query parallelism
        Index screening
        Temporary tables
   Predictive governing
   New BIND options
Catalog Table changes
   Computer Exercise: Exploring the New Environment

Stored Procedures Enhancements
   CREATE / ALTER / DROP PROCEDURE
   Security
   Invocation changes
   SYSROUTINES, SYSROUTINEAUTH Catalog Tables
   SQL Procedures
   Optional Computer Exercise: Stored Procedures

Data Base Administration Enhancements
   16-terabyte Table Spaces
   Partition rebalancing
   VARCHAR column length changing
   8K and 16K page sizes
   Space map copy maintenance
   ROWID data type
   Identity columns
LOBs, BLOBs, and CLOBs
Triggers
   Computer Exercise: Data Base Administration

Utility Enhancements
   Inline statistics
   REUSE option
   Utility parallelism
New Utilities: CHECK LOB, REBUILD INDEX
Enhanced Utilities: CHECK DATA, COPY, LOAD, QUIESCE,
   RECOVER, REORG INDEX, REORG TABLESPACE,
   REPORT, RUNSTATS
   Standalong Utility changes: DSN1COMP, DSN1COPY, DSN1PRNT
   Computer Exercise: Utilities

Command Enhancements
REXX language support
Optional Computer Exercise: REXX Applications

Miscellaneous Changes
   JAVA
   DB2 extenders
   DB2 UDB Server features
   Buffer pools in data spaces
   Logging improvements
   Data sharing enhancements

Course Objectives
Course description
Home page