DB2 UDB for z/OS Version 8 Transition Workshop

course content details

	Scalability

	describe the DB2 support for 64-bit storage
	discuss the support provided for an increased number of partitions
	describe the new features allowing more complex join statements

	Availability

	describe the new partitioned tables function
	list the various index classifications
	discuss online schema changes
	relate the changes to partition management
	describe the processes for system level point in time recovery

	SQL enhancements

	describe the use of dynamic scrollable cursors
	explain multirow FETCH and INSERT
	describe the GET DIAGNOSTICS statement
	discuss the use of recursive SQL
	describe sequence objects and their usage
	discuss the usage of a scalar full select
	describe the usage of a SELECT statement in an INSERT statement

	e-business

	discuss the DB2 Universal Driver for SQL for Java (SQLJ) and JDBC
	describe the new integrated Extensible Markup Language (XML) publishing functions
	relate the enhancements to DB2 security functions

	Unicode in DB2 for z/OS

describe the fundamentals of Unicode and how it is implemented.

	Network computing

describe new functions including member routing, Distributed Relational Database Architecture (DRDA) data stream encryption, and rollup of accounting data for threads.

	Application enablement

	describe the new functions for stored procedures and User Defined Function (UDF) routines
	relate the use of the new capabilities of Open Database Connectivity (ODBC) for UNIX System Services

	Utility enhancements

	describe the new features of LOAD and UNLOAD
	discuss the methods for rebalancing partitions
	explain the changes to the REORG, COPY, REPAIR, and DSN1COPY utilities
	relate the utility changes to support Data Partitioned Secondary Indexes (DPSI)

	Performance enhancements

	describe the new index support functions
	discuss the new capabilities for obtaining distribution statistics
	relate the implications of volatile tables
	explain the new capabilities for processing star joins
	describe the new functions for Visual Explain

	Data sharing enhancements

	describe the V8 reduction in Coupling Facility (CF) lock propagation
	explain CF request batching
	relate the improvements for Logical Page list (LPL) recovery

	Installation and migration

	plan for Version 8
	discuss the migration process and implications
	describe the changes to the catalog

	Day 1

	welcome
	scalability
	availability
	exercise - partitioned table and index spaces
	exercise - ADD/ROTATE partitions

	Day 2

	exercise - versioning
	SQL enhancements
	exercise - sequences
	exercise - recursion
	e-business
	exercise - XML publishing functions

	Day 3

	Unicode in DB2 for z/OS
	exercise - Unicode
	network computing
	application enablement
	utility enhancements
	performance enhancements

	Day 4

	performance enhancements (continued)
	data sharing enhancements
	installation and migration
	exercise - Materialized Query Tables (MQT)