DB2 10 for z/OS Transition and Update

Audience

IT personnel who need to know the new DB2 10 facilities and how they might affect them.

Prerequisites

At least nine months of database administration related responsibilities in a DB2 environment at a previous release level.

Duration

1 day.

Course Objectives

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 differences can be combined in a single 2 day class.

Course Content

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