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.
