Get Free Widget

Courses

DB2 10.5 for LUW Advanced Database Administration with DB2 BLU Acceleration

DB2 10.5 for LUW Advanced Database Administration with DB2 BLU Acceleration

Category: DB2

Description

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
Create the Infosphere CDC Datastore, Subscription and Table mappings required to support Shadow tables
Implement a User Maintained MQT for a column-organized table
Create optimization profiles that allow applications to control specific operations included in the access plans selected by the DB2 Optimizer, like which index is used to access a table or which join method to utilize for joining tables.
Perform advanced monitoring using the DB2 administrative views and routines in SQL queries.
Configure and manage the implementation of DB2 instance or database level auditing, including using the db2audit command and creation of audit policies which can be assigned to specific tables, users or database roles to perform selective collection of audit records.
Explore DB2's management of disk space usage in Database Managed Storage (DMS) table spaces, including the activities of the rebalancer. Use SQL queries and utilities to check the high water mark on table spaces and to monitor the rebalance operation.
Move data from one table to another or from one database to another using utilities like db2move.
Utilize the ADMIN_MOVE_TABLE procedure to implement table changes with a minimal impact to data availability for applications.
Implement automatic storage management for table spaces and storage groups or enable automatic resize options for DMS managed table spaces to reduce administration requirements and complexity.
Exploit and monitor the REORG utility processing for offline and online table, and index reorganization This includes planning for the disk space and database log space necessary for reorganization.
Utilize the REORG Utility to implement row compression for large tables, to reduce disk utilization and improve I/O performance for a DB2 database and understand the automatic creation of compression dictionaries.
For Multidimensional Clustering (MDC) tables, determine how to select the dimension columns and table space extent size for efficient implementation of MDC tables. Compare the block indexes used with MDC tables with rows based indexes. Select the MDC rollout option that best matches application needs and achieves the best performance results.
Plan and implement range based table partitioning for large DB2 tables. Utilize the ALTER TABLE ATTACH and DETACH options to support roll-in and roll-out operations for range-partitioned tables. Compare the advantages of selecting or combining range partitioning with the hash-based partitioning used in DB2 partitioned databases or the multiple dimensions provided by MDC tables.

Audience

This is an advanced course for DB2 LUW experienced database administrators who support DB2 for UNIX, Windows, and Linux databases.

Duration

5 days

Requirements

DB2 10 for LUW: Basic Administration for Linux and Windows (CL2X3) or
DB2 10 for LUW: Basic Administration for AIX (CL213) or
DB2 10 for Linux, UNIX, and Windows Quickstart for Experienced Relational DBAs (CL485)
Or have equivalent experience

Curriculum

Advanced Monitoring
Advanced Table Space Management
DB2 10.5 BLU Acceleration Concepts
DB2 10.5 BLU Acceleration Implementation and Use
DB2 10.5 BLU Acceleration Implementing Shadow Tables and User Maintained MQTs
Using Optimizer Profiles to control Access Plans
Table Partitioning
Advanced Data Movement
Advanced Table Reorganizatiobr />Multiple Dimension Clustering
DB2 Database Auditing

Classes

City Date Duration Language Format Early Price Exp Date Price Early bird Price Regular GTR

Register Here!

Our Delivery

on site delivery

Online or On-site de

We created a personalized delivery strategy by offering blended learning

communities of practice

Communities of practice

Find a bunch of people who are on the same page with you.

engaging

Engaging

Engaging platform with gamification for collaboration and friendly competition.

interactive

Interactive

Interactive online trainings and live webinars available.

efficient

Efficient

A special learning environment can boost learning efficiency.

accesible

Accessible

Available anywhere and anytime, on your phone, computer or tablet.

Q&A

  • Can you customize courses to suit our particular requirements? Yes, of course. We offer training consultancy and we establish the most appropriate solution according to the specific needs and business objectives of your company. Contact us and we’ll find the best training solution for you.
  • Can individuals use your services or they are organized for companies?Yes, we organise open courses which can be accessed by individuals. Whether you are looking for an IT or a Business training, you can find it at Brain Concert. Moreover, you’ll meet people from the same area of work as you and we can create communities of practice, where you can share professional tips and tricks and best practices.
  • What types of trainings are available for my company? We offer a variety of courses: in the IT area, there are Agile & Lean Courses, Software Development Courses, QA Courses, Software Administration Courses and Security Courses. We also offer Business Courses, focused on the development of soft skills. Define your objectives and choose the most appropriate training for you or your company.
  • What should I know before choosing a training? You should know that we offer courses for everyone, but you have to choose according to some criteria. First, define your objectives, then, the level of the participants (basic, advanced). There are courses with some requirements attached because the participants of a training session must form a compact group in terms of their previous knowledge so that they and the trainers are on the same page.
  • What is the minimum number of participants if we want in-house training? The minimum number of participants for an in-house depends on the course type. Please contact us to establish these details.
  • Can you organize virtual training sessions or only face to face trainings? Yes, you can choose an online or offline training session. We use Knolyx, an e-learning platform to make the process of online training delivery as efficient as a face to face training session.