htalogo2.gif

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

Session Variables

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 utilities

LOAD / UNLOAD

RUNSTATS

Utilities for DPSIs

Computer Exercise: Utility Features

Command Enhancements

Catalog Table changes

Stored Procedure Enhancements

Optional Computer Exercise: Commands and Catalog Tables

Miscellaneous Topics

Online ZPARMs

Unicode in DB2

Performance enhancements

JDBC and SQLJ improvements

Integrated XML

Security labels and multilevel security

Data sharing

 

These Materials © Copyright 2013 by Hunter Cobb

Materials version: V3.x

 

Course Objectives
Course Description
Home page