This course is designed to introduce you 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.
-
This DW613G: IBM BigInsights Foundation training course is for those who want a foundation of IBM BigInsights. This course consists of two separate modules.
The first module is IBM BigInsights Overview and it will give you an overview of IBM’s big data strategy as well as a why it is important to understand and use big data. It will cover IBM BigInsights as a platform for managing and gaining insights from your big data. As such, you will see how the BigInsights have aligned their offerings to better suit your needs with the IBM Open Platform (IOP) along with the three specialized modules with value-add that sits on top of the IOP. Along with that, you will get an introduction to the BigInsights value-add including Big SQL, BigSheets, and Big R.
The second module is 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.
IBM BigInsights v4 itself is built upon the ODP core and these other main open-source components.The relationships between the IBM Open Platform with Apache Hadoop and the BigInsights add-ons is covered briefly in Unit 1 – pro.
-
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.
-
This CV964G: Db2 12 for z/OS SQL Performance and Tuning course is designed to teach the students how to prevent SQL performance problems and how to improve the performance of existing SQL.
-
This Application Performance and Tuning course is designed to teach the students how to prevent application performance problems and to improve the performance of existing applications. Students will learn about indexes, table design, locking, and other issues relevant to application performance. This course includes paper exercises and machine exercises designed to reinforce the lecture content.
-
This course will introduce the student to advanced database administration skills, including program preparation and the use of packages, online schema changes, partition management, and stored procedures; as well as performance and availability features of utilities (including LOAD, REBUILD INDEX, REORG, and UNLOAD). This course does not cover distributed data processing, nor does it cover data sharing.
-
This CV871G: DB2 10 for z/OS Utilities for Database Administrators course is designed to teach you advanced topics about DB2 for z/OS utilities. It is assumed that you attended course DB2 10 for z/OS Database Administration Workshop Part 1 (CV831) so that you already have basic skills about the main utilities. Recovery-oriented topics are not part of this course, so such utility functions are not presented.
-
This course is for installers of DB2 10 z/OS and/or migration to DB2 11 for z/OS using the Install CLIST. The participants are involved in lectures that explain DB2 11 components and pointers, and the processes used to install or migrate from DB2 10 for z/OS. To reinforce the lectures, a series of labs are provided to give each participant hands-on experience installing DB2 10 for z/OS and migrating to DB2 11 for z/OS.
-
This CV853G: Db2 12 for z/OS Introduction to System Administration course provides students with an introduction to the skills and knowledge needed to administer a Db2 12 for z/OS system.
-
Administrators of DB2 11 for z/OS can acquire a view of the architecture and fundamental processes required to manage a DB2 11 for z/OS subsystem. Engage in lectures and hands-on labs to gain experience to:
- Relate the z/OS IPL process to a DB2 subsystem
- Explain effects of stopping and starting DB2
- Explain how DB2 sets and use Integrated Catalog Facility (ICF) catalog names
- The use of DSN command processor running in batch and foreground
- Use views to minimize users’ ability to see into the DB2 catalog
- See how the catalog (through grant activity) controls access to data
- Search the catalog for problem situations
- Use the catalog and DB2 utilities to determine data recovery requirements
- Describe Internal Resource Lock Manager (IRLM) in a DB2 environment
- Implement DB2 and Resource Access Control Facility (RACF) security
- Describe DB2 program flow for all environments
- Display normal and problem threads and database status
- See how the SQL Processor Using File Input (SPUFI) AUTOCOMMIT option defers the COMMIT/ROLLBACK decision
- Interpret lock displays
- Identify and cancel particular threads
- Describe available DB2 utilities to manage system and user page sets
-
The course is updated for DB2 10 for z/OS. This course is the classroom delivered version of the Instructor led Online course
- DB2 10 for z/OS System Administration – ILO (3V851).
Administrators of DB2 10 for z/OS can acquire a view of the architecture and fundamental processes required to manage a DB2 10 for z/OS subsystem. Engage in lectures and hands-on labs to gain experience to:
- Relate the z/OS IPL process to a DB2 subsystem
- Explain effects of stopping and starting DB2
- Explain how DB2 sets and use Integrated Catalog Facility (ICF) catalog names
- The use of DSN command processor running in batch and foreground
- Use views to minimize your ability to see into the DB2 catalog
- See how the catalog (through grant activity) controls access to data
- Search the catalog for problem situations
- Use the catalog and DB2 utilities to determine data recovery requirements
- Describe Internal Resource Lock Manager (IRLM) in a DB2 environment
- Implement DB2 and Resource Access Control Facility (RACF) security
- Describe DB2 program flow for all environments
- Display normal and problem threads and database status
- See how the SQL Processor Using File Input (SPUFI) AUTOCOMMIT option defers the COMMIT/ROLLBACK decision
- Interpret lock displays
- Identify and cancel particular threads
- Describe available DB2 utilities to manage system and user page sets
-
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.
