Cursusbeschrijving: DB2 for z/OS New Functions and Features in V10

Learn about the new features and enhancements of DB2 10 for z/OS, including the technical detail of the functional enhancements of this significant new version of DB2 for z/OS. Get a better understanding of several of the new functions by performing hands-on machine exercises.

Bekijk deze cursus in andere landen

Terug naar boven

This is an intermediate course for system and database administrators, application developers, and other individuals who need a technical introduction to selected new features of DB2 10 for z/OS.

Terug naar boven

You should have:

• Practical experience with DB2 for z/OS and have good knowledge of the functions and usage of DB2 for z/OS Version 9.

Terug naar boven

• Describe selected new features and enhancements of DB2 10 for z/OS
• Evaluate the usefulness of the new features and enhancements of DB2 10 for z/OS

Terug naar boven

The topics presented in the course include all what is listed below and much more. The below attached list is supposed to just give you an idea about what kind of topics we are going to touch during this course.

Subsystem:

• Virtual storage relief
• Reduction in latch contention
• Reduction in catalog contention
• WORKFILE database enhancements
• Online schema enhancements
• Retrieving consistent data without frequent timeouts
• Autonomic enhancements
• Increase availability for CHECK utilities
• Delete Data Sharing Member
• UTS support for MEMBER CLUSTER
• DDF availability
• Subgroup attach name

Application functions:

• Enhanced support for SQL scalar functions
• Enhanced support for native Stored Procedures
• DB2 provided stored procedures
• Enhanced TIMESTAMP support including TIME ZONE
• Support for temporal tables and versioning
• Access path stability enhancements
• XML type modifier
• XML schema validation improvements
• Support for updating part of an XML document
• Binary XML support
• JDBC Type 2 driver performance enhancements
• High performance DBAT
• Support for 64 bit ODBC driver

Operation and performance:

• New policy based audit capability
• More granular system authorities and privileges
• System defined routines
• Support for row and column access control
• FlashCopy enhancements
• Online Reorg enhancements
• RECOVER with BACKOUT YES
• Changes to Installation and migration
• Migration and version coexistence
• Skip level migration (V8 - V10)
• Catalog changes
• Performance expectations
• Improved optimization techniques
• Hash access
• Additional non-key columns in a unique index
• Inline LOBs

Terug naar boven