Lektoři z firmy: ICT Pro s.r.o. – Kurzy, školení, konzultace ICT a Soft Skills
This course is designed to teach you how to: Fully use the advanced technical functions and features of DB2 LUW 10.1 and 10.5. Implement DB2 BLU Acceleration, column-organized table support, for a new or existing DB2 database. Describe how the column dictionaries used for DB2 BLU Acceleration are built and utilized to provide extreme compression for column-organized tables. Explain the default workload management used for DB2 BLU Acceleration processing and how you can tailor the WLM objects to efficiently use system resources. Monitor a DB2 database or application that uses column-organized tables using SQL monitor functions. Implement Shadow tables for selected row-organized tables to improve analytics query performance Configure a DB2 database that supports a mixture of application processing, including OLTP and Analytics query processing with Shadow tables and many more
|
This course is designed to teach you how to:
Fully use the advanced technical functions and features of DB2 LUW 10.1 and 10.5.
Implement DB2 BLU Acceleration, column-organized table support, for a new or existing DB2 database.
Describe how the column dictionaries used for DB2 BLU Acceleration are built and utilized to provide extreme compression for column-organized tables.
Explain the default workload management used for DB2 BLU Acceleration processing and how you can tailor the WLM objects to efficiently use system resources.
Monitor a DB2 database or application that uses column-organized tables using SQL monitor functions.
Implement Shadow tables for selected row-organized tables to improve analytics query performance
Configure a DB2 database that supports a mixture of application processing, including OLTP and Analytics query processing with Shadow tables and many more |