KT-CV830 DB2 9 for z/OS Database Administration Workshop Part 1 Training - Minneapolis, Minnesota IT MN Technical Financial New York, NY
Knowledge Transfer Microsoft Certified Silver Training Partner CPLS
Knowledge Transfer is a Microsoft Certified Silver Learning Partner
Oracle University

 

Microsoft Certified Training Partner CTEC
Search for a Course Topic:
Public Courses
Corporate Services & Training
 

 

 



 Course Search
Keyword
Course #
State

 Training Delivery
 
Training Delivery
Custom Curriculum
Course List
Certifications
 
 Main Menu
 
Home
View Courses
Site Index
 
 


DB2 9 for z/OS Database Administration Workshop Part 1


Description: 

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

Note: This course material is at the DB2 9 for z/OS level.

Audience:

  • This is an intermediate course for z/OS database administrators who need to acquire the basic skills required to administer a DB2 database.

Skills taught:

After completing this course, you should be able to:

  • Define and maintain the objects that make up a DB2 database
  • Resolve referential and check constraint violations
  • Load external sequential input data into DB2 tables
  • Gather statistics about DB2 data
  • Reorganize DB2 data
  • Unload DB2 data in external format
  • Recover a damaged table space to current
  • Compress data
  • Bind a DB2 application program
  • Control access to DB2 objects
  • Describe basic DB2 serialization concepts

 
Click here to view the Course Outline
     
Prerequisite: 

Before taking this course, you should be able to:

  • Design a relational table
  • Describe the SQL data manipulation statements to access and change the contents of DB2 tables
  • You should also take DB2 Family Fundamentals (CE03) and SQL Workshop (CE12), or have equivalent experience.
 
   
     
Duration: 
5 Days  
     
     

View Printer Friendly Page

 


To Inquire About Future Classes

Request a class date

if one is not scheduled.