| DB29 - DB2 V10 Transition for Developers |
|---|
| Duration | 1 Day (customisation) |
| Availability |
|
Course Description
This course is aimed at DB2 Developers who need to understand the new programming and SQL features of DB2 Version 10.
Pre-requisites
A strong working programming knowledge of DB2 Version 9 is required to attend this course.
Objectives
The aim of this course is to provide the delegate, familiar with DB2 V9, with the necessary skills required to use the new Version 10 features.
Environment
The lectures apply to DB2 running in a z/OS environment.
For on-site courses (i.e. at your premises), we are more than happy to tailor the course agenda to suit your exact requirements. In many cases, we are able to build your in-house standards and naming conventions into the delivered course.
Course Details
- SQL ENHANCEMENTS
- Recap SQL/PL Scalar Functions
- SQL/PL Scalar Function Enhancements
- Inline and Non-Inline SQL/PL Scalar Functions
- SQL/PL Scalar Functions New Control Statements
- Non Inline Functions Binding Considerations
- Non Inline Function Examples
- Altering Non Inline SQL Functions
- Native SQL Functions - Versioning
- Enhanced SQL Table Function Support
- Enhanced Native SQL Procedure Support
- Greater Support for Implicit Casting
- Datetime Constants
- Variable Timestamp Precision
- Variable Timestamp Precision Current Timestamp
- Variable Timestamp Precision Row Change Timestamps
- Variable Timestamp Precision Catalog Changes
- New Timestamp with Time Zone Data Type
- Timestamp with Time Zone String Representation
- Implicit Time Zone
- Timestamp with Time Zone Assignment and Comparison
- Current Timestamp with Time Zone Special Register
- Session Time Zone Special Register
- Time Zone Expressions and Arithmetic
- New Timestamp Functions
- Application Programming Considerations
- PROGRAMMING ENHANCEMENTS
- Temporal Tables
- Temporal Tables and Versioning
- Temporal Tables Versioning Example
- System Temporal Tables Data Access
- Temporal Tables Considerations
- Temporal Tables Application Controlled
- Business Temporal Tables Data Selection
- Business Temporal Tables Update and Delete
- Business Temporal Tables Update Example
- Business Temporal Tables Delete Example
- Temporal Tables Catalog Information
- A New Access Path Framework
- Access Path Framework New Repository
- Access Path Framework New Catalog Tables
- Subsystem Level Access Path Hints
- The DSN_USERQUERY_TABLE Table
- Inserting Rows Into DSN_USERQUERY_TABLE
- Access Path Framework The Bind Query Command
- Access Path Framework The Free Query Command
- Access Path Framework Access Plan Stability
- Version 9 Recap - Package Management
- Version 9 Recap - Package Switching
- Deleting Old Packages
- Access Plan Stability V10 Enhancements
- Extended Indicator Variables
- Extended Indicator Variables - Example
- New Universal Language Interface Program (Dsnuli)
- Locking Recap V9 - Skip Locked Data
- V10 Locking Enhancement - Access To Committed Data
- Explain New Special Register
- Lastused Information for Packages
- Connectivity Enhancements
- DDF Availability
- Monitoring and Controlling Enhancements
- JDBC Type 2 Driver Performance Enhancements
- High Performance DBAT
- Use of RELEASE(DEALLOCATE) in Java Applications
- Support for 64-bit ODBC Driver
- DRDA Unicode Enhancements
- DB2 Supplied Stored Procedures
| - XML ENHANCEMENTS
- Recap - XML in Version9
- Recap - XML Data Type
- Recap - Summary Of XML Objects Created
- Recap - XML Document Processing in Version 9
- XML Document Processing Enhancements
- Using XmlModify to Insert Nodes
- Using XmlModify to Update / Delete Nodes
- XML Indexing Enhancement
- XML Schema Validation Enhancement
- XML Type Modifier
- Support for Binary XML
- Support for Multiple Versions of XML Documents
- PERFORMANCE ENHANCEMENTS
- Improved Optimization Techniques
- Dynamic Prefetch Enhancements
- DDF Enhancements
- Dynamic Statement Cache Enhancements
- Insert Performance Improvement
- Referential Integrity Checking Enhancement
- BufferPool Enhancements
- Work File Enhancements
- Support For z/OS Enqueue Management
- LOB Enhancements
- Java & ODBC Performance Enhancements
- Logging Enhancements
- Hash Access
- Non-Key Columns in a Unique Index
- Support for Solid State Drive
- The SQL PL Enhancements
- Preemptable Backout
- Mass Delete Locking Enhancement
- Parallelism Enhancements
- Online Performance Enhancements
- Monitoring Enhancements
- AVAILABILITY ENHANCEMENTS OVERVIEW
- Alter Tablespace Enhancements
- Pending Changes
- Autonomic Checkpoint
- Partition Rotation Enhancement
- Compress on Insert
|
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.
| 
