Db2 for z/OS 13: Introduction to System Administration

Course overview

This course introduces the skills and knowledge required to administer a Db2 13 for z/OS system.

This course introduces the skills and knowledge required to administer a Db2 13 for z/OS system. Utilizing the lecture and a z/OS lab environment, learners will gain practical practice starting, stopping, and accessing Db2; examining the zParms and data sets; connecting to a Db2 subsystem via Data Studio; querying the catalog; exploring RACF; examining threads; working with DB2I; modifying Db2 active and archived logs; utilizing online utilities; monitoring and controlling Db2; recovering the catalog and directory; and using the administrative task scheduler.

Who should attend

This course is intended for z/OS system administrators, database administrators, or other technical individuals who will be managing Db2 13 for z/OS.

Prerequisites

Participants should have the following skills: • A basic understanding of the objects (such as databases, table spaces, tables, indexes, etc) used in a Db2 subsystem • Basic knowledge of SQL • At least one year as a z/OS systems programmer or equivalent knowledge OR • At least one year as a Db2 for z/OS database administrator

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

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