Db2 12 for z/OS Advanced Database Administration

Course overview

This course introduces the student to advanced database administration skills, and the performance and availability features of several utilities.

This course introduces the student to advanced database administration skills, including program preparation and the use of packages, online schema changes, partition management, and stored procedures; as well as performance and availability features of utilities (including LOAD, REBUILD INDEX, REORG, and UNLOAD). This course does not cover distributed data processing, nor does it cover data sharing.

Who should attend

This course is for administrators who need to augment their skills in administering a Db2 12 for z/OS database environment.

Prerequisites

• Familiarity with the z/OS operating system, including TSO, ISPF, and SDSF. • Familiarity with SQL DML (SELECT, INSERT, UPDATE, DELETE, and MERGE) and DDL (CREATE, ALTER, DROP) statements • Basic skills administering a Db2 12 for z/OS database environment, including the use of basic utilities, serialization, and basic database security.

Delivery formats

• • Instructor-led online (virtual classroom)
• • Instructor-led on-site at your premises
• • Self-paced online training
• • Private/closed group delivery for corporate teams

Digital badge

Delegates completing this course are eligible for an IBM digital badge, issued via Credly. View the badge

Related and follow-on courses

• 0A069G — IBM SPSS Modeler Foundations (V18.2) (Basic)
• 0A079G — Introduction to Machine Learning Models Using IBM SPSS Modeler (V18.2) (Basic)
• 0G51BG — Statistical Analysis Using IBM SPSS Statistics (V26) (Intermediate)
• 0G53BG — IBM SPSS Statistics Essentials (V26) (Basic)