DB26 - DB2 z/OS Version 10 Transition - 2 Days

Course Description

This course is aimed at Systems Programmers, Programmers and DBA's who need to understand the new features and facilities of DB2 Version 10. This lecture based course covers all of the new features in detail.


A strong working knowledge of DB2 Version 9 is required to attend this course.


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

Virtual Storage Management
IBM System z and z/OS Support
IBM zEnterprise System Support
z/OS Security Server Support
TCP/IP Support
WLM Enhancements
Using RMF for zIIP Reporting and Monitoring
Warehousing on System z
Data encryption
IBM WebSphere DataPower
Additional zIIP and zAAP Eligibility
Reduced CPU Usage
Productivity Improvements
Flexibility in migration paths:
Greater Reliability and Availability
Rapid Application and Warehouse Deployment
Deprecated and Unsupported Features
Upgrading from V8 to V10

Virtual Storage Relief
Log / Latch Contention Enhancement
Catalog Contention Enhancement
Increased Number of Packages
Workfile Database Enhancements
Support for Extended Address Volumes

Version 9 Recap - Universal Tablespaces
Version 9 Recap - Partition-By-Growth Tablespace
Creating A Partition-By-Growth Tablespace
Version 9 Recap - Partition-By-Range Tablespace
V10 Universal Tablespace Enhancements
Alter Tablespace Enhancements
Alter Tablespace Enhancements - Considerations
Pending Changes
Pending Changes – Areor State
Pending Changes – Reorg Materialisation
Pending Changes – Reorg Partition Resizing
Alter Tablespace Examples
Alter Tablespace - Member Cluster
Online Schema Changes – Recovery
Partition Rotation Enhancement
Version 10 Partition Rotation Enhancements
Rotating Partitions - Considerations
Default Tablespace
Autonomic Checkpoint
Dynamically Adding Active Log Datasets
Data Compression Enhancements
Version 10 – Compress on Insert / Merge / Load
Compression Considerations

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
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

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
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
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

Recap - XML in Version 9
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

RID Pool Enhancements
Range-list Index Scan
IN List Enhancements
Predicate Evaluation Table
Dynamic Prefetch Enhancements
Dynamic Statement Cache Enhancements
Insert Performance Improvement
BufferPool Enhancements
Work File Enhancements
Version 9 Lob Recap
Version 9 LOB Recap - Object Definition
LOB Enhancements – Inline LOBS
Other LOB Enhancements
Hash Tables
Tablespaces for Hash Tables
Creating a Hash Table
Hash Table Considerations
Hash Table Catalog Changes
Non-Key Columns in a Unique Index
Mass Delete Locking Enhancement
A New Access Path Framework
Access Path Framework – New Repository
Access Path Framework – New Catalog Tables
Subsystem Level Access Path Hints
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
Explain – New Special Register
Lastused Information for Packages
Changes to the Explain Facility
Plan Table Layout
Plan Table Column Definitions
The Dsn_Statemnt_Table
The Dsn_Function_Table
The Dsn_Statement_Cache_Table
The Dsn_Struct_Table
The Dsn_Predicat_Table
The Dsn_Detcost_Table
The Dsn_Sort_Table
The Dsn_Sortkey_Table
The Dsn_Filter_Table
The Dsn_Pgrange_Table
The Dsn_Pgroup_Table
The Dsn_Ptask_Table
The Dsn_Viewref_Table
The Dsn_Query_Table
The Dsn_Coldist_Table
The Dsn_Keytgtdist_Table

Copy / Recover Enhancements using FlashCopy
Using FlashCopy
FlashCopy Examples
FlashCopy Considerations
Administrative Task Scheduler
Adding A Task using Admin_Task_Add
Version 9 Recap - Automation Procedures
Runstats Automation
Runstats - Statistics Profiling
Backwards Recovery
Reorg Lob Enhancements
Reorg Lob – Other Enhancements
Check Utility - Increased Availability
Elimination of Utserial for DB2 Utilities
Report Utility Enhancement

Policy Based Audit Capability
Creating an Audit Policy
Audit Policy Examples
System Authority / Privilege Enhancements
Defining Secadm Authority
System Dbadm Privileges
Dataaccess Privileges
Accessctrl Privileges
Sqladm and Explain Privileges
System Defined Routines
The Revoke Dependent Privilege Clause
Row and Column Access Control
Scalar Functions for Row / Column Permissions
Row Access Control - Defining Row Permissions
Activating Row Permissions
Column Access Control - Defining Column Masks
Activating Column Masks
Row and Column Access – Restrictions
Row and Column Access – Explain Output
Row and Column Access – Catalog Changes
Support for z/OS Security Server Enhancements

Subgroup Attach Name
Bufferpool Scan Avoidance
Universal Table Space Support for Member Cluster
Restart Light Enhancement
Log LRSN 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.

Course Enquiry