This course is designed to describe the major technical features and enhancements provided by the DB2 for Linux, UNIX and Windows database 10.5 software. DB2 10.5 has two primary areas of focus. One key feature of DB2 10.5 is the new support for column-organized tables to provide accelerated analytic processing called BLU Acceleration. Another important focus for DB2 10.5 is a set of enhancements for the DB2 pureScale feature, including online topology changes and the support for High Availability Disaster Recovery (HADR) with a DB2 pureScale cluster.

If you are enrolling in a Self Paced Virtual Classroom or Web Based Training course, before you enroll, please review the Self-Paced Virtual Classes and Web-Based Training Classes on our Terms and Conditions page, as well as the system requirements, to ensure that your system meets the minimum requirements for this course.

http://www.ibm.com/training/terms

• Implement column-organized table support for a new or existing DB2 database
• Describe how the column dictionaries used to provide extreme compression of column-organized tables are built and utilized
• Explain the impact of setting the DB2 registry variable DB2_WORKLOAD to ANALYTICS
• List the seven 'big ideas' that work together to provide DB2 BLU acceleration
• Describe the different storage used for column-organized table compared to row-organized tables
• Explain how DB2 uses a synopsis table to support data skipping with column-organized tables
• Monitor a DB2 database or application that uses column-organized tables
• Use db2convert or ADMIN_MOVE_TABLE to convert row-organized tables to column-organized tables
• Describe the DB2 pureScale cluster topology changes that can be made online, without database downtime
• Plan and implement High Availability Disaster Recovery (HADR) for a DB2 pureScale database
• Explain how member subsets can be used to manage how an application views the topology of the pureScale database environment
• Utilize DB2 provided routines to define, alter and drop member subsets for a pureScale database
• Explain which types of Backup and Restore operations for DB2 pureScale databases can utilize online backups or require offline database backups
• Implement Explicit Hierarchical Locking to reduce data sharing costs when tables are only accessed by single members
• Describe the product packaging enhancements in DB2 10.5 including the new Advanced Workgroup Server edition
• Plan the upgrading of existing DB2 database servers to DB2 10.5
• Explain the support for large row sizes with DB2 10.5
• List the supported operating systems for running DB2 10.5 database servers
• Use DB2 Version 10.5 to create an index that contains an expression-based key
• Monitor DB2 10.5 databases and instances using SQL table functions MON_GET_DATABASE and MON_GET_INSTANCE

This intermediate course is for system administrators, database administrators, and technical personnel involved in planning, implementing, and maintaining DB2 LUW 10.5 databases and have experience working with DB2 LUW Version 9 or Version 10.1.

You should have:

• Experience supporting DB2 Linux, UNIX and Windows Version 9.7, 9.8 or 10.1 databases

• Unit 1 - DB2 10.5 BLU Acceleration Concepts
• Unit 2 - DB2 10.5 BLU Acceleration Implementation and Use
• Unit 3 - DB2 10.5 enhancements for the DB2 pureScale feature
• Unit 4 - Planning for DB2 10.5 implementation, and Additional general usage features for DB2 database servers