Db2 13 for z/OS Advanced Database Administration

Course overview

This course introduces advanced database administration skills, including program preparation and the use of packages, online schema changes, partition management, and stored procedures.

This course introduces advanced database administration skills, including program preparation and the use of packages, online schema changes, partition management, and stored procedures. Performance and availability features of utilities, including LOAD, REBUILD INDEX, REORG, and UNLOAD are covered.

This course does not cover distributed data processing or data sharing.

Who should attend

Administrators familiar with Db2 who wish to augment their skill set in administering Db2 13 for z/OS database environment.

Prerequisites

Before taking this course, you should have: • Familiarity with the z/OS operating system, including TSO, ISPF, and SDSF • Familiarity with SQL DML (SELECT, INSERT, UPDATE, and MERGE, as well as DDL statements (CREATE, ALTER, DROP) • Basic skills administering a Db2 13 for z/OS database environment, including 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)