02 9482 8200 info@datasync.com.au

CV83: DB2 11 for z/OS Database Administration Part 1

Code: CV83
Duration: 5 days

Description

This course teaches you how to physically implement a logical database design in DB2. It includes instruction on DB2 data management, DB2 catalog tables, the bind process, database utilities such as LOAD and REORG, and security considerations.

Outcomes

  • Implement a DB2 database design
  • Use database utilities to load and reorganize data
  • Define and implement a DB2 database recovery strategy
  • Control access to database using DB2 authorisation facilities

Note: this course material is at DB2 11 for z/OS level.

Audience

  • DB2 for z/OS database administrators who need to acquire the basic skills necessary to administer a DB2 database.

Prerequisites

  • Ability to design a relational table
  • Ability to describe the SQL data manipulation statements to access and change the contents of DB2 tables
  • You should also attend DB2 Family Fundamentals (CE03) and SQL Workshop (CE12), or have equivalent experience.

Format

Classroom and extensive hands on lab exercises.

This course is also offered as web-based training. Please contact us for more information.

Course Schedule »