This course will expose the beginning z/OS DBAs (Database Administrators) to fundamentals of Database Administration for a Db2 13 for z/OS. This course will teach the students how to physically implement a logical database design using DDL, and teaches considerations of referentially related tables. This course discusses the use of basic utilities, program preparation, serialization, and basic database security. This course does not cover distributed data processing, nor does it cover data sharing.

Course Objectives

  • Explain the foundational concepts of Db2 relational database design and administration on z/OS.
  • Create and manage database objects such as storage groups, databases, and table spaces.
  • Utilize Db2 utilities like Load, Check Data, Unload, Runstats, and Reorg for database maintenance.
  • Execute SQL commands for data manipulation using SPUFI and understand SQL fundamentals.
  • Manage Db2 system parameters, address spaces, and buffer pools for optimal performance.

Who should attend

  • Database Administrator

Prerequisites

Required

  • Familiarity with the z/OS operating system, including TSO, ISPF, and SDSF
  • Familiarity with SQL data manipulation statements (SELECT, INSERT, UPDATE, and DELETE) to access and change the contents of Db2 tables

Course Outline

Db2 Relational database concepts
arrow iconarrow icon

  • Relational Database design
  • Data access
  • Interacting with Db2• Catalog and directory