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.
-
Learn to explore, summarize and interpret data like a pro.
This 0G51BG: Statistical Analysis Using IBM SPSS Statistics v26 course provides an application-oriented introduction to the statistical component of IBM SPSS Statistics. Students will review several statistical techniques and discuss situations in which they would use each technique, how to set up the analysis, and how to interpret the results. This includes a broad range of techniques for exploring and summarizing data, as well as investigating and testing relationships.
Students will gain an understanding of when and why to use these various techniques and how to apply them with confidence, interpret their output, and graphically display the results.
-
This course gets those charged with administering Information Server v11.5 and its suite of many products and components started with the basic administrative tasks necessary to support Information Server users and developers.
The course begins with a functional overview of Information Server and the products and components that support these functions. Then it focuses on the basic administrative tasks an Information Server administrator will need to perform including user management, session management, and reporting management tasks. The course covers both the use of Information Server administrative clients such as the Administration Console and Metadata Asset Manager and the use of command line tools such as istool and encrypt.
-
This course is designed to teach you how to use z/OS Job Control Language (JCL) and selected z/OS utility programs in an online batch environment. Both Storage Management Subsystem (SMS) and non-SMS JCL are discussed. Machine lab exercises complement the lecture material.
-
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.
-
This course will help you to better understand the techniques of performance analysis and capacity planning on systems and partitions running IBM i and develop an appreciation of how IBM i operates and interfaces with applications. This course is expected to build skills to better manage performance and capacity on systems and partitions running IBM i.
The course explains IBM i concepts, including the Technology Independent Machine Interface (TIMI), main storage pools, auxiliary storage pools, management of jobs, threads, and tasks, job run-time structure, performance monitoring, data collection, and analysis of performance data.
This course includes hands-on activities using performance data from IBM i systems to help the student appreciate the concepts discussed. This course is designed for those running Power Systems on IBM i. While it includes i 7.2 content, it is suitable for those currently using prior versions of IBM i.
The first part of this course (units 1-6) focus on teaching the performance management process, the performance considerations of key hardware components and virtualization options, and tuning options to help optimize performance. During these lectures, students should gain an appreciation of the unique storage management and work management components in the IBM i architecture and how these components need to be managed for optimal performance.
The second part of this course focuses on the tools and techniques to monitor, analyze, and plan for performance of Power Systems with IBM i and Logical partitions (LPARs).
The primary analysis tool that will be used is the Performance Data Investigator (PDI) which is included with IBM Navigator for i. PDI is also used with IBM Systems Workload Estimator (WLE) for capacity planning activities.
-
In this course you will create basic case management solutions with IBM Case Manager Builder and Process Designer. Using an iterative solution development process, you will create, deploy, test, and revise your solutions, adding complexity and functionality to your solutions as you gain skills. You will create properties and document classes, configure roles and in-baskets, and define case stages. You will work with case types, tasks, and workflows. This course includes some guidelines on solution design principles. After completing this course, you can build on these skills by taking more advanced or specialized courses in security, user-interface customization, and solution deployment.
-
This is the follow on course to AS24G. This course teaches advanced operator skills. OL19G may also interest this student.
This course is designed to enhance the skills of an IBM i System Operator. This course explains the concept of how LPAR works and discusses the functions provided by the HMC. We will discuss the IBM i Access Family of products in general and Access Client Solutions, specifically. We will discuss the different types of security that you can implement in order to control who has access to your data and what they can do with that data if they are allowed to access. We will discuss security control via system values, user and group profiles, authorization lists, and adopted authority. This course will help you develop additional skills in the areas of work management and how to create a basic CL program. In the area of CL programming, we discuss concepts of programming, then how to create a basic CL program using the traditional application development tools PDM and SEU. Then, you will learn how to use the GUI tools in RDP (RSE and LPEX). You will also learn the steps to create a menu using SDA. You will learn some tips that you can use to help improve your IBM i operations. We will also discuss how you can use Management Central as a tool to manage a single system or a network of TCP/IP connected Power Systems with IBM i.
-
This WM153G: IBM MQ v9 System Administration (using Windows for labs) course provides technical professionals with the skills that are needed to administer IBM MQ queue managers on distributed operating systems and in the Cloud. In addition to the instructor-led lectures, you participate in hands-on lab exercises that are designed to reinforce lecture content. The lab exercises use IBM MQ V9.0, giving you practical experience with tasks such as handling queue recovery, implementing security, and problem determination.
Note: This course does not cover any of the features of MQ for z/OS or MQ for IBM i.
-
This O3201G: Fundamentals of IBM Watson Explorer Deep Analytics Edition oneWEX v12.0.x course is designed to teach students core concepts of IBM Watson Explorer Deep Analytics Edition oneWEX. Students will learn to identify the oneWEX platforms as well as the process flow and data flow of oneWEX projects.
Students will explore oneWEX tools, such as Content Miner and the Admin Console, while gaining hands-on experience in data acquisition and enrichment. Finally, students will be exposed to more advanced topics, such as Application Builder, Content Analytics Studio, and API usage.
-
This course is designed to teach participants how to identify components and sub-components of the IBM Cognos Analytics architecture and how to use tools and techniques to provide a foundation to troubleshoot issues. Through lecture and interactive exercises participants will identify IBM Cognos Analytics components, examine how these components interact with Java, and will explore logging to assist when troubleshooting issues.
-
This course teaches how to build QualityStage parallel jobs that investigate, standardize, match, and consolidate data records. Students will gain experience by building an application that combines customer data from three source systems into a single master customer record.
-
This course is designed to provide the SMP/E skills needed in the installation and maintenance of optional features and maintenance in the z/OS operating environment. You are taught to define the SMP/E database and invoke SMP/E to add, modify, or replace system elements. The course includes extensive hands-on labs using a current level of SMP/E.
You will get practical experience in the SMP/E tasks involved in installing a z/OS product. Emphasis is on interpreting results of SMP/E processing. SMP/E concepts examined in this course include modification control statements, the consolidated software inventory, zone structure, and error analysis. SMP/E commands such as RECEIVE, APPLY, ACCEPT, RESTORE, REPORT, and LIST are discussed.
You will also learn how to perform automated SMP/E delivery of z/OS and product maintenance over the Internet with an automated SMP/E process that downloads and installs IBM preventive and corrective service over the Internet.
-
This course is designed to guide report authors in building on their expertise with IBM Cognos Analytics by applying dimensional techniques to reports. Through interactive demonstrations and exercises, participants will learn how to author reports that navigate and manipulate dimensional data structures using the specific dimensional functions and features available in IBM Cognos Analytics.
-
To provide an overview of the z Operating System (OS), look at the systems from both a hardware and software prospective, and develop a basic understanding of System z partitioning capabilities, Processor Resource/Systems Manager (PR/SM), z/OS, Job Entry Subsystem 2 (JES2), Job Entry Subsystem 3 (JES3), Time Sharing Option (TSO), TSO Extended (TSO/E), System Display and Search Facility (SDSF), z/OS Communications Server, and System z channel subsystem usage for various channels, such as Enterprise System Connection (ESCON), Fiber Connector (FICON), and the Open Systems Adapter (OSA). It will also describe the Initial Program Loader (IPL) process and enable you to become comfortable issuing z/OS commands from a Multi Console Support (MCS) system console or extended MCS console.
-
This WE751G: Essentials of Service Development for IBM DataPower Gateway v7.5 course teaches you the essential skills that are required to configure, implement, and troubleshoot services that are developed on the IBM DataPower Gateways (IDG) with firmware version 7.5.0, regardless of use case. The DataPower Gateways allow an enterprise to simplify, accelerate, and enhance the security capabilities of its XML and web services deployments, and extend the capabilities of its service-oriented architecture (SOA) infrastructure. The gateways also extend these capabilities into the JSON, REST, and Mobile application areas.
Through a combination of instructor-led lectures and hands-on lab exercises, you learn how to develop and debug services that are implemented on the DataPower gateways. These skills include WebGUI and Blueprint Console navigation, service type selection, basic multi-protocol gateway configuration, creating and using cryptographic objects, and configuring SSL connections. You also learn how to use various problem determination tools such as logs, monitors, and probes, and techniques for testing DataPower services and handling errors.
Hands-on exercises give you experience working directly with a DataPower Gateway. The exercises focus on skills such as creating multi-protocol gateways, working with cryptographic and SSL objects, configuring service level monitoring, troubleshooting services, handling errors in a service policy, and deploying a service from a pattern.
-
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 course is a continuation of course DB2 10 for z/OS Database Administration Workshop Part 1 (CV831) and is designed to teach you how to perform additional database administration tasks.
This course replaces DB2 for z/OS Database Administration Workshop Part 2 (CV841). This is the Classroom version of Instructor-led online course DB2 10 for z/OS Database Administration Part 2 – ILO (3V842).
-
This course is for those whose job includes responsibility for designing the file plan for an IBM Enterprise Records system and making decisions regarding record retention, disposition, and security. You use the IBM Enterprise Records web application to learn core skills, such as declaring and managing records. Then, you learn to design and create a file plan that meets specific records management goals. You work with a records administrator, an installer, a database administrator, and a programmer. You must be able to organize and communicate records management system requirements to the other roles.
You work with a fully functioning IBM Enterprise Records system to practice the skills required for managing records and designing file plans for records management.
-
This course provides you with information about the functions of IBM’s DB2, a relational database manager which may be installed under a variety of operating systems on many hardware platforms.
DB2 runs under the z/OS, VM, Linux, UNIX, and Windows operating systems, to name a few.
The course includes discussion of how the DB2 products provide services. The focus is on the services DB2 provides and how we work with DB2, not on its internal workings.
-
This offering teaches Professional Report Authors about advanced report building techniques using relational data models, dimensional data, and ways of enhancing, customizing, managing, and distributing professional reports. The course builds on topics presented in the Fundamentals course. Activities will illustrate and reinforce key concepts during this learning activity.
-
Learn to write easy to use and efficient control language (CL) programs which may be used to perform a variety of system and application control functions. You are taught to write basic and intermediate level, interactive, and batch CL programs, user commands, and CL programs that function as user tools (programs that use the output of display commands as input).
You will learn to write Control Language (CL) programs which may be used to perform a variety of system and application control functions. You will be taught to write basic and intermediate level interactive and batch CL programs as well as programs that function as user tools (programs that use the output of display commands as input).
-
This course is an introduction to IBM Case Manager, concepts, functions, and architecture. Participants use an IBM Case Manager system to practice the skills that are required by case workers to process cases and create runtime tasks.
-
In this course students learn how the Information Governance Catalog is used to govern information assets through the development of a governance catalog of categories and terms. This catalog documents information assets and governance policies and rules that implement the high-level strategy and objectives of a governance program.
-
This unit provides training on IBM StoredIQ. You learn about StoredIQ architecture, features, and functions. You also learn the core skills for data experts, matter experts, and administrators. You work with an IBM StoredIQ system to practice the skills that you learn.
If you are enrolling in a Self Paced Virtual Classroom or Web Based Training course, before you enroll, please review the Self-Paced Virtual Classes and Web-Based Training Classes on our Terms and Conditions page, as well as the system requirements, to ensure that your system meets the minimum requirements for this course.
-
This course is designed to provide you with the skills required to install and customize z/OS UNIX (full name z/OS UNIX System Services), and to manage and monitor the z/OS UNIX environment.
-
The ZZ981G: InfoSphere MDM Physical Module Algorithms v11 course prepares you to work with and customize the algorithm configurations deployed to the InfoShere MDM Probabilistic Matching Engine (PME) for the Physical MDM implementation.
Learn about
- Information Management
- InfoSphere Master Data Management (MDM)
- InfoSphere Master Data Management
-
This course is for those whose job includes responsibility for designing the file plan for an IBM Enterprise Records system and making decisions regarding record retention, disposition, and security. You use the IBM Enterprise Records web application to create the file plan. You work with a records administrator, an installer, a database administrator, and a programmer. You must be able to organize and communicate records management system requirements to the other roles.
You work with a fully functioning IBM Enterprise Records system to practice the skills required for designing file plans for records management.
If you are enrolling in a Self Paced Virtual Classroom or Web Based Training course, before you enroll, please review the Self-Paced Virtual Classes and Web-Based Training Classes on our Terms and Conditions page, as well as the system requirements, to ensure that your system meets the minimum requirements for this course.
-
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.
-
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.
-
IBM Business Monitor is a business activity monitoring (BAM) product that supports BPM by measuring business performance, monitoring, and reporting on business transactions. This course includes topics of interest for students who want to use the IBM Business Monitor environment to develop applications.
In this course, you learn how to develop, implement, and test IBM Business Monitor applications so that you can generate real-time business views of enterprise data. The course begins with an overview of BAM and BPM, and the capabilities that IBM Business Monitor provides. In subsequent units, you learn how to build monitor models, establish performance metrics, monitor events, manage action services, and build a business space dashboard. You also learn how to enable events from various sources, including using BPEL and BPMN processes from IBM Business Process Manager Advanced and IBM Integration Bus. Finally, you learn how to monitor events from JMS emitter and REST emitter sources. You also learn some basic administration and maintenance capabilities of IBM Business Monitor.
From the hands-on exercises that are provided throughout the course, you develop and implement a monitoring solution. The exercises include how to use the various components of IBM Business Monitor, such as the IBM Cognos Business Intelligence and the Monitor development toolkit, for reporting and dimensional analysis along with WebSphere Application Server. You use the Monitor development toolkit to develop a monitor model, and then use the IBM Integration Designer to test the model. You also build customized business space dashboards that can be used to analyze and troubleshoot process performance.
-
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.
-
Organizations are compelled to find effective and cost-efficient data security solutions.
Encryption is one of the technologies that enables organizations to reduce the cost, impact and even likelihood of a breach. Encrypting data can help companies meet the stringent mandates of the GDPR, HIPAA and other mandates.
IBM z14 has been designed for pervasive encryption, enabling organizations to encrypt 100% of an organizations IBM Z critical business data in-flight and at-rest, with no application changes and no impact to SLAs. Encrypting only the data required to meet compliance mandates should be considered a minimum threshold, not a best practice. IBM z14 makes pervasive encryption the new standard in data protection and the foundation of a larger data security and protection strategy.
z/OS is designed to provide new policy-based encryption options that take full advantage of the improvements in the z14 platform. These new capabilities include:
- Data set encryption, which is one aspect of pervasive encryption, provides enhanced data protection for many z/OS data sets gives users the ability to encrypt data without needing to make changes to applications to embed encryption APIs within applications.
- New z/OS policy controls which make it possible to use pervasive encryption to protect user data and simplify the task of compliance for many z/OS data sets, zFS file systems, and Coupling Facility structures.
- Pervasive encryption for IBM Z is a consumable approach to enable extensive encryption of data in-flight and at-rest to substantially simplify encryption and reduce costs associated with protecting data.
- In this course you will learn how to implement Pervasive Encryption in your z/OS installation. The course explores in detail, the various technologies that are involved in z System and z/OS Cryptographic Services, ICSF, RACF and DFSMS access method Services.
- In the hands-on exercises, you begin with the setup of your hardware crypto environment (CCA crypto express and CPACF), then you will load and activate your AES master keys, setup ICSF and its Key datasets (CKDS PKDS TKDS), then define your data encryption keys, activate your data set encryption policy, and encrypt your data sets and zFS file systems.
- These exercises reinforce the concepts and technologies being covered in the lectures.
-
Clustering and Association Modeling Using IBM SPSS Modeler (v18.1.1) introduces modelers to two specific classes of modeling that are available in IBM SPSS Modeler: clustering and associations. Participants will explore various clustering techniques that are often employed in market segmentation studies. Participants will also explore how to create association models to find rules describing the relationships among a set of items, and how to create sequence models to find rules describing the relationships over time among a set of items.
-
This ZZ820G: InfoSphere MDM Architecture v11 course is designed for anyone who wants to get an understanding of the InfoSphere MDM Architecture (including the Virtual and Physical Hubs). This course walks you through the major components of the InfoSphere MDM and how each component interacts. You will learn how InfoSphere MDM responds once a service is invoked and the various configuration and extension points of a service. The course is used as an introduction to various components that make up the MDM Architecture and prepares you to identify how MDM will fit into their organization and what pieces may be customized to fit their business requirements.
The next courses that may be of interest to you include:
- Data Model and Service Mapping for the InfoSphere MDM Advanced Edition V10 (ZZ610)
- Customizing the InfoSphere MDM Advanced Edition V10 (ZZ640)
- IBM InfoSphere MDM Server Service Customization for MDM Server 9 (ZZ340)
- InfoSphere MDM Server User Interface Generator (DC560)
-
This course is designed to prepare students to install and configure a highly available cluster using PowerHA System Mirror.
