Target Audience
This course is aimed at Database Administrators and applications developers who need to understand the new features and facilities of DB2 UDB for LUW Version 8.1. This lecture based one-day course covers all of the new features in detail.
Pre-requisites
A strong working knowledge of DB2 UDB Version 7.2 is required to attend this course.
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 Environment
The lectures apply to DB2 running in a Linux, Unix or Windows environment.
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 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.
|