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
• 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