G526 DB2 Version 9 Differences

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

Bind Enhancements: REOPT AUTO and SWITCH

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 table space new features

SMS and storage groups

NOT LOGGED table spaces

Tables - new features

CREATE TABLE ... APPEND

Reordered row format

Row change timestamps

RENAME COLUMN

ALTER TABLE … LONG VARCHAR

New data types: BIGINT, BINARY, VARBINARY, DECFLOAT

Indexes

Renaming

Page sizes

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

G526 / 3 Days

Materials version: V2.x

Course Objectives
Course Description
Home page