DB2 V9 Transition for Programmers

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

Course Details

• SQL ENHANCEMENTS
• Merge and Select From Merge Statements
• Enhanced Fetch First and Order By Support
• Select from Insert - Version 8 Recap
• Select from Insert Example
• Version 9 - Select From Update / Delete
• Union, Intersect and Except
• Version 8 Recap - Union
• Intersect and Except
• Instead Of Triggers
• Bigint - Data Type and Function
• Binary - Data Type and Function
• Decflaot - Data Type
• Varbinary - Data Type
• Rank, Dense_Rank and Row_Number
• Rank and Dense_Rank
• Row_Number
• COLLATION_KEY function
• Implicitly Hidden Columns
• PROGRAMMING ENHANCEMENTS
• File Reference Variables
• LOB Data Manipulation - Recap
• Example Using LOB Variables
• LOB Manipulation
• Using LOB Locators
• Declaring LOB Locator Host Variables
• Holding Locators
• Example Using LOB Locators
• Fetching LOB and XML data
• E-BUSINESS ENHANCEMENTS
• Integration of XML Data
• XML Review
• Storing XML Documents
• The XMLSerialize Function
• XML Indexes
• XML Document Retrieval
• XML Performace
• Application development
• Database administration support
• Performance benefits through indexing support
• Native SQL Stored Procedures
• Nested compound statements in SQL procedures
• SQL Procedure Example - Single Compound Statement
• SQL Procedure Example - Nested Compound Statement
• MQ Messaging Interfaces
• APPLICATION PERFORMANCE ENHANCEMENTS
• Distinct / Group By Performance Enhancement
• Dynamic Prefetch Enhancement
• Global Query Optimization
• Star Join Enhancement - Dynamic Index ANDing
• Dynamic Queries - Reopt Auto
• Index On Expression
• Histogram Statistics
• Varying-length Row Enhancement - Reordered Rows
• Index Look-Aside Enhancements
• Further Support for Not Logged Tablespaces
• Page-Range Screening Optimization
• Index Compression
• Larger Index Page Sizes
• Index Key Randomization
• Relief for Sequential Key Insert
• Improved Logging Performance
• Improved Insert Performance - The Append Parameter
• AVAILABILITY AND CAPACITY ENHANCEMENTS - OVERVIEW
• Universal Tablespaces
• Partition-By-Growth Tablespace
• Partition-By-Range Tablespace
• Clone Tables - Fast Table Replacement
• Automatic Object Creation
• The Truncate Table Statement
• Optimistic Locking
• Package Stability
• Column and Index Renaming
• Course Environment The lectures apply to DB2 running in a z/OS environment.

Course Format: This course runs as a 1 day lecture.