G526: 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

  • Computer Exercise:  Commands and Catalog Tables
×

Comments are closed.