db2 formacion oficial sixe ibm

Db2 for z/OS: introduction for systems and operations (CV021G)

3.075,00€

Three days to handle a Db2 on the mainframe without having administered one before: which objects exist and how they are created, running SQL through SPUFI, the system commands, the utilities you run daily, and what to do when you have to stop, start or recover.

SKU: 160. Category:

Description

IBM course code:CV021G
Delivery:Online, classroom or onsite
Duration:3 days (24 hours)
Platform:Db2 for z/OS
Who it is for:Systems and operations staff starting to administer Db2 on z/OS who already work comfortably with TSO, ISPF and JCL.
Recommended background:Practical z/OS skills: TSO/E, ISPF, data sets and JCL. Without them, the entry point is CV041G.

Who this course fits

  • Mainframe operators taking over responsibility for Db2.
  • DBAs from another engine landing on z/OS who need the map of objects and utilities.
  • Systems teams about to provide first-line support on Db2.

Course content

  • z/OS prerequisite review
  • Db2 relational database concepts
  • SQL and SPUFI, with its own exercise
  • Db2 objects: databases and table spaces
  • Db2 objects: tables, indexes and views
  • Qualified names, implicit object creation and SQL statements
  • The Db2 system: how it is put together
  • Db2 commands and program preparation
  • Db2 utilities
  • Shutdown, startup and recovery

Course agenda

  • Day 1: z/OS prerequisites, relational concepts, SQL through SPUFI and the first objects
  • Day 2: tables, indexes and views, qualified names, the Db2 system and the commands
  • Day 3: program preparation, utilities, and shutdown, startup and recovery

Training with SIXE, IBM Business Partner

  • Labs on a real z/OS and on the Db2 release you have installed, whether that is 12 or 13.
  • Taught directly by IBM Champion instructors from the SIXE team.
  • Credly badges available: credly.com/organizations/sixe/badges
  • Flexible format — online, classroom or onsite — in closed groups, priced per attendee, in the language of your choice (ES / EN / FR).

Instructors specialised in IBM Db2 for z/OS

Engineers from the SIXE team who administer Db2 for z/OS in production. Several recognised as IBM Champion.

Frequently asked questions

Which release is it taught on?
Yours. The official outline is built on Db2 12, and Db2 12 for z/OS left standard support on 31 December 2025: if you are already on 13, we teach it on 13. Tell us when booking.

How does it differ from CV041G?
CV041G adds two days of z/OS groundwork — TSO/E, ISPF, data sets, JCL and SDSF — before getting into Db2. If your team already moves around the mainframe, this three-day course is the one.

Do you practise on a real machine?
Yes. The exercises connect to a z/OS, from creating the data sets to running a recovery.

Related courses

Related products