Opleidingen
55.843
resultaten
Mastering Virtual I/O Server Upgrades [TDS_AN38G]
TDS UK Virtual Training English
wo 13 jan. 2027
en 2 andere data
OVERVIEW
This instructor led course teaches students how to perform Virtual I/O Server (VIOS) upgrades.
Students will learn how to upgrade to the latest version of the VIOS, version 4.1. They will explore the various options available for upgrading a VIOS. In the hands-on labs students will use the viosupgrade utility to upgrade a VIOS.
Updated 20/9/2026
Virtueel en Klassikaal™
Virtueel en Klassikaal™ is een eenvoudig leerconcept en biedt een flexibele oplossing voor het volgen van een klassikale training. Met Virtueel en Klassikaal™ kunt u zelf beslissen of u een klassikale training virtueel (vanuit huis of kantoor )of fysiek op locatie wilt volgen. De keuze is aan u! Cursisten die virtueel deelnemen aan de training ontvangen voor aanvang van de training alle benodigde informatie om de training te kunnen volgen.
OBJECTIVES
After this course participants should be able to:
Describe the Virtual I/O Server upgrade requirements
Describe different methods available for upgrading a VIOS to version 4.1
Discuss best practices for upgrading a VIOS
Describe the process of upgrading a VIOS using the viosupgrade tool
Perform a VIOS upgrade using media
AUDIENCE
This course is designed for system administrators responsible for managing and maintaining Virtual I/O Server (VIOS) environments, IT professionals who need to upgrade VIOS to version 4.1 or learn about VIOS upgrade processes, technical staff involved in IBM Power server virtualization who want hands-on experience with the viosupgrade utility, and individuals with basic knowledge of VIOS or virtualization concepts who seek to deepen their understanding of VIOS upgrade procedures.
CERTIFICATION
None
NEXT STEP
None
CONTENT
Unit 1: Virtual I/O server upgrades (1 hour and 20 minutes)
Exercise 1: Accessing the lab environment (35 minutes)
Unit 2: VIOS upgrade methods (2 hours)
Exercise 2: Preparing a VIOS for an upgrade (40 minutes)
Unit 3: The viosupgrade tool (2 hours and 10 minutes)
Exercise 3: Upgrading a VIOS with the viosupgrade tool (1 hour)
€850
Klassikaal
max 16
BRMS for IBM i,including Cloud Storage Solutions for i [TDS_AS28G]
TDS UK Virtual Training English
ma 15 mrt. 2027
en 1 andere data
OVERVIEW
Backup and recovery: knowing how to do it is not optional! Learn once and never forget how to use BRMS to do regular and ad-hoc backups, recovery, and offsite tape backups.
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.
Updated 20/9/2026
Virtueel en Klassikaal™
Virtueel en Klassikaal™ is een eenvoudig leerconcept en biedt een flexibele oplossing voor het volgen van een klassikale training. Met Virtueel en Klassikaal™ kunt u zelf beslissen of u een klassikale training virtueel (vanuit huis of kantoor )of fysiek op locatie wilt volgen. De keuze is aan u! Cursisten die virtueel deelnemen aan de training ontvangen voor aanvang van de training alle benodigde informatie om de training te kunnen volgen.
OBJECTIVES
On completion, participants will be able to :
Describe the major features and functions of BRMS
List the steps to install BRMS on a single system or in a BRMS Network environment
Implement a previously defined backup and recovery strategy using BRMS
Implement a previously defined archival and retrieval plan, including dynamic retrieval, using BRMS
Explain how to utilize a tape drive, tape library system, virtual tape, and optical drive with BRMS
Implement and use BRMS using the green screen, System i Navigator, and IBM Navigator for i
AUDIENCE
This is an intermediate course for Power System with IBM i administrators, IBM Business Partners, and anyone else who would like practical knowledge of the features and functions supported by BRMS.
CERTIFICATION
None
NEXT STEP
None
CONTENT
Day 1
Welcome and eLab Overview
Unit 1: Installing BRMS
Unit 2: BRMS Policies Overview
Exercise 1: Using 5250 Emulation
Exercise 2: Using System i Navigator
Exercise 3: Using IBM Navigator for i
Unit 3: Media Devices and Encryption Using Software and Hardware
Unit 4: Overview and Implementation of Virtual Tape, DVD, and Optical Device Support
Exercise 4: Media Devices and Virtual Tape
Unit 5: Creating a Simple Backup Control Group
Day 2
Review
Unit 6: BRMS Log
Exercise 5: Creating a Basic Backup Control Group Using 5250 Green Screen
Exercise 6: Creating a Basic Backup Control Group Using System i Navigator
Exercise 7: Creating a Basic Backup Control Group Using IBM Navigator for i
Unit 7: Saving IFS Data
Unit 8: Working with Backup Lists
Exercise 8: Creating and Using Backup Lists and Saving to a Save File
Exercise 9: Creating and Using Backup Lists and Saving to a Save File Using System i Navigator
Exercise 10: Creating and Using Backup Lists and Saving to a Save File Using IBM Navigator for i
Unit 9: Parallel Save, User Exits, and Save-While-Active
Unit 10: Performing a Backup and Full System Backup
Unit 11: Other Backup Topics
Exercise 11: Creating a Backup Control Group
Exercise 12: Creating a Backup Control Group Using System i Navigator
Exercise 13: Creating a Backup Control Group Using IBM Navigator for i
Day 3
Unit 12: Storage Locations
Exercise 14: Creating a Storage Location
Unit 13: Containers
Unit 14: Move Management
Exercise 15: Move Policies
Unit 15: Media Class
Exercise 16: Creating a Media Class
Unit 16: Media Policies
Exercise 17: Creating a Media Policy
Unit 17: Media Topics
Exercise 18: Running a Backup Using 5250 Emulation
Exercise 19: Running a Backup Using System i Navigator
Day 4
Exercise 20: Running a Backup Using IBM Navigator for i
Review Exercises 18 Through 20
Unit 18: BRMS Networking
Unit 19: Scheduling BRMS Jobs
Unit 20: Daily Maintenance
Unit 21: BRMS Reports
Unit 22: Recovery
Exercise 21: BRMS Recovery Capabilities
Unit 23: Tape Duplication and Label Print
Exercise 22: Tape Duplication
Unit 24: Functional Usage
Day 5
Unit 25: Archive
Unit 26: Retrieval
Exercise 23: Archive/Retrieve Using 5250 Emulation
Unit 27: TSM Client and BRMS on IBM i
Unit 28: BRMS Enterprise
Unit 29: Summary
€4.250
Klassikaal
max 16
Using Open Source tools on IBM i [TDS_AS40G]
TDS UK Virtual Training English
ma 30 nov. 2026
en 3 andere data
OVERVIEW
This course is designed to teach the installation and administration of open source packages on IBM i as well as teach how to use some of the open source packages that can be downloaded.
Class activities include showing how to download and manage open source packages using Access Client Solutions, and how to use python, node.js, and PHP to access data in different ways on the IBM i.
Updated July 2026
Virtueel en Klassikaal™
Virtueel en Klassikaal™ is een eenvoudig leerconcept en biedt een flexibele oplossing voor het volgen van een klassikale training. Met Virtueel en Klassikaal™ kunt u zelf beslissen of u een klassikale training virtueel (vanuit huis of kantoor )of fysiek op locatie wilt volgen. De keuze is aan u! Cursisten die virtueel deelnemen aan de training ontvangen voor aanvang van de training alle benodigde informatie om de training te kunnen volgen.
OBJECTIVES
After this course participants should be able to:
Understand how to install and manage open source packages on IBM i
Learn what open source packages are available on IBM i
Comprehend how to use open source languages to interface with procedural programs and procedures on IBM i
Comprehend how to use open source languages and SQL to access data on the IBM i
AUDIENCE
- IBM i System Administrators
- IBM i Programmers
- API/Cloud enablers
CERTIFICATION
None
NEXT STEP
No recommendation
CONTENT
Unit 1: Introduction to open source packages on IBM i
Exercise 1: Discover the environment
Unit 2: IBM I and the PASE environment
Exercise 2: Working in the PASE environment
Unit 3: Install and manage open source packages
Exercise 3: Using the open source package manager
Unit 4: XMLservice and iToolkit
Exercise 4: Access programs and procedures using python, node.js or PHP
Unit 5: Using SQL to access IBM i
Exercise 5: Access data using python, node.js or PHP
Unit 6: Message queues
Exercise 6: Using data queues with python, node.js or PHP
Unit 7: REST on IBM i
Exercise 7: Using REST with python, node.js or PHP
Unit 8: Apache Camel on IBM i
Exercise 8: Using Apache Camel
€2.550
Klassikaal
max 16
Effective RACF Administration [TDS_BE87G]
TDS UK Virtual Training English
ma 9 nov. 2026
en 2 andere data
OVERVIEW
This course prepares you to be a more effective security administrator as you gain experience and confidence in using the RACF component of the z/OS Security Server.
To reinforce lectures, the course offers hands-on exercises where you use the RACF component of the z/OS Security Server to define users, set up group structures, define general resources, protect z/OS data sets, and use several RACF utilities.
Virtueel en Klassikaal™
Virtueel en Klassikaal™ is een eenvoudig leerconcept en biedt een flexibele oplossing voor het volgen van een klassikale training. Met Virtueel en Klassikaal™ kunt u zelf beslissen of u een klassikale training virtueel (vanuit huis of kantoor )of fysiek op locatie wilt volgen. De keuze is aan u! Cursisten die virtueel deelnemen aan de training ontvangen voor aanvang van de training alle benodigde informatie om de training te kunnen volgen.
OBJECTIVES
After this course participants should be able to:
Identify the security requirements of a system
Evaluate the facilities and options of RACF
Define users to RACF
Set up a RACF group structure
Use RACF to protect resources
Select options to tailor RACF
Evaluate and implement RACF database and performance options
Identify tools available for auditing
Administer the system so that it is consistent with the installation's security goals
AUDIENCE
This intermediate course is for people who are new to the RACF component of the z/OS Security Server, and responsible for security administration. This includes people who are planning to implement RACF for the first time, and people who are security administrators in installations where RACF is already implemented. Those inexperienced z/OS users might find the course Basics of z/OS RACF Administration (ES19) more appropriate.
Anyone planning to implement the advanced features of RACF should consider attending Implementing RACF Security for CICS (ES84), and Exploiting the Advanced Features of RACF (ES88).
CERTIFICATION
None
NEXT STEP
None
CONTENT
Day 1
Welcome
Unit 1 - Security and RACF overview
Unit 2 - Administering groups and users
Exercise 1 - Log on to the lab system
Exercise 2 - Defining a RACF group structure
Exercise 3 - User administration
Day 2
Exercise review
Unit 2 - Administering groups and users (continued)
Exercise 4 - Delegating security administration
Unit 3 - Protecting z/OS data sets
Exercise 5 - Protecting z/OS data sets: Part 1
Day 3
Exercise 5 - Protecting z/OS data sets: Part 1 (continued)
Exercise 6 - Protecting z/OS data sets: Part 2 Exercise review
Unit 4 - Introduction to user administration and delegation and general resources
Exercise 7 - Password reset granularity
Unit 5 - RACF database, tables, and performance options
Day 4
Unit 6 - RACF utilities and exits
Unit 7 - RACF options
Unit 8 - Auditing the RACF environment
Exercise 8 - Using RACF for TSO administration (Optional)
Exercise 9 - RACF utilities (Optional)
Exercise 10 - RACF monitoring
Day 5
Exercise review
Unit 9 - Storage management and RACF
Unit 10 - Security for JES facilities
Unit 11 - Security classification
€4.250
Klassikaal
max 16
IBM Db2 12.1: Advanced Data Management and Recovery for Relational DBAs [TDS_CLA92G]
TDS UK Virtual Training English
ma 11 jan. 2027
en 1 andere data
OVERVIEW
This course provides learners with a comprehensive exploration of advanced techniques for managing and recovering data in Db2 12.1 environments.
It begins with methods for efficiently moving and loading data, enabling database administrators to migrate schemas, relocate data, and integrate with external sources while maintaining system stability.
The course covers advanced backup and recovery strategies, from incremental backups and redirected restores to dropped table recovery and logical backups. Learners will also explore Db2 features that support high availability and disaster recovery, as well as specialized tools such as split mirror technology and the Db2 Advanced Recovery Feature.
Through a series of hands-on exercises, learners will practice applying these advanced techniques in real-world scenarios. Activities include using the LOAD utility with advanced options, moving data between databases with db2move and schema copy procedures, executing redirected restores, and recovering dropped tables. Participants will also gain practical experience with database maintenance tasks such as running RUNSTATS, reorganizing tables and indexes with REORG, and applying autonomic features to automate recurring maintenance operations.
By the end of this course, learners will be able to confidently manage complex data movement, implement robust backup and recovery procedures, and use Db2’s autonomic features to sustain database performance and availability. They will be equipped with the expertise needed to reduce downtime, optimize efficiency, and safeguard critical enterprise data in advanced Db2 deployments.
Virtueel en Klassikaal™
Virtueel en Klassikaal™ is een eenvoudig leerconcept en biedt een flexibele oplossing voor het volgen van een klassikale training. Met Virtueel en Klassikaal™ kunt u zelf beslissen of u een klassikale training virtueel (vanuit huis of kantoor )of fysiek op locatie wilt volgen. De keuze is aan u! Cursisten die virtueel deelnemen aan de training ontvangen voor aanvang van de training alle benodigde informatie om de training te kunnen volgen.
OBJECTIVES
After completing this course, learners should be able to:
Summarize the role of advanced Db2 utilities in data movement, recovery, and database maintenance.
Apply advanced LOAD options and external table techniques to optimize data import and exchange.
Use tools such as db2look and db2move to export structures and move data between Db2 databases.
Execute administrative procedures, including DB2_ADMIN_COPY_SCHEMA and DB2_ADMIN_MOVE_TABLE, to streamline schema and table management.
Perform incremental backups, redirected restores, and dropped table recovery to strengthen data protection strategies.
Implement logical backups, split mirror technology, and Db2 Advanced Copy Services for high-performance recovery.
Configure and manage Db2 High Availability and Disaster Recovery (HADR) and leverage the Db2 Advanced Recovery Feature.
Apply statistics profiles and autonomic features to enhance performance tuning and reduce manual administration.
Automate recurring maintenance tasks using the Administrative Task Scheduler and autonomic management of backups, statistics collection, and reorganizations.
AUDIENCE
This course is intended for experienced database administrators, system administrators, and technical professionals who manage Db2 environments and need to expand their expertise in advanced data movement, backup, recovery, and maintenance. It is also suitable for application developers and data engineers who work closely with Db2 databases and want to strengthen their understanding of utilities, schema handling, and performance optimization.
CERTIFICATION
None
NEXT STEP
None
CONTENT
Unit 1: Data Movement and Loading
Db2 Utilities Recap
LOAD Performance and more
Using db2move
Using RESTORE
Using db2relocatedb
Using ADMIN_COPY_SCHEMA and ADMIN_MOVE_TABLE
db2look
Using External Tables
3 Hands-on Exercises
Unit 2: Backup and Recovery
Incremental Backup and Recovery
Table Space Recovery
Db2 Database Rebuild Support
Db2 RESTORE with REDIRECT
Dropped Table Recovery
Logical Backup and Restore
Split Mirrors and Db2 Advanced Copy Services
Db2 High Availability and Disaster Recovery (HADR)
Db2 PureScale
Db2 Merge Backup
Db2 High Performance Unload
Db2 Recovery Expert
3 Hands-on Exercises
Unit 3: Database Maintenance, Monitoring, and Problem Determination
Using Statistics Profiles
Autonomy Features: Configuration
Autonomy Features: Administrative Task Scheduler
Autonomic Utility Execution
Autonomic Statistics Details
1 Hands-on Exercise
€850
Klassikaal
max 16
IBM Db2 12.1: Advanced Performance and Tuning Optimization for Relational DBAs [TDS_CLA95G]
TDS UK Virtual Training English
ma 18 jan. 2027
en 1 andere data
OVERVIEW
This course provides a comprehensive exploration of Db2 12.1 performance tuning and optimization, giving relational DBAs the skills needed to manage and improve workload efficiency.
Learners begin by reviewing core optimization concepts, examining how Db2 evaluates access paths, uses statistics, and determines efficient execution strategies. They then progress into more advanced topics, including statistical views, optimization classes, query rewrite behavior, registry variables, and the integration of AI-driven optimizer enhancements.
The curriculum also covers essential physical design considerations- such as logging strategies, clustering methods, table partitioning, MDC, and MQT design- to help DBAs create structures that support scalable, high-performance query execution. In addition, learners gain hands-on experience with modern monitoring and diagnostic tools, including db2batch, db2mon, db2caem, the Db2 Data Management Console, and core troubleshooting utilities.
Throughout the course, participants reinforce their skills through practical exercises that involve analyzing access plans, applying statistical techniques, tuning queries, benchmarking SQL workloads, and diagnosing performance issues using Db2's monitoring and diagnostic capabilities.
Virtueel en Klassikaal™
Virtueel en Klassikaal™ is een eenvoudig leerconcept en biedt een flexibele oplossing voor het volgen van een klassikale training. Met Virtueel en Klassikaal™ kunt u zelf beslissen of u een klassikale training virtueel (vanuit huis of kantoor )of fysiek op locatie wilt volgen. De keuze is aan u! Cursisten die virtueel deelnemen aan de training ontvangen voor aanvang van de training alle benodigde informatie om de training te kunnen volgen.
OBJECTIVES
After this course participants should be able to:
Implement effective index design strategies that enhance performance
Interpret EXPLAIN output and access plans using tools such as db2exfmt, db2expln, and the DMC Explain tool
Create and enable statistical views to improve optimizer accuracy in query evaluation
Diagnose and validate the use of statistical views through the Explain Diagnostic facility
Apply query optimization registry variables
Use optimization profiles and embedded guidelines to influence table access methods, join strategies, and plan selection
Apply appropriate indexing strategies for ITC and RTC tables
Identify when to use volatile tables and how their optimizer behavior differs from standard base tables
Collect and analyze activity metrics and explain data using db2caem
Investigate errors and performance problems using diagnostic tools such as db2diag, FODC utilities, and db2support
AUDIENCE
This course is recommended for experienced Db2 DBAs, system administrators, and performance engineers responsible for tuning, maintaining, or troubleshooting Db2 databases.
CERTIFICATION
None
NEXT STEP
None
CONTENT
Unit 1: Optimization and Tuning Recap
Db2 Indexing for Performance Review
Db2 EXPLAIN Review
Unit 2: More about Statistics
Using Statistical Views
Unit 3: Working with the Db2 Optimizer
Optimization Classes
Adjusting Configurations to Modify Db2 Optimizer Behavior
Hinting Db2 (Optimization Profiles and Embedded Optimization Guidelines)
Statement Concentration, Reoptimization, and Access and Plan Reuse
The New Db2 AI Optimizer
Db2 Workload Management Support
Unit 4: Physical Design
Minimizing Db2 Logging
RCT, ITC, and Volatile Tables
Using Materialized Query Tables
Table Partitioning and Performance
Table Clustering
Unit 5: More about Monitoring
Using db2batch for benchmarking
Using db2mon and db2caem
Db2 Data Management Console additional topics
Db2 Troubleshooting
€1.700
Klassikaal
max 16
IBM Db2 12: Foundation for Relational DBAs [TDS_CLA96G]
TDS UK Virtual Training English
ma 9 nov. 2026
OVERVIEW
This course provides relational DBAs with essential and advanced skills to manage, secure, recover, and optimize IBM Db2 v12.1 environments. Beginning with foundational concepts, participants will learn how to install Db2, configure instances, manage storage, and create database objects using both command-line and GUI tools. The course then expands into practical techniques for data movement, backup and recovery, and high availability configurations, equipping learners to maintain data integrity and ensure business continuity.
Security and concurrency are addressed in depth, including the implementation of user access controls, role-based permissions, encryption methods, Row and Column Access Control (RCAC), Label-Based Access Control (LBAC), and Trusted Contexts for multi-tiered architectures. Participants will also explore Db2's locking mechanisms and isolation levels to troubleshoot contention issues and manage concurrent workloads effectively.
Performance tuning and optimization are emphasized through detailed instruction on the query optimizer, indexing strategies, monitoring tools, and the use of EXPLAIN utilities. Learners will leverage the Db2 AI Optimizer, Design Advisor, and Data Management Console to analyze SQL access plans and improve system responsiveness across transactional and analytical workloads.
Through hands-on lab exercises and real-world scenarios, learners will gain the proficiency to manage Db2 environments efficiently and securely, diagnose issues quickly, and ensure high availability and performance in enterprise-scale deployments.
Virtueel en Klassikaal™
Virtueel en Klassikaal™ is een eenvoudig leerconcept en biedt een flexibele oplossing voor het volgen van een klassikale training. Met Virtueel en Klassikaal™ kunt u zelf beslissen of u een klassikale training virtueel (vanuit huis of kantoor )of fysiek op locatie wilt volgen. De keuze is aan u! Cursisten die virtueel deelnemen aan de training ontvangen voor aanvang van de training alle benodigde informatie om de training te kunnen volgen.
OBJECTIVES
After this course participants should be able to:
Explain the Db2 versioning model and the role of Mod Packs, Fix Packs, and Cumulative Service Builds
Configure and manage database settings using commands such as GET DB CFG, UPDATE DB CFG, RESET DB CFG, and AUTOCONFIGURE
Use Db2 utilities such as EXPORT, IMPORT, RUNSTATS, and REORG to manage and maintain data and table performance
Configure and monitor load operations using Db2 commands (LIST UTILITIES, MON_GET_UTILITY, and LOAD_QUERY) and assess table states
Apply advanced recovery techniques such as schema-level logical backup and restore, redirected restore, and split mirror copies to support complex enterprise recovery scenarios
Perform database maintenance tasks using RUNSTATS, REORG, and REORGCHK to optimize performance
Analyze the behavior of lock modes and scopes and predict their impact on concurrency and performance
Configure and administer security responsibilities using Db2 task authorities, including SECADM, DBADM, ACCESSCTRL, and DATAACCESS
Configure and manage statistics profiles to guide and automate statistics collection procedures
Utilize the Db2 Design Advisor to obtain and implement index recommendations for performance gains
Use SQL-based table functions and administrative views to retrieve real-time and historical monitoring data
AUDIENCE
This course targets relational DBAs beginners.
CONTENT
Part 1: Essentials for Relational BAs
Introduction to Db2 v12.1
Db2 Command Line and GUI Tools
The Db2 Database Manager Instance
Creating Databases and Data Placement
Creating Database Objects
Recovery and Troubleshooting Fundamentals
Part 2: Data Management and Recovery
Data Movement and Loading Fundamentals
Backup and Recovery
Database Maintenance, Monitoring, and Problem Determination
Part 3: Security and Concurrency
Locking and Concurrency Control
Security and Access Control Fundamentals
More about Db2 Security and Access Control
Part 4: Performance Tuning and Optimization
Statistics and Query Optimization
Indexing for Performance Improvement
Using the EXPLAIN Tools for Query Optimization
Monitoring Fundamentals
€3.400
Klassikaal
max 16
Introduction to DB2 for zOS for Systems and Operations Personnel [TDS_CV021G]
TDS UK Virtual Training English
ma 9 nov. 2026
en 2 andere data
OVERVIEW
DB2 11 for z/OS beginning DBAs can develop fundamental skills or recognition through lectures and hands-on exercises of:
- DB2 Objects
- Structured Query Language
- DB2 Commands
- DB2 Utilities
- DB2 Logging
- DB2 Program Preparation
The course materials cover DB2 11 for z/OS.
Virtueel en Klassikaal™
Virtueel en Klassikaal™ is een eenvoudig leerconcept en biedt een flexibele oplossing voor het volgen van een klassikale training. Met Virtueel en Klassikaal™ kunt u zelf beslissen of u een klassikale training virtueel (vanuit huis of kantoor )of fysiek op locatie wilt volgen. De keuze is aan u! Cursisten die virtueel deelnemen aan de training ontvangen voor aanvang van de training alle benodigde informatie om de training te kunnen volgen.
OBJECTIVES
After this course participants should be able to:
Give an overview of the DB2 9 environment
Describe and utilize DB2 Objects
Describe and utilize several DB2 Utilities
Describe the DB2I (DB2 Interactive Facility) environment
Use SPUFI (SQL Processing Using File Input) to compose and execute SQL
Setup and execute DB2 Commands
Understand DB2 Logging
Describe DB2 program preparation process
Understand DB2 startup and shutdown
Understand and utilize DB2 recovery strategies
AUDIENCE
This course is for beginning DB2 for z/OS database administrators who need to acquire the basic skills required to administer a DB2 database in a z/OS environment.
CERTIFICATION
None
NEXT STEP
None
CONTENT
Course Content
z/OS Prerequisite Review
DB2 Relational Database Concepts
Structured Query Language (SQL) and SPUFI
DB2 Objects
The DB2 System
DB2 Commands and Program Preparation
DB2 Utilities
DB2 Shutdown, Startup, and Recovery
Course Summary
AGENDA
Day 1
(00:15) Welcome
(00:30) Unit 1: z/OS Prerequisite Review
(00:10) Exercise 1: Connecting to z/OS and Creating Data Sets
(00:05) Exercise 1 Review
(01:15) Unit 2: DB2 Relational Database Concepts
(01:15) Unit 3: Structured Query Language (SQL) and SPUFI
(00:45) Exercise 2: SQL and SPUFI
(00:15) Exercise 2 Review
(01:30) Unit 4: DB2 Objects (Databases and Table Spaces)
(00:45) Exercise 3: Databases and Table Spaces
(00:15) Exercise 3 Review
(01:30) Unit 4: DB2 Objects (Tables, Indexes, and Views)
Day 2
(00:45) Exercise 4: Tables, Indexes, and Views
(00:15) Exercise 4 Review
(01:00) Unit 4: DB2 Objects (Qualified Names, Implicit Object Creation, and SQL Statements)
(00:30) Exercise 5: Qualified Names, Implicit Object Creation, and SQL Statements
(00:15) Exercise 5 Review
(01:30) Unit 5: The DB2 System
(00:45) Exercise 6: The DB2 System
(00:15) Exercise 6 Review
(02:00) Unit 6: DB2 Commands and Program Preparation
Day 3
(00:45) Exercise 7: DB2 Commands
(00:15) Exercise 7 Review
(02:00) Unit 7: DB2 Utilities
(01:00) Exercise 8: DB2 Utilities
(00:15) Exercise 8 Review
(01:15) Unit 8: DB2 Shutdown, Startup, and Recovery
(00:45) Exercise 9: DB2 Recovery
(00:15) Exercise 9 Review
(00:30) Unit 9: Course Summary
€2.550
Klassikaal
max 16
New Functions and Features in Db2 for z/OS (v13) [TDS_CV321G]
TDS UK Virtual Training English
ma 23 nov. 2026
en 2 andere data
OVERVIEW
Learn about the new features and enhancements of Db2 for z/OS (v13), including the technical detail of the functional enhancements of this significant new version of Db2 for z/OS.
Virtueel en Klassikaal™
Virtueel en Klassikaal™ is een eenvoudig leerconcept en biedt een flexibele oplossing voor het volgen van een klassikale training. Met Virtueel en Klassikaal™ kunt u zelf beslissen of u een klassikale training virtueel (vanuit huis of kantoor )of fysiek op locatie wilt volgen. De keuze is aan u! Cursisten die virtueel deelnemen aan de training ontvangen voor aanvang van de training alle benodigde informatie om de training te kunnen volgen.
OBJECTIVES
Unit 1: Db2 v12 Function Levels: Selected Highlights
Unit 2: Migrating to Db2 13
Unit 3: Availability & Scalability
Unit 4: Performance
Unit 5: Application Management and SQL Changes
Unit 6: SQL Data Insights
Unit 7: Security
Unit 8: IBM Db2 Utilities
Unit 9: Instrumentation and Serviceability
AUDIENCE
This is an intermediate course for system and database administrators, application developers, and other individuals who need a technical introduction to selected new features of Db2 13 for z/OS.
CONTENT
Unit 1: Db2 v12 Function Levels: Selected Highlights
Unit 2: Migrating to Db2 13
Unit 3: Availability & Scalability
Unit 4: Performance
Unit 5: Application Management and SQL Changes
Unit 6: SQL Data Insights
Unit 7: Security
Unit 8: IBM Db2 Utilities
Unit 9: Instrumentation and Serviceability
€2.550
Klassikaal
max 16
DB2 11 for z/OS Application Programming Workshop [TDS_CV722G]
TDS UK Virtual Training English
ma 14 dec. 2026
en 2 andere data
OVERVIEW
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.
Virtueel en Klassikaal™
Virtueel en Klassikaal™ is een eenvoudig leerconcept en biedt een flexibele oplossing voor het volgen van een klassikale training. Met Virtueel en Klassikaal™ kunt u zelf beslissen of u een klassikale training virtueel (vanuit huis of kantoor )of fysiek op locatie wilt volgen. De keuze is aan u! Cursisten die virtueel deelnemen aan de training ontvangen voor aanvang van de training alle benodigde informatie om de training te kunnen volgen.
OBJECTIVES
After this course participants should be able to:
Incorporate static SQL statements in an application program
Prepare the program for execution
Validate execution results are correct
Produce code to support multiple rows being returned from the database manager using cursors
Identify considerations regarding units of work, concurrency, and restart of programs
Identify differences between static and dynamic SQL
Provide test data for applications
Discuss program and DB2 options relative to performance of static SQL
AUDIENCE
This intermediate course is for application programmers who need to write embedded SQL programs in COBOL or PL/I (on z/OS).
CERTIFICATION
None
NEXT STEP
None
CONTENT
DB2 Concepts
Program Structure I
Program Preparation
Program Structure II
Recovery and Locking Concepts
Dynamic SQL Introduction
Managing Test Data
Performance Considerations
€2.550
Klassikaal
max 16