In DB2 BLU Acceleration Implementation and Use training course, the concepts and facilities of the BLU Acceleration feature of DB2 are presented including loading data into column-organized tables and monitoring the processing of SQL statements that access the tables.
By attending DB2 BLU Acceleration Implementation and Use workshop, delegates will learn to:
- Implement DB2 BLU Acceleration, column-organized table support, for a new or existing DB2 database
- Configure a DB2 database that uses DB2 BLU Acceleration, column-organized tables, including sort memory and utility heap memory considerations
- Describe the default workload management used for DB2 BLU Acceleration processing and how you can tailor the WLM objects to efficiently use system resources
- Locate the column-organized processing portion of the access plans for column-organized tables in DB2 explain reports
- Use db2convert or ADMIN_MOVE_TABLE to convert row-organized tables to column-organized tables
This DB2 BLU Acceleration Implementation and Use class is ideal for DB2 LUW experienced database administrators who support DB2 for UNIX, Windows, and Linux databases and want to learn more about the DB2 BLU acceleration capabilities in DB2.