If you know DB2 9 and can perform intermediate to advanced level administrative tasks, you may benefit from becoming an IBM Certified Database Administrator. This series of seven tutorials is designed to help you prepare for the DB2® 9 for Linux®, UNIX® and Windows™ Database Administration (Exam 731) certification exam to attain the certification "IBM Certified Database Administrator - DB2 9 for Linux, UNIX and Windows." These tutorials provide a solid base for each section of the exam. However, you should not rely on these tutorials as your only preparation for the exam.
In this series
If you don't already have a background in DB2 database administration, but are interested in learning more, begin with the DB2 Fundamentals exam 730 prep tutorials.
After a quick registration, you can begin a tutorial. Each tutorial should take about an hour to complete. You can take the tutorials online, or download a PDF or zip file.
- DB2 9 DBA exam 731 prep, Part 1: Server
Learn skills that help you to properly manage your DB2 database servers. This tutorial provides information about data consistency, transactions and how they are initiated and terminated, and the use of locks.
- DB2 9 DBA exam 731 prep, Part 2: Data
Learn how to create DB2 databases, and about the mechanisms available for storing your tables, indexes, and data within the database. This tutorial focuses on partitioning, compression, and XML, which are all important performance and application development concepts that you need to know to store and access data quickly and efficiently.
- DB2 9 DBA exam 731 prep, Part 3: Database
Take the various steps required to manage some of the objects within DB2. This tutorial includes overview information for topics such as indexes, constraints, referential integrity, and views.
- DB2 9 DBA exam 731 prep, Part 4: Monitoring DB2
Become familiar with the different options a DBA has for tuning and configuring their DB2 environments. This tutorial shows you how to use the tools, functions, and applications available in DB2 9 that make this task much simpler.
- DB2 9 DBA exam 731 prep, Part 5: DB2
Find out what utilities are provided with DB2 servers for data movement and maintenance. This tutorial shows you how to extract data, populate tables, use the db2move, db2look and other commands, use the DB2 Control Center and much more.
- DB2 9 DBA exam 731 prep, Part 6: High availability:
Backup and recovery
Learn how to protect your data using database backup and recovery. This tutorial explains the different methods of database recovery and logging, and how to use the backup, restore, and rollforward commands.
- DB2 9 DBA exam 731 prep, Part 7: High availability:
Split mirroring and HADR
Learn how to use a split mirror to provide high availability and how to setup a high availability disaster recovery (HADR) system.