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 course is designed to leverage SAN storage connectivity by integrating a layer of intelligence or virtualization, the SAN Volume Controller (SVC) to facilitate storage application data access independence from storage management functions and requirements. The focus is on planning and implementation tasks associated with integrating the SVC into the storage area network. It also explains how to:
- Centralize storage provisioning to host servers from common storage pools.
- Facilitate the coexistence and migration of data from non-virtualized to the virtualized environment.
- Improve storage utilization effectiveness using Thin Provisioning and Real-time Compression.
- Implement storage tiering and optimize solid state drives (SSDs) or flash systems usage with Easy Tier.
- Utilize network-level storage subsystem-independent data replication services to satisfy backup and disaster recovery requirements.
-
This course will teach you how to use shell scripts and utilities for practical system administration of AIX (or other UNIX) operating systems.
-
This is developed for systems programmers working on an implementation of a Parallel Sysplex. It covers the details of z/OS and z/OS-related products and subsystems exploiting the Parallel Sysplex components. It is focused on the resource sharing side.
-
This course is designed so that students can learn how z/OS systems operate in a Parallel Sysplex environment through discussion topics and hands-on lab exercises. Students learn problem determination skills, practice enhanced sysplex operations, including management of the coupling facility (CF), and use recovery capabilities provided by the System z servers.
The course consists of six units and 12 hands-on lab exercises.
-
This classroom course of two days explains how to balance the workload on the IBM i system to ensure optimum performance. Specifically, this course explains how to manage workloads, measure system performance, and tune the operating system to meet processing requirements. Hands-on exercises give you the opportunity to use the system functions that are available for controlling workload and tuning system performance. Evaluation criteria presented in this course are based on the latest information available from IBM development labs.
-
This course is designed to leverage SAN storage connectivity by integrating a layer of intelligence of virtualization, the IBM Storwize V7000 to facilitate storage application data access independence from storage management functions and requirements. The focus is on planning and implementation tasks associated with integrating the Storwize V7000 into the storage area network. It also explains how to:
Centralize storage provisioning to host servers from common storage pools using internal storage and SAN attached external heterogeneous storage.
Improve storage utilization effectiveness using Thin Provisioning and Real-Time Compression
Implement storage tiering and optimize solid state drives (SSDs) or flash systems usage with Easy Tier.
Facilitate the coexistence and migration of data from non-virtualization to the virtualized environment.
Utilize network-level storage subsystem-independent data replication services to satisfy backup and disaster recovery requirements.
This course lecture offering is at the Storwize V7000 V7.6. level.
-
This course is designed to teach you the basic skills required to write programs using the Rexx language in the standard z/OS environments: TSO, ISPF, and MVS. The course covers the TSO extensions to Rexx, the interface with ISPF, and interaction with other environments such as the MVS console, and running Rexx in batch jobs, and compiling Rexx.
-
The course includes information on the Spectrum Scale installer toolkit, installer GUI, cluster upgrade scenarios, cluster health monitoring, cluster performance data collection and monitoring, management GUI, file system encryption, cluster security, and call home features. Many of the features are described in lecture materials and implemented in lab exercises.
-
This course enables you to acquire the skills necessary to produce application programs that manipulate DB2 databases. Emphasis is on embedding Structured Query Language (SQL) statements and preparing programs for execution.
-
This course presents the structure and control blocks of the z/OS BCP and system services. It prepares the new z/OS system programmer to identify potential bottlenecks and performance problems, perform initial error symptom gathering, and identify opportunities and requirements for tailoring a z/OS system. This course also provides prerequisite information needed for further training in specialized areas such as system measurement and tuning and system problem determination.
-
This course covers the features and functions supported by Backup Recovery and Media Services (BRMS). BRMS is an integrated and comprehensive tool for managing backup, recovery, archive, and retrieval operations for a single Power system with IBM i or multiple systems with IBM i at a site or across a BRMS Network. The lectures describe how to perform the supported functions when using a 5250 emulation session, when using System i Navigator, and when using IBM Navigator for i. Students will then have the opportunity to practice in lab exercises what they have learned in lecture.
