Db2 12 for z/OS Introduction to System Administration

• Starting, stopping and accessing Db2: z/OS IPL, START/STOP DB2, zParms, address spaces, IRLM and locking
• Db2 components and processes: BSDS, logging, catalog and directory
• Program preparation and execution; transaction execution
• Data sharing in the sysplex
• System security: data set protection, connection control, trusted context and roles
• Db2 authorization: dynamic vs. static SQL, access control exits, distributed security
• Program flow across all environments; TSO and batch
• Logging, Db2 utilities, recovery and system restart

• Day 1: starting/stopping Db2, internal components, system security
• Day 2: authorization, program flow, TSO/batch, distributed
• Day 3: logging, utilities, operations, recovery and restart

• 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: zParm configuration in production, migrations from v11, buffer pool tuning.
• Bridge to Db2 technical support for Power and x86 after the course.

• z/OS system programmers taking on the Db2 portion of the subsystem.
• DBAs extending responsibility to system-level (zParms, buffer pools, logging, IRLM).
• Preparation for the “system administration” portion of the IBM C1000-078 exam.

Do I need to take CV844G first?
Not a formal requirement, but Db2 objects and basic SQL knowledge are assumed. If the team lacks this knowledge, start with CV844G.

Does it cover the full C1000-078 exam?
It covers the system administration part. For the complete exam, combine it with CV844G (Basic DBA).

Group size?
Private groups of 4 to 10.

• CV844G — Db2 12 z/OS Basic DBA (natural complement for the C1000-078 exam)
• CV964G — Db2 12 z/OS SQL Performance and Tuning
• CV845G — Db2 13 z/OS Basic DBA (v13 successor)