A hands-on programme for database administrators who manage IBM Db2 for z/OS. It covers Db2 architecture, object design, utilities, backup and recovery, BIND and access-path analysis, performance tuning, locking and security. Learners practise real DBA tasks in a lab, such as building objects, running utilities, recovering data and tuning slow SQL, to the standard expected in banking, insurance and enterprise operations.
📄 Download full curriculum (PDF)Full curriculum — unlocks when you enrol
Explain Db2 for z/OS architecture: subsystem address spaces, catalog, directory, logs
Design and create databases, table spaces, tables, indexes and views
Run core utilities: LOAD, REORG, RUNSTATS, COPY, RECOVER
Plan and execute backup and recovery strategies
BIND and REBIND packages; use EXPLAIN to analyse and improve access paths
Tune performance and diagnose locking and contention issues
Manage authorisations and security with GRANT and REVOKE
Use Db2 commands and monitor the subsystem
Like what you see? Enquire now and we'll walk you through the full program.
- Working knowledge of SQL and relational database concepts
- Basic z/OS skills: TSO/ISPF navigation and JCL
- No prior Db2 for z/OS experience required
- Suited to DBAs, application developers and support engineers moving into Db2 administration
LAB ACCESS (provided by Ez-Learn)
- Dedicated z/OS lab environment with personal user ID; access details issued at course start
- Guided hands-on exercises mapped to every module
STUDY MATERIAL (Ez-Learn LMS with Lifetime Access)
- Course slides, lab guides
- Practice exercises
- Reference notes
- Assessments for every Module
- Interview Preparation Questions
- Sample resumes (On Request)
- Mock Interviews (On Request)