This course shows learners how to use several DB2 tools to administer databases and rebuild them through the process of recovery. This prepares learners to perform important system administration tasks.
Objectives:
Use the task center, the journal, the tools setting notebook, and the license center
Configure logging for a DB2 database
Set up a recurring schedule for backups
Restore data in the event of a database failure
Topics:
The task center
Importing, running, and scheduling scripts
Using the journal and customizing tools settings
Creating indexes, viewing directories, and managing contacts
Managing the database log
Backing up databases
Recovering data
Technical Requirements:
P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Minimum screen resolution 800x600, Internet Explorer 6.0 or higher; Windows Media Player 9.0 or higher; Adobe Flash Player 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Cookies enabled; Sound card with speakers or headphones strongly recommended.