Db2 12 for z/OS Basic Database Administration

• Db2 relational database concepts
• SQL and SPUFI: SELECT, INSERT, UPDATE, DELETE, COMMIT, ROLLBACK and joins
• Db2 objects — storage groups, databases and table spaces
• Db2 objects — tables, indexes, views and referential integrity
• Utilities — LOAD, UNLOAD, CHECK DATA, RUNSTATS, REORG
• Db2 commands, log archiving and program preparation
• The Db2 system — zParms, address spaces, buffer pools, logging and security
• Shutdown, startup and recovery with COPY and RECOVER

• Day 1: relational concepts, SQL/SPUFI, Db2 objects (storage groups, databases, table spaces)
• Day 2: Db2 objects (tables, indexes, views), utilities and commands
• Day 3: Db2 system, shutdown/startup, recovery and labs

• Delivered directly by IBM Champion instructors from the SIXE team.
• Credly badges available on completion: credly.com/organizations/sixe/badges
• Flexible format: online, in-person or on-site.
• Private groups with per-student pricing. Delivery language of your choice (ES / EN / FR).

• Real project examples: migrations from v11, recovery incidents, post-upgrade tuning.
• Bridge to Db2 technical support for Power and x86 after the course.

• DBAs moving from Db2 11 for z/OS to Db2 12 for z/OS.
• z/OS operations staff taking on the DBA role.
• Preparation for IBM certification C1000-122 or C1000-078.

Does it prepare for IBM certification?
Yes, it covers the objectives of C1000-122 (Db2 12 DBA Fundamentals) and C1000-078 (Db2 12 Administrator).

Group size?
Private groups of 4 to 10.

On-site?
Yes, anywhere.

• CV853G — Db2 12 for z/OS Introduction to System Administration
• CV964G — Db2 12 z/OS SQL Performance and Tuning
• CV845G — Db2 13 z/OS Basic DBA (v13 successor)