Db2 for z/OS: Introduction for Technical Support and Operations Training in Spain

  • Delivery Method: Online Instructor-Led / Classroom Based / Onsite
  • Participation Model: Public Training / Private / In-House Training
  • Duration: 3 Days
  • Price: From €2,500 +TAX
  • Upcoming Date:
This course has been specifically designed to provide a thorough introduction to Db2 for z/OS, and covers all features up to and including V 12.<br>Taught from a Technical Support/Computer Operations perspective, this course introduces, describes and explains the fundamental principles of Db2 for z/OS. The course also explains the relational theory and concepts, and shows how Db2 adheres to them. The concepts of Db2 data storage, the Db2 system and its operation, Structured Query Language, the use of Db2 Interactive (Db2i), and the management of Db2 data using standard utility tasks are also introduced and explained. The course comprises formal classroom tuition along with a series of demonstrations and practical, hands-on exercises that reinforce the students' understanding at every stage.<br><br>This course is also available for one-company, on-site presentations and for live presentation over the Internet, via the Virtual Classroom Environment service.
For corporate groups, we can organize this training as an on-site private group.
HAVELSAN
ASELSAN
PepsiCo Türkiye
JTI TÜTÜN ÜRÜNLERİ SANAYİ A.Ş.
ING Bank
DHL
MASTERCARD
Huawei
TotalEnergies
Mercedes-Benz Türk A.Ş.
Goodyear
FORD OTOMOTIV SANAYI A.S.
3M COMPANY
Schneider Electric
Central Bank of Azerbaijan
BP Petrolleri
Procter & Gamble (P&G)
Qatar Foundation
Bank Of China
GlaxoSmithKline (GSK)
MORGAN STANLEY & CO Inc
Novo Nordisk
DEUTSCHE BANK
Azerbaycan Cumhuriyeti Emek ve Ahalinin Sosyal Güvenliği Bakanlığı
ACCENTURE

Prerequisites

A conceptual-level knowledge of the z/OS environment and the ability to use TSO/ISPF and JCL.

What You Will Learn

  • describe the relational concepts and theory, and the advantages of a RDBMS
  • describe the components of the Db2 system, their function, and how they are controlled
  • identify the objects used to store Db2 data and the relationships between them
  • code the SQL statements needed to create and modify Db2 data objects, and control access to them
  • code SQL statements to read and modify Db2 data and interrogate the Db2 catalog
  • describe and fully utilise all the functions available with Db2 Interactive (Db2i)
  • understand the role of logging in Db2 system and data recovery
  • use online utilities to backup and restore data, and perform other data management tasks
  • describe the use of stand-alone utilities and identify situations where they may be required.
  • describe and use various Db2 commands to control and monitor the Db2 environment and objects
  • describe the actions taken during normal start-up, operation, and shut-down of the Db2 system
  • explain the actions to take during start-up following an abnormal termination
  • describe the steps involved in program preparation and the purpose of the Db2 precompiler and bind processes.

Training Outline

DBMS Overview

What is a database?; comparison of hierarchical, network & relational database management systems; a brief history of Db2.

Relational Theory & Concepts

Relational theory; relational model; relational algebra; entity, referential and user-defined integrity.

Db2 System & Operations

Architecture overview; Working Storage Areas; Buffer, Sort, RID & EDM pools; Buffer Pools - 64 bit addressing; EDM pool; Sort pool; RID pool; Db2 Attachments; System data sets & databases.

Introduction to Db2 Interactive (Db2i)

DB2i panels; SPUFI; other functions.

Introduction to SQL

Data Definition Language; Data Manipulation Language; Data Control Language; basic SQL SELECT, INSERT, UPDATE & DELETE statements; COMMIT and ROLLBACK processing; DB2 optimizer.

Physical Database Design & Data Definition Language

Pageset structure; Tablespace types and defaults; Db2 object definition; Understanding and choosing options for performance.

Db2 Monitoring & Control

Db2 commands; Controlling the Db2 subsystem; Controlling the IRLM; Controlling the TSO Attachment; Controlling the CICS Attachment; Controlling the IMS Attachment; Issuing commands using Db2 Interactive; Controlling Distributed Data Facility; Controlling logging; Controlling buffer pools; Controlling data sharing; Controlling utilities; Controlling Resource Limit Facility; Controlling databases; Controlling threads; Controlling procedures; Controlling functions; Db2 traces; Trace classes; Controlling traces.

Db2 Logging

Db2 Logging; Db2 log processing; Unit Of Recovery; Two-phase commit protocol; Active Log parameters; Checkpoint parameters; Checkpoint records; Logging commands - SET LOG; Logging commands - DISPLAY; Logging commands - ARCHIVE.

Managing Data with Db2 Utilities - Overview

Db2 utilities; Data backup & recovery utilities; System backup & recovery utilities; Data integrity & consistency utilities; Other online utilities; Stand-alone utilities; Using online utilities; Utility control statements; DB2I utilities - main menu; Db2i utilities - Data Set Names panel; Db2i utilities - Control Statement Data Set Names panel; Controlling utilities; Using LISTDEF & TEMPLATE; Using pattern matching; LISTDEF syntax; TEMPLATE ; Dataset sizing; Dataset naming variables; TEMPLATE syntax; OPTIONS syntax.

Db2 Shutdown, Startup & Recovery

