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.