This course is designed to teach modelers how to build a complete model in IBM Planning Analytics using Planning Analytics Workspace. Through a series of lectures and hands-on exercises, students will learn how to set up dimensions and cubes, manually enter data into these structures, and define the data that users can see. Students will also learn how to transfer data into the IBM Planning Analytics model, including the use of TurboIntegrator scripts to perform data transfer. In addition, the course outlines how to customize drill paths, convert currencies, and model for different fiscal requirements.
Unlock the value of your data in new ways and accelerate your journey with IBM Data and Analytics.
Provide a trusted data foundation for AI by collecting and organizing data, then virtualize it across disparate systems for AI-fueled decisions. Learn to reduce regulatory and reputational risk with solutions from IBM Watson and IBM Security.
Artificial intelligence is changing the way businesses operate, and data is the key to unlocking its potential. IBM Data and Analytics provides the tools you need to collect, organize, and act on data so you can make better decisions for your company.
IBM Data and Analytics training will provide you with expertise to elevate customer experiences, automate IT operations and improve financial planning by integrating AI into workflows and learn to create an enduring data and AI strategy with a data & AI platform that runs anywhere.
Transform your business with the power of AI. With IBM Data and Analytics, you can get ahead of the competition by making smarter decisions based on real-time data. Enroll in an IBM course today.
-
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 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 CV832G: DB2 11 for z/OS Database Administration Workshop Part 1 course provides you with instruction on how to physically implement a logical database design in DB2. The course includes instruction on DB2 data management, DB2 catalog tables, the bind process, database utilities such as LOAD and REORG, and security considerations.
Note: This course material is at the DB2 11 for z/OS level.
-
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.
-
DB2 11 for z/OS beginning DBAs can develop fundamental skills or recognition through lectures and hands-on exercises of:
- TSO/E and ISPF
- Data sets
- DB2 Objects
- Structured Query Language
- DB2 Commands
- JCL and SDSF
- DB2 Utilities
- DB2 Logging
- DB2 Program Preparation
The course materials cover DB2 11 for z/OS.
-
This P8361G: IBM Planning Analytics: Design and Develop Models in Architect v2.0 course is designed to teach modelers how to build a complete model in IBM Planning Analytics using the Architect tool. Through a series of lectures and hands-on exercises, students will learn how to set up and verify dimensions, cubes, and views, manually enter data into these structures, and define the data that users can see.
Students will also learn how to transfer data into the IBM Planning Analytics model, including the use of TurboIntegrator scripts to perform data transfer. In addition, the course outlines how to customize drill paths, convert currencies, model for different fiscal requirements, and deploy IBM Planning Analytics applications to the web.
-
This course will teach about the InfoSphere Change Data Capture (CDC) component of the IBM InfoSphere Data Replication family of solutions. This course will examine the architecture, components and capabilities of CDC, and discuss various ways to setup and implement the software. This course will explore how to operate and troubleshoot CDC and discuss “Best Practices” in maintaining the Environment. Lastly, use cases will be provided to help student understand how replication is used using InfoSphere Change Data Capture to a Business Environment.
-
This offering covers the fundamental concepts of installing and configuring IBM Cognos Analytics, and administering servers and content, in a distributed environment.
In the course, participants will identify requirements for the installation and configuration of a distributed IBM Cognos Analytics software environment, implement security in the environment, and manage the server components. Students will also monitor and schedule tasks, create data sources, and manage and deploy content in the portal and IBM Cognos Administration.
-
Out of stock
This course is designed to teach you 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.
-
Out of stock
The course is intended for Data Administrators that need to prepare for using the DB2 BLU Acceleration facilities of DB2 11.1 for Linux, UNIX and Windows systems.
The concepts and facilities of the BLU Acceleration feature of DB2 11 are presented including loading data into column-organized tables and monitoring the processing of SQL statements that access the tables.
The DB2 10.5 Fix Pack 4, referred to as Cancun, added support for Shadow tables, a new type of Materialized Query Table, and also Column-organized User Maintained MQT tables. One lecture unit describes these features. A demonstration allows students to implement and experiment with these functions.
With DB2 11.1, BLU Acceleration can be used in a clustered multiple database partition DB2 environment. This course includes a lecture and demonstration that allows students to create a set of column-organized tables from an existing set of row-organized tables and execute and analyze the performance of BLU Acceleration in a MPP database.
The lab demonstrations are performed using DB2 LUW 11.1 for Linux.
