Target Audience
This course is aimed at Programmers and DBA’s who require an overview of the new features of DB2 for z/OS Version 9. This lecture based course covers all of the new features at high level. A more detailed version (2 days) will be available from February 2008.
Pre-requisites
A strong working knowledge of DB2 Version 8 is required to attend this course.
Course Environment
The lectures apply to DB2 running in a z/OS environment.
Course Details
- AVAILABILITY ENHANCEMENTS
- Automatic Object Creation
- The Truncate Table Statement
- Optimistic Locking
- Daily, Weekly, and Monthly Update Detection
- Clone Tables - Fast Table Replacement
- Column and Index Renaming
- Modify EARLY Code Without an IPL
- Alter Tablespace and Index Logging Improvements
- Using SMS Storage Classes with Db2 Defined Datasets
- PERFORMANCE ENHANCEMENTS
- Further Support for Not Logged Tablespaces
- Universal Tablespaces
- Partition-By-Growth Tablespace
- Partition-By-Range Tablespace
- Histogram Statistics
- Global Query Optimization
- Sparse index and In-Memory Data Caching
- Page-Range Screening Optimization
- Autonomic Reoptimization for Dynamic Queries
- Index Compression
- Index On Expression
- Larger Index Page Sizes
- Index Key Randomization
- Improved Performance for Varying-length Rows
- Relief for Sequential Key Insert
- Improved Logging Performance
- Improved Insert Performance - The Append Parameter
- SQL ENHANCEMENTS
- Select from Insert - Version 7 Recap
- Select from Insert Example
- Version 8 - Select From Update / Delete
- Instead Of Triggers
- Bigint - Data Type and Function
- Binary - Data Type and Function
- Decflaot Data Type
- Varbinary Data Type
- Union, Intersect and Except
- Version 7 Recap - Union
- Intersect and Except
- Rank, Dense_Rank and Row_Number
- Rank and Dense_Rank
- Row_Number
- COLLATION_KEY function
- Merge and Select From Merge Statements
- Enhanced Fetch First and Order By Support
- 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
- Storing XML Documents
- XML document retrieval
- Application development
- Database administration support
- Performance benefits through indexing support
- Native Support for SQL Stored Procedures
- Nested compound statements in SQL procedures
- SQL Procedure Example - Single Compound Statement
- SQL Procedure Example - Nested Compound Statement
- UTILITY / COMMAND ENHANCEMENTS
- Improved LOB Handling
- Online Reorg - No Build2 Phase
- Rebuild Index Availability
- Reduction in CPU Processing
- DATA SHARING ENHANCEMENTS
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.
|