This new two-day course introduces and discusses the changes and new features of DB2 10 for z/OS. It provides a technical overview, and discusses areas of potential advantage for the new features. The course is intended for system and database administrators, application developers and others needing a technical introduction to the new features of DB2 10.
DB2 10 for z/OS: Changes & New Features
A working knowledge of DB2 facilities and features.
- describe the new features and facilities introduced with DB2 10
- describe migration possibilities and issues
- identify the changes to commands, utilities and SQL relevant to their own organisation
- identify the new features that would particularly benefit their own installation.
Summary of DB2 10 for z/OS Changes & Features
Introduction; performance enhancements; availability enhancements; security enhancements; distributed functionality; XML enhancements; programming & SQL enhancements; command & utility changes; migration considerations.Performance Enhancements
Reduced CPU usage; Improved optimisation techniques; High performance database access threads; I/O parallelism for index updates; Buffer pool enhancements; Universal tablespace enhancements; Large object & XML streaming enhancements; Index enhancements; Data access enhancements; Hash tables; Contention reduction.Availability Enhancements
Online schema change enhancements; Pending definition changes; Partition rotation enhancements; Point-in-time recovery enhancements; Easier addition of active log datasets.Security Enhancements
Improved row and column access control; Permissions; Column masks; Finer granularity with administrative privileges; Support for new z/OS security features.Distributed Functionality
Elimination of DDF private protocol; 64-bit ODBC driver support; DRDA support of Unicode for system code pages; JDBC & SQLJ driver enhancements.XML Enhancements
XML schema validation; Consistency checking; Increased support for binary and date and time XML data.Application Programming & SQL Enhancements
Temporal tables; system-period data versioning; Enhanced SQL scalar functions; SQL table functions; Enhanced native SQL procedures; Implicit casting; TIMESTAMP enhancements; Moving sums & averages; Extended SQL procedural language support; Extended indicator variables.Command & Utility Changes
New and amended commands; utility enhancements.Migration Considerations
Migration paths; Migration steps; Migration considerations.
Face-to-face learning in the comfort of our quality nationwide centres, with free refreshments and Wi-Fi.
Find dates and prices
Online booking is currently not available for this course, to find out more please call us on 0113 220 7150 or email us at firstname.lastname@example.org to discuss how we can help.
Fully accredited to ensure we provide the highest possible standards in learning