Utilizing DB2 UDB Utilities

Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number

---

Overview/Description
To explain the use of DB2 UDB data movement and data maintenance utilities

Target Audience
Anyone wishing to gain knowledge of DB2 UDB; end users seeking advanced competence in DB2 UDB; candidates for IBM DB2 UDB V8.1 for Linux, Unix and Windows Database Administration certification, and those working towards IBM Certified Database Administrator

Prerequisites
A good knowledge of database concepts, database creation and procedures, daily administration tasks, and a good working knowledge of SQL

Expected Duration (hours)
2.2

Lesson Objectives

Utilizing DB2 UDB Utilities

export data from a database in a given scenario.

import data into a database.

select the correct method to move data.

export and import data using external files.

locate and remove fragmentation from a database and check pages for consistency.

use maintenance utilities to analyze and improve performance within a database.

use DB2 UDB maintenance utilities.

Course Number:
217412_eng