Book a Call 🏠 Home About Courses Services Corporate Events Contact
Home Courses MF-DB2
🖥 Mainframe 🗄️ DB2 ✔ 4 Levels Available

Mainframe DB2
Full Programme

A structured four-level curriculum covering IBM DB2 for z/OS from foundational concepts through advanced SQL, performance tuning, data sharing, high availability, and enterprise-level disaster recovery. Designed for professionals targeting MNC mainframe database administration and development careers.

⏱
Total Duration
7 Hours
🧪
Lab Hours
3.5 Hours
🎯
Format
Theory + Lab
🏆
Certificate
Arich Certified
Enrol Now →
Course Code
MF-DB2
Click a Level to View its Syllabus
L1
MF-DB2 · Beginner
7 hrs · 7 Modules · DB2 Fundamentals
›
L2
MF-DB2 · Intermediate
7 Modules · Advanced SQL & Procedures
›
L3
MF-DB2 · Advanced
7 Modules · Performance & Data Sharing
›
L4
MF-DB2 · Enterprise
7 Modules · HA, DR & DevOps
›
Read-Only · Table of Contents · MF-DB2
📄 MF-DB2 — Beginner Level
L1
MF-DB2
Mainframe DB2 — Beginner
Total Duration: 7 Hours  |  Theory: 3.5 hrs  |  Lab: 3.5 hrs
01
Introduction to Mainframes & DB2
Theory: 0.5 hrs  ·  Lab: 0.5 hrs  ·  Total: 1.0 hrs
▼
Overview of Mainframe systems
DB2 architecture
DB2 role in z/OS
02
DB2 Objects & Data Structures
Theory: 0.5 hrs  ·  Lab: 0.5 hrs  ·  Total: 1.0 hrs
▼
Tables
Tablespaces
Indexes, views, schemas
03
DB2 SQL
Theory: 0.5 hrs  ·  Lab: 0.5 hrs  ·  Total: 1.0 hrs
▼
SELECT, INSERT, UPDATE, DELETE
Basic joins
04
Advanced SQL & Functions
Theory: 0.5 hrs  ·  Lab: 0.5 hrs  ·  Total: 1.0 hrs
▼
GROUP BY, ORDER BY, aggregate functions
Subqueries
05
DB2 Utilities
Theory: 0.5 hrs  ·  Lab: 0.5 hrs  ·  Total: 1.0 hrs
▼
LOAD, UNLOAD, REORG, RUNSTATS
COPY, RECOVER utilities
DSN commands
06
DB2 Commands & Application Programming
Theory: 0.5 hrs  ·  Lab: 0.5 hrs  ·  Total: 1.0 hrs
▼
Bind/Precompile process, COBOL-DB2 program overview
07
Security, Performance, and Recap
Theory: 0.5 hrs  ·  Lab: 0.5 hrs  ·  Total: 1.0 hrs
▼
Authorization, locking, performance basics
Review and Q&A
7
Total Hours
3.5
Theory Hrs
3.5
Lab Hrs
Read-Only · Table of Contents · MF-DB2
📄 MF-DB2 — Intermediate Level
L2
MF-DB2
Mainframe DB2 — Intermediate
Total Duration: 7 Hours  |  Theory: 3.5 hrs  |  Lab: 3.5 hrs
01
DB2 Architecture Deep Dive
Theory: 0.5 hrs  ·  Lab: 0.5 hrs  ·  Total: 1.0 hrs
▼
Advanced architecture
Buffer pools, storage groups
02
Advanced SQL Techniques
Theory: 0.5 hrs  ·  Lab: 0.5 hrs  ·  Total: 1.0 hrs
▼
Common table expressions (CTEs)
Case expressions
Recursive queries
03
Stored Procedures & Triggers
Theory: 0.5 hrs  ·  Lab: 0.5 hrs  ·  Total: 1.0 hrs
▼
Creation, deployment
Control flow, using triggers in DB2
04
DB2 Program Preparation & BIND Process
Theory: 0.5 hrs  ·  Lab: 0.5 hrs  ·  Total: 1.0 hrs
▼
Handling errors in DB2 applications, SQLCODEs, warnings, exceptions
05
Error Handling & SQLCODE/SQLSTATE
Theory: 0.5 hrs  ·  Lab: 0.5 hrs  ·  Total: 1.0 hrs
▼
LOAD, UNLOAD, REORG, RUNSTATS
COPY, RECOVER utilities
06
DB2 Security, Auditing & Review
Theory: 0.5 hrs  ·  Lab: 0.5 hrs  ·  Total: 1.0 hrs
▼
Access paths, use of EXPLAIN
Tuning queries and indexes
07
Security, Performance, and Recap
Theory: 0.5 hrs  ·  Lab: 0.5 hrs  ·  Total: 1.0 hrs
▼
GRANT/REVOKE, roles
Auditing basics, review and final Q&A
7
Total Hours
3.5
Theory Hrs
3.5
Lab Hrs
Read-Only · Table of Contents · MF-DB2
📄 MF-DB2 — Advanced Level
L3
MF-DB2
Mainframe DB2 — Advanced
Total Duration: 7 Hours  |  Theory: 3.5 hrs  |  Lab: 3.5 hrs
01
DB2 Internals & Advanced Storage Concepts
Theory: 0.5 hrs  ·  Lab: 0.5 hrs  ·  Total: 1.0 hrs
▼
Advanced understanding of DB2 internals
Buffer pool tuning, storage architecture
02
Advanced Indexing Strategies
Theory: 0.5 hrs  ·  Lab: 0.5 hrs  ·  Total: 1.0 hrs
▼
Index-only access, composite indexes, INCLUDE columns, index tuning
Case expressions
Recursive queries
03
Advanced Performance Monitoring & Tuning
Theory: 0.5 hrs  ·  Lab: 0.5 hrs  ·  Total: 1.0 hrs
▼
Monitoring tools (IFCID, SMF), real-time statistics
Dynamic statement cache
04
DB2 Data Sharing & Parallel Sysplex
Theory: 0.5 hrs  ·  Lab: 0.5 hrs  ·  Total: 1.0 hrs
▼
Concepts of DB2 data sharing, coupling facility, high availability
05
Advanced Utilities & Automation
Theory: 0.5 hrs  ·  Lab: 0.5 hrs  ·  Total: 1.0 hrs
▼
REORG with inline stats, automation with JCL/procedures
Utility best practices
06
DB2 and System Programming Integration
Theory: 0.5 hrs  ·  Lab: 0.5 hrs  ·  Total: 1.0 hrs
▼
Collaboration with system programmers
Buffer pool sizing, WLM integration
07
Advanced Security, Auditing & Final Assessment
Theory: 0.5 hrs  ·  Lab: 0.5 hrs  ·  Total: 1.0 hrs
▼
Row-level security, RACF integration, auditing, compliance
Recap and case studies
7
Total Hours
3.5
Theory Hrs
3.5
Lab Hrs
Read-Only · Table of Contents · MF-DB2
📄 MF-DB2 — Enterprise Level
L4
MF-DB2
Mainframe DB2 — Enterprise
Total Duration: 7 Hours  |  Theory: 3.5 hrs  |  Lab: 3.5 hrs
01
DB2 System Architecture & Subsystem Tuning
Theory: 0.5 hrs  ·  Lab: 0.5 hrs  ·  Total: 1.0 hrs
▼
Expert-level z/OS subsystem configuration
Memory tuning
Workload balancing
02
Real-Time Statistics & AI-Based Performance Tuning
Theory: 0.5 hrs  ·  Lab: 0.5 hrs  ·  Total: 1.0 hrs
▼
Use of RTS tables
AI tools like Db2 AI for z/OS
Automated performance recommendations
03
Advanced Workload Management (WLM)
Theory: 0.5 hrs  ·  Lab: 0.5 hrs  ·  Total: 1.0 hrs
▼
Integrating DB2 with WLM
Resource control
Service class prioritization
04
DB2 and DevOps Integration
Theory: 0.5 hrs  ·  Lab: 0.5 hrs  ·  Total: 1.0 hrs
▼
Integrating DB2 in CI/CD pipelines
z/OSMF
Jenkins
APIs for automation
05
DB2 Disaster Recovery and High Availability
Theory: 0.5 hrs  ·  Lab: 0.5 hrs  ·  Total: 1.0 hrs
▼
GDPS
Data sharing for HA
Disaster recovery planning and implementation
06
Advanced Troubleshooting and Debugging
Theory: 0.5 hrs  ·  Lab: 0.5 hrs  ·  Total: 1.0 hrs
▼
Analyzing dumps
Traces
IFCIDs
Lock contention analysis
07
Capstone Project & Expert-Level Case Study
Theory: 0.5 hrs  ·  Lab: 0.5 hrs  ·  Total: 1.0 hrs
▼
Real-time project simulation: design, tune, secure
Recover an enterprise DB2 system
7
Total Hours
3.5
Theory Hrs
3.5
Lab Hrs