DB23 - DB2 V9 for z/OS Overview
Duration1 Day
AvailabilityCheck course price and availability

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.