Target Audience
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.
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.
Course Environment
The lectures apply to DB2 running in a Linux, Unix or Windows environment.
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.
|