DB2 10 z/OS Transition

Course:  DB2M10
Duration:  1 Day
Level:  II
Course Summary

The course is designed to instruct those delegates who are fairly confident in designing, writing and testing DB2 applications and now need to know the facilities, functions and changes that are available to them with DB2 10. If Skip Migration is being employed then the DB2 9 and DB2 10 Transition courses can be combined.

Practical exercises can be provided.

« Hide The Details
Topics Covered In This Course

Environment Changes

  • Subsystem enhancements
  • Virtual storage constraint relief
  • 64 bit Evolution
  • Further processing above 2GB bar
  • Buffer pool prefetch and deferred write
  • MEMBER CLUSTER allowed for Universal Tablespaces
  • Compression changes
  • RACF password phrases
  • RACF Identity propagation
  • SSL encryption
  • WLM
  • Parallelism enhancements
  • Reduction in latch contention
  • Shutdown and restart times DSMAX
  • Compress checking
  • Reduction in catalog contention
  • Alter Page size & Member cluster
  • Online add active log
  • Dataset level FlashCopy option
  • Dynamic adding an active log dataset
  • Temporal Tables

SQL Changes

  • Scalar Function changes
  • Compress on insert
  • Index INCLUDE columns
  • Versioned data / AS OF queries
  • Generated column support - ALTER TABLE GENERATED AS
  • Greater TIMESTAMP precision
  • Special indicator for "value not supplied" or "DEFAULT"
  • Compress on Insert

DDL Changes

  • Create TABLESPACE statement
  • Online schema statement

XML Changes

  • pureQuery extensions to Java
  • Performance enhancement to XML schema validation
  • Binary XML exchange
  • XML multi-versioning
  • Introduction of XQuery syntax
  • Partial updates to XML documents
  • Stored proc, UDF, Trigger enhanced support for XML

Performance Changes

  • Explain changes
  • Locking - new ISO(CS) option
  • Reduced Catalog contention during DDL/BIND/Prepare
  • Bind constraints - 64GB limit increased for SPT01
  • Index INSERT parallelism
  • Reduced performance impact of disorganized indexes
  • LOBs changes
  • Auto statistics collection
  • Improved control over (re)optimization
  • Stabilizing access paths
  • Indexing support for DECFLOAT
  • Dynamic statement cache control
  • Dynamic SQL caching enhancements
  • Use indexes on more types of queries
  • Predicate evaluation enhancements - UNION
  • Predicate evaluation enhancements - CTEs
  • FETCH FIRST 1 ROW changes
  • Query parallelism enhancements
  • EXPLAIN for JDBC and CLI statements

Programming Changes

  • SQL stored procedures enhancements
  • SPL changes
  • Greater Session variable control
  • RETURN TO CLIENT capability for nested stored procedures
  • Indicator Variables

Utility / Command Changes

  • CHECK utility
  • Online REORG
  • REORG schema alteration
  • Utilities support for online schema changes

Data Warehousing Changes

  • Moving Sum
  • Moving Average
  • Enhanced query parallelism
  • Dynamic Index ANDing improvements
  • New "In-memory" techniques
  • Statistical views
Who Should Take This Course

IT personnel who need to know DB2 10 facilities and how it might affect them.

Recommended Prerequisites

Those attending the course should be familiar with DB2.

« Hide The Details
Related Courses
Code Course Title Duration Level
DB2 Administration for Linux, Unix and Windows
5 Days
Advanced DB2 Application Programming
3 Days
DB2 System Performance Tuning
5 Days
DB2 UDB/390 Version 9 Transition
2 Days

Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year.

You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details.

Schedule For This Course
There are currently no public sessions scheduled for this course. We can schedule a private class for your organization just a couple of weeks from now. Or we can let you know the next time we do schedule a public session.
Notify me the next time this course is confirmed!
Can't find the course you want?
Call us at 800.533.3893, or
email us at [email protected]