IBM Websphere

Unix AIX Server

IBM DB2 Universal Database 8.1 Database Administration Training Certification Course

The IBM DB2 Database Administration training course for 8 will teach you how to monitor a DB2 UDB and how to use the data movement and data maintenance utilities. Learn about how to use the DB2 UDB disaster recovery utilities and access management. Become proficient in managing and administrating the database server. This course is also preparation for the IBM Certified System Administrator certification exam.

Target Audience

Anyone wishing to gain knowledge; end users seeking advanced competence; 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

Training Includes

• Interactive full multimedia lessons
• Review questions to test one skills
• Interactive lab exercise
• 24 x 7 online mentoring to instructor to answer all your questions.
• Proven Sucess
• Online or CD-ROM formats
• Training Time 13 hours
• Demo

Course Content

Monitoring a DB2 UDB database

• Monitor DB2 UDB states using the snapshot monitoring utility.
• Manage event monitors and view collected event monitor data.
• Capture and return System Monitor information.
• Distinguish between the methods for collecting and viewing Explain data.
• Use Visual Explain to read SQL statements.
• Use Visual Explain.
• Use Memory Visualizer and the Health Center to monitor a database.
• Recognize when you should use the Governor and the Query Patroller.
• Monitor a database.

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 maintenance utilities.

Managing Disaster Recovery in a DB2 UDB Database

• Demonstrate an awareness of the available backup and recovery strategies in DB2 UDB.
• Back up databases and tablespaces.
• Use utilities to recover a database.
• Roll the database forward and recognize the role of index rebuilding.
• Use the utilities to back up and restore a database.

Managing Database Access in DB2 UDB

• Create tasks with success or failure conditions and notifications.
• Create a task for a given scenario using the Task Center.
• Determine the most appropriate index key in a given scenario.
• Create indexes in a DB2 UDB database.
• Design and create an index.
• Create constraints to enforce business rules and ensure data integrity.
• Create referential constraints for given scenarios.
• Add constraints to tables.

Managing a DB2 UDB Server

• Recognize the instance management command to use in given scenarios.
• Configure the DB2 system environment.
• Manage instances and the DB2 system environment.
• Use the DB2 utilities to configure the client/server environment.
• Grant and revoke authorities and privileges.
• Manage client connectivity.
• Use commands to manage connections to a DB2 UDB.
• Schedule and monitor tasks.
• Manage database connections and tasks.

Administering Data Placement in DB2 UDB

• Create databases using the CREATE DATABASE command and the Create Database Wizard.
• Demonstrate an awareness of the database creation process.
• Create a database and explain aspects of the database creation process.
• Distinguish between SMS and DMS tablespaces and the data they hold.
• Create and modify tablespaces and obtain information about a database.
• Manage tablespaces.
• Create and modify buffer pools in a DB2 database.
• Create DB2 UDB tables.
• Generate the SQL to create a new buffer pool and a new table.

This Study guide and/or material is not sponsored by, endorsed by or affiliated with Cisco Systems, Inc. Cisco®, Cisco Systems®, CCDA™, CCNA ™, CCDP™, CCNP ™, CCIE™, CCSI™, the Cisco Systems logo and the CCIE logo are trademarks or registered trademarks of Cisco Systems, Inc. 

sales@cdicomp.com
webmaster@netwind.com
Copyright © CDi Communications Inc. 1996-2003