DB2 V9 Transition

Course Objectives
Course Details

• AVAILABILITY AND CAPACITY ENHANCEMENTS
• Universal Tablespaces
• Partition-By-Growth Tablespace
• Partition-By-Range Tablespace
• Clone Tables - Fast Table Replacement
• Object Level Recovery
• Automatic Object Creation
• The Truncate Table Statement
• Optimistic Locking
• Package Stability
• Daily, Weekly, and Monthly Update Detection
• Column and Index Renaming
• Modify EARLY Code Without an IPL
• Alter Tablespace and Index Logging Improvements
• Using SMS Storage Classes with Db2 Defined Datasets
• 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
• SYSTEM PERFORMANCE ENHANCEMENTS
• Virtual Storage Enhancements
• EDMPool Enhancements
• Dynamic SQL Cache Enhancements
• Automated Memory Monitoring
• Real Storage Enhancements
• Distributed 64-bit DDF
• WLM Assisted Bufferpool Management
• Latch Contention Enhancement
• Buffer Manager Enhancements
• Preformatting Enhancements
• 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
• UTILITY / COMMAND ENHANCEMENTS
• Reduction in CPU Processing
• Improved LOB Handling
• Check Index Performance
• Rebuild Index Performance
• Load Performance
• Copy Performance
• Reorg Performance - No Build2 Phase
• Online Reorg Enhancement
• Runstats Performance / Enhancements
• Index key Generation Enhancements
• Recovery Enhancements
• Online LOB Reorg Enhancemant
• Online Check Data / Check Lob Enhancement
• Template Switching
• DATA SHARING ENHANCEMENTS
• Initiating Automatic GRECP Recovery
• Deferring SYSLGRNX Updates
• Restart Processing - Opening Datasets
• Locking Enhancements
• Logging Enhancements
• LOB Locks Enhancements
• Improved Group Bufferpool Write performance
• Improved Workload Manager Routing
• Improved Workload Balancing
• Group Bufferpool Dependency Enhancement

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.