Standard

Posted: 09/12/07

R State Standard         £ Institutionally Developed          College: n/a

CIS 2172 - DB2 Database Administration

 

Course Description

This course will provide database administrators with the specific skills and knowledge needed to be successful with DB2 Universal Database (UDB) database administration in a UNIX, Windows, or OS/2 environment. This course is intended for database administrators. Students should have a fundamental understanding of relational database technology, including concepts of databases, tables, rows/columns, data types, etc., prior to taking this course. Limited exposure to SQL is also assumed. Learners must have an understanding of the general database administrator role and function. This course will teach students the critical skills needed for designing a new DB2 implementation and maintaining an existing database. Included in this course are instructions on data management, DB2 catalog tables, and database utilities such as LOAD and REORG, and recovery considerations. It also provides significant hands-on exercises for many of the topics. Prepares student to take IBM Certification Tests 701, 731. Topics include: implement a new DB2 database or application and maintain an existing DB2 database.

 

Competency Areas

Hours

Implement a new DB2 database or application

Class

4

Maintain an existing DB2 database

D. Lab

6

 

P. Lab/O.B.I.

0

 

Credit

7

 

Prerequisite:

CIS 214

Corequisite:

 

 

Course Guide

 

Competency

After completing this section, the student will be able to:

Hours

Class

D.Lab

P.Lab/

O.B.I.

IMPLEMENT A NEW DB2 DATABASE OR APPLICATION

25

35

 

 

Configure and manage DB2 instances

 

 

 

 

Configure client/server connectivity

 

 

 

 

Schedule DB2 jobs

 

 

 

 

Set user and group privileges

 

 

 

 

Understand DB2 authentication and authorization processes

 

 

 

 

Create a database

 

 

 

 

Create an manipulate DB2 objects

 

 

 

 

Understand schemas

 

 

 

 

 

 

 

 

MAINTAIN AN EXISTING DB2 DATABASE

15

25

 

 

Use GUI tools to create DB2 tasks

 

 

 

 

Create and manage indexes

 

 

 

 

Examine System catalog tables

 

 

 

 

Monitor DB2 activity

 

 

 

 

Obtain and modify DB2 registry variables

 

 

 

 

Implement DB2 IMPORT, EXPORT, LOAN and other DB2 utilities

 

 

 

 

Perform database level backup and restore activities

 

 

 

 

 

 

 

 

Suggested Resources

 

http://www-03.ibm.com/certify/ , IBM DB2 Administrator Redbooks and tutorials