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
- Computer Exercise: Commands and Catalog Tables
Comments are closed.