Db2 command format; Starting Db2; Integrity - normal termination; Integrity - abnormal termination; Log Initialisation; Current Status Rebuild; Forward Log Recovery; Backward Log Recovery; Processing log records; In-doubt resolution; Deferred restart: effect on committed UORs, effect on in-flight UORs; Delaying backout of long running tasks; Effect of delaying backout; Conditional restart: Control Record, log Truncation / limit restart, bypass backout / cold start; Conditional restart implications; Maintaining data integrity with conditional restart; Stopping DB2; BACKUP SYSTEM utility; BACKUP SYSTEM control data; RESTORE SYSTEM utility; Restoring to a point in time.

Program Preparation & Execution

Precompile, bind, program preparation and execution; plans and packages; BIND PLAN; BIND PACKAGE; BIND QUERY.

Why Choose Us

Leading UK-based global training provider since 1995.

Experience Db2 for z/OS: Introduction for Technical Support and Operations in Spain through Bilginç IT Academy's live and interactive virtual classroom environment. Join a Public course as an individual delegate or arrange a dedicated Private / In-house online training program exclusively for your organization.

  • Delivery Method: Online Instructor-Led
  • Participation Model: Public / Private (In-house)
  • Live and Interactive Training: Connect with your instructor in real time and actively participate through discussions, Q&A sessions, practical exercises, and group activities.
  • Flexible Participation: Join the training from your home, office, or any location with a suitable internet connection.
  • Expert Trainer Network: Learn from experienced trainers with strong industry backgrounds and practical field expertise.
  • Over 30 Years of Training Expertise: Benefit from Bilginç IT Academy's professional training experience since 1995.
  • Worldwide Access: Join our live virtual classrooms from Spain or anywhere else in the world, or arrange a dedicated online training program for your organization.

Experience Db2 for z/OS: Introduction for Technical Support and Operations through face-to-face Classroom Based training in Spain. Training can be delivered as a Public course open to individual delegates or as a dedicated Private / In-house class for your organization.

  • Delivery Method: Classroom Based
  • Participation Model: Public / Private (In-house)
  • Face-to-Face Learning: Interact directly with your instructor and fellow delegates in an engaging classroom environment.
  • Experienced Trainers: Learn from specialists with extensive industry experience and practical real-world knowledge.
  • Professional Training Environment: Attend training in comfortable, well-equipped classrooms designed to support effective learning.
  • Practical Learning: Depending on the course, reinforce your knowledge through hands-on exercises, scenarios, case studies, and instructor-led activities.

Arrange Db2 for z/OS: Introduction for Technical Support and Operations in Spain as a dedicated Onsite training program for your organization. Bilginç IT Academy trainers can deliver the training at your office or another location of your choice, with the program planned around your team's requirements and business objectives.

  • Delivery Method: Onsite
  • Participation Model: Private (In-house)
  • Training at Your Preferred Location: Organize the training at your company's office or another location selected by your organization.
  • Tailored Course Content: Adapt the training program to your projects, team structure, existing skill levels, and specific business requirements.
  • Team-Focused Learning: Develop your team around a shared knowledge base while strengthening internal collaboration and knowledge transfer.
  • Flexible Scheduling: Plan the training dates, location, and program according to your organization's operational requirements.
  • Worldwide Onsite Delivery: Arrange the training in Spain or at another preferred location worldwide. Bilginç IT Academy trainers can travel to your selected location to deliver the dedicated training program.
Contact us for more detail about our trainings and for all other enquiries!

Db2 for z/OS: Introduction for Technical Support and Operations Training Course in Spain Schedule

Join our public courses in our Spain facilities. Private class trainings will be organized at the location of your preference, according to your schedule.

For corporate groups, we can organize this training as an on-site private group.
18 octubre 2026 (3 Days)
Madrid, Barcelona, Valencia, Seville
€2,500 +TAX
19 octubre 2026 (3 Days)
Madrid, Barcelona, Valencia, Seville
€2,500 +TAX
20 octubre 2026 (3 Days)
Madrid, Barcelona, Valencia, Seville
€2,500 +TAX
25 octubre 2026 (3 Days)
Madrid, Barcelona, Valencia, Seville
€2,500 +TAX
31 octubre 2026 (3 Days)
Madrid, Barcelona, Valencia, Seville
€2,500 +TAX
16 noviembre 2026 (3 Days)
Madrid, Barcelona, Valencia, Seville
€2,500 +TAX
17 noviembre 2026 (3 Days)
Madrid, Barcelona, Valencia, Seville
€2,500 +TAX
23 noviembre 2026 (3 Days)
Madrid, Barcelona, Valencia, Seville
€2,500 +TAX

Spain has rapidly transformed into one of Europe's most vibrant technology ecosystems, with Madrid, Barcelona, and Valencia emerging as major global innovation hubs. The country is home to prestigious institutions like the Polytechnic University of Catalonia and IE Business School, which fuel the growth of sectors ranging from telecommunications to renewable energy tech. As a leading destination for digital nomads and multinational tech headquarters, Spain prioritizes digital literacy and high-level software engineering skills. Our training programs in Spain are designed to support this flourishing market, providing certifications in Cloud Computing, Cybersecurity, and Data Science. We help professionals across the Iberian Peninsula stay ahead of industry trends and drive the digital transformation of Spain’s increasingly diversified and high-tech economy.

© 2026 Bilginç IT Academy. All Rights Reserved.