DB2 LUW Version 8.1 & 8.2 Transition

Course Objectives
The aim of this Course is to provide the delegate, familiar with DB2 V7.2, with the necessary skills required to use the new Version 8.1 features.

Course Details
ADMINISTRATION ENHANCEMENTS
Storage Management Tool
The Flush Package Cache Statement
Logging Enhancements
Health Monitoring
Event Monitors Enhancements - Writing to SQL tables
Enhanced Deadlock Monitoring
Activating Monitors - Recap
Taking Snapshots - Prior to Version 8
Turning Monitoring Switches On
Version 8 - Taking Snapshot using SQL
SQL Snapshot Functions
Renaming Indexes
Autoconfigure Command
Online Configuration Parameters
Database Manager Configuration Parameters
Database Configuration Parameters
Online Bufferpool Maintenance
DMS Container Operations
Containers, Stripes and Stripe Sets
PERFORMANCE ENHANCEMENTS
Type 2 Indexes
Type 2 Indexes - Migration Considerations
Null and Default Compression
Compression - Row Format
Has Compression Been Switched On?
Multidimensional Clustering
Defining Multidimensional Clustering
Defining Multidimensional Clustering Indexes
Using Generated Columns with MDC
Block Based Bufferpools - Prefetch Enhancements
Threading of Java UDFS and Stored Procedures
Connection Concentrator
Materialized Query Tables
Creating an MQT
Refresh Table
Populating User Maintained MQTs
Automatic Query Rewrite using MQT
Enabling Automatic Query Rewrite
Enabling Automatic Query Rewrite - DDL Options
Enabling Automatic Query Rewrite - Special Registers
Enabling Automatic Query Rewrite - Query Properties
Registering Existing Tables as MQT
AQR Examples
Maintenance of MQTs using Staging Tables
UTILITY ENHANCEMENTS
LOAD Enhancements
LOAD at Table Level
LOAD from a Cursor
LOAD - Partitioned Load
LOAD - Generated Column Values
Online Table LOAD
LOAD - New Lock With Force Parameter
The LOAD QUERY Command - New Table States
Load Append - Materialized Query Tables
New Load Wizard
Online Table REORG
Online Index REORG
Backup and Recovery Enhancements
QUIESCE Enhancement
REORGCHK - On Schema Capability
RUNSTATS Command Enhancements
SQL ENHANCEMENTS
Insert Through UNION ALL Views
Using UNION ALL Views for Time Series Data
Instead Of Triggers
Sequences
Create Sequence Syntax
Alter Sequence Syntax
Drop Sequence
Consumed Values / Gaps in a Sequence
Duplicate Sequence Values
Using Sequences in Applications
DEVELOPMENT ENHANCEMENTS
Version ID for Packages
New Routine Authorities
Other Routine Enhancements
A New Development Center
SQL Assist Enhancements
Informational Constraints
Declared Global Temporary Table Enhancements
JDBC Driver Enhancements
DB2 XML Support Enhancements
GUI ENHANCEMENTS
New Wizards and GUI Tools
Wizards - Option to Schedule or Run Immediately
New Configuration Assistant
Revised Documentation Packaging
Replication Center
Course Environment The lectures apply to DB2 running in a Linux, Unix or Windows environment.

Course Format: The course is purely lecture based and contains no practical exercises. A comprehensive Student Guide is supplied which contains detailed documentation of the new version together with many syntax examples where relevant. Delegates will also be able to access a free help-line with technical questions relating to topics covered on the course.