This course is designed to teach students how to:
– Perform advanced monitoring using the Db2 administrative views and routines in SQL queries.
– Manage the disk space assigned in Database Managed Storage (DMS) and Automatic Storage table spaces, including the activities of the rebalancer.
– Use SQL queries and Db2 commands to check the high water mark on table spaces and to monitor the rebalance operation.
– Utilize the REBUILD option of RESTORE, which can build a database copy with a subset of the tablespaces using database or tablespace backup images.
– Plan and execute the TRANSPORT option of RESTORE to copy schemas of objects between two Db2 databases.
– Create incremental database or tablespace level backups to reduce backup processing and backup image storage requirements.
– 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.
– Describe the various types of database memory including buffer pools, sort memory, lock memory and utility processing memory.
– Adjust database or Db2 instance configuration options to improve application performance or processing efficiency.
– Implement Db2 Self Tuning Memory management for specific database memory areas.
IBM Open Source & Big Data Analytics Courses
Click Here to Request It.
CL464G – Db2 11.1 Advanced Database Administration
This course is designed to teach students how to:
CV844G – Db2 12 for z/OS Basic Database Administration
This course will expose the beginning z/OS DBAs (Database Administrators) to fundamentals of Database Administration for a Db2 12 for z/OS. This course will teach the students how to physically implement a logical database design using DDL, and teaches considerations of referentially related tables. This course discusses the use of basic utilities, program preparation, serialization, and basic database security. This course does not cover distributed data processing, nor does it cover data sharing.
- Instructor Led Online
DW601G – IBM BigInsights Overview
This course provides an overview of IBM’s big data strategy, and reviews the importance of understanding and using big data. It will cover IBM BigInsights as a platform for managing and gaining insights from your big data, as well as how BigInsights offerings have been aligned to better suite user needs with IBM Open Platform (IOP). Students will also be introduced to the three specialized value-add modules that sits on top of the IOP: Big SQL, BigSheets, and Big R. The participant will be engaged with the product through interactive exercises.
DW606G – IBM Open Platform with Apache Hadoop
IBM Open Platform (IOP) with Apache Hadoop is the first premiere collaborative platform to enable Big Data solutions to be developed on the common set of Apache Hadoop technologies. The Open Data Platform initiative (ODP) is a shared industry effort focused on promoting and advancing the state of Apache Hadoop and Big Data technologies for the enterprise. The current ecosystem is challenged and slowed by fragmented and duplicated efforts between different groups. The ODP Core will take the guesswork out of the process and accelerate many use cases by running on a common platform. It allows enterprises to focus on building business driven applications.
This module provides an in-depth introduction to the main components of the ODP core –namely Apache Hadoop (inclusive of HDFS, YARN, and MapReduce) and Apache Ambari — as well as providing a treatment of the main open-source components that are generally made available with the ODP core in a production Hadoop cluster.
DW613G – IBM BigInsights Foundation
This course provides a foundation of IBM BigInsights through two separate modules: IBM BigInsights Overview and IBM Open Platform with Apache Hadoop.
In the first module, students will cover IBM BigInsights as a platform for managing and gaining insights from your big data, as well as value-add tools including Big SQL, BigSheets, and Big R.
In the second module, students will gain an in-depth introduction to the main components of the ODP core – namely Apache Hadoop (inclusive of HDFS, YARN, and MapReduce) and Apache Ambari.
DW633G – IBM BigInsights Big SQL
This course introduces students to the capabilities of Big SQL, a part of IBM BigInsights that allows you to access your HDFS data by providing a logical view to it. You can use the same SQL that was developed for your data warehouse data on your HDFS data. This course will provide some context on why students would use Big SQL, followed by how to use Big SQL to access data. It will also cover Big SQL federation allowing students to join various data sources with Big SQL. Big SQL also integrates with a number of other components including Spark, HBase and BigSheets.
DW634G – IBM Big SQL for Developers (v5.0)
This course is designed to introduce the student to the capabilities of IBM Big SQL. IBM Big SQL allows you to access your HDFS data by providing a logical view to it. You can use the same SQL that was developed for your data warehouse data on your HDFS data.
This course provides context on why students would use Big SQL followed by how to use Big SQL to access your data. It also covers what Big SQL is, how it is used, and the Big SQL architecture. The course also covers how to connect to Big SQL, create tables with a variety of data types, load data in, and run queries against the data. The course also shows how to use Big SQL with other components of the Hadoop ecosystem.
DW644G – IBM BigInsights BigSheets
This course introduces students to the capabilities of BigSheets. BigSheets is a component of IBM BigInsights through the Analyst and the Data Scientist module. It provides the analyst the ability to be able to visualize and analyze data stored on the HDFS using a spreadsheet type interface without any programming.
DW653G – BigInsights Analytics For Programers
This course is designed to aid programmers who are working with IBM’s InfoSphere BigInsights. Students will learn how to create annotators through the use of IBM’s Annotation Query Language (AQL). Analyzing data using Apache’s Hadoop normally requires that MapReduce programs be written. Students will learn how to use Jaql to create high level programs that are decomposed into Hadoop MapReduce programs. Students will learn a foundation to program using the Apache Pig language, and how to publish a text analytics application from the BigInsights development environment to a BigInsights server.
DW654G – IBM BigInsights Text Analytics (V4)
This course will teach students how to use IBM BigInsights Text Analytics, an information extraction system, to extract information from unstructured and semi-structured documents. Using IBM BigInsights Text Analytics students can create extractors using a visual web interface. The visual extractors are then automatically translated into Annotation Query Language (AQL) rules to extract structured information from unstructured and semi-structured documents. Students can apply Text Analytics to big data at rest in IBM BigInsights and big data in motion in IBM Streams.