Profile

e-Catalog

Contact

Search

Cart

IBM DB2 Universal Database 5.0: Utilities and Recovery

Course Status:	Released	Courseware Features
Course Language:	English
Course Duration:	4 Hours
Deployment Options:	Online, Interactive CDs, Network, Downloads, Intranet

Audience

Database administrators responsible for implementing a backup and restore strategy for DB2

Prerequisites

A basic understanding of DB2 and DB2 fundamentals

Course Aim

To enable the DB2 administrator to maintain and protect data in a DB2 database

Learning Objectives

Populate database tables. Identify DB2 utilities and know when to use a particular one. Maintain data. Understand and implement logging. Perform backups at database and table space levels. Perform recovery at database and table space levels. Use the administration tools for scheduling and performing backup and recovery.

Topics Covered

DB2 utilities - Populating tables - The LOAD utility - The EXPORT utility - The IMPORT utility - Data maintenance utilities Backup - Overview - Use of log files - Database backup - Table space backup Recovery - Database recovery - Table space recovery - Point-in-time recovery - The recovery history file Administration tools - The Script Center - The Journal - SmartGuides - Hands-on: Using SmartGuides