UD11 - DB2 for LUW Version 9.5 and 9.7 Transition
Duration1 Day (customisation)
Availability

Course Description

This course is aimed at Database Administrators and applications developers who need to understand the new features and facilities of DB2 for LUW Version 9.5 and 9.7. This lecture based one-day course covers all of the new features in detail.

Pre-requisites

A strong working knowledge of DB2 for LUW Version 9.1 is required to attend this course.

Objectives

The aim of this course is to provide the delegate, familiar with DB2 V9.1, with the necessary skills required to use the new Version 9.5 and 9.7 features.

Environment

The lectures apply to DB2 running in a Linux, Unix or Windows environment.

Customisation

For on-site courses (i.e. at your premises), we are more than happy to tailor the course agenda to suit your exact requirements. In many cases, we are able to build your in-house standards and naming conventions into the delivered course.

Course Details

DB2 V9R5 ENHANCEMENTS
MANAGEMENT ENHANCEMENTS
Automatic creation of Compression Dictionaries
New workload management features
Multithreaded architecture extensions
Deployment improvements
Easier management of partitioned database systems
Automatic storage management enhancements
Additional automatic configuration parameters
Automated maintenance improvements
PERFORMANCE ENHANCEMENTS
Query performance enhancements
Automatic statistics collection improvements
LOB management performance improvements
Multidimensional clustered table (MDC) enhancements
Increased concurrency
XML ENHANCEMENTS
High-speed XML data load
pureXML performance improvements
XML with Triggers and Check Constraints
Conversion of XML into HTML, plain text, and other formats
Schema compatibility management
Non-Unicode database support
SQL/XML and XQuery enhancements
Decomposition enhancements for pureXML
DB2 Text Search support
SECURITY ENHANCEMENTS
Trusted contexts support
Database roles
Label-based access control (LBAC) enhancements
Audit facility enhancements
Security administrator authority level enhancements
AVAILABILITY ENHANCEMENTS
Automated maintenance enhancements
Recovery enhancements
Faster backup and restore operations
Improved failover and recovery capabilities
Faster offline redistribution of partitioned databases
WORKLOAD MANAGEMENT ENHANCEMENTS
DEVELOPMENT ENHANCEMENTS
Decimal floating-point data type support
Application portability improvements
JDBC and SQLJ enhancements
Tool set enhancements
Trusted contexts support
DB2 V9R7 ENHANCEMENTS
AUTOMATIC STORAGE ENHANCEMENTS
Conversion of Existing Tablespaces
Reclaiming unused space
Adding new Paths
PERFORMANCE ENHANCEMENTS
Inline LOBS
New Currently Committed (CC) Isolation
More Efficient Queries with Literals
Scan Sharing
Local Range Partition Indexes
Statement concentrator
COMPRESSION ENHANCEMENTS
Index Compression
TEMP TABLE Compression
XML Compression
Inline LOB Compression
Compact MDC Tables
MONITORING ENHANCEMENTS
New and enhanced administrative views
New SQL Accessible Monitor Objects
WORKLOAD MANAGEMENT ENHANCEMENTS
ONLINE SCHEMA ENHANCEMENTS
Online Table Move
ADMIN_MOVE_TABLE Stored Procedure
Convert Existing Databases to Automatic Storage
Rename Columns
TRUNCATE TABLE
OR REPLACE option for Tables
APPLICATIONS DEVELOPMENT ENHANCEMENTS
Support Created Global Temporary Table
New Data Types
New Scalar Functions
Oracle Compatibility
Use Oracle's PL/SQL in DB2
Stored Procedure Parameter Markers
XML ENHANCEMENTS
XML in DPF Partitions and Database Objects
pureXML support
SECURITY ENHANCEMENTS
SYSADM separation of duties
New and Changed Security Roles
Longer Passwords Allowed
LDAP and SSL improvements
SSL Connection in DB2
DEPRECATED FEATURES

Course Format

The course is purely lecture based and contains no practical exercises. A comprehensive Student Guide is supplied which contains detailed documentation of the new version together with many syntax examples where relevant. Delegates will also be able to access a free help-line with technical questions relating to topics covered on the course.