DB2 10.5 for LUW New Features and Database Upgrade ConsiderationsIBM
Preis auf Anfrage
- An 3 Standorten
Häufig gestellte Fragen
You should have:
- Experience supporting DB2 Linux, UNIX and Windows Version 9.7, 9.8 or 10.1 databases
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 new support for column-organized tables to provide accelerated analytic processing called BLU Acceleration.
Another important focus are 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.
Training Paths that reference this course are:
- DB2 for Linux, UNIX and Windows Transition
Erfolge des Zentrums
- 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 env