Before you start
If you are preparing to take the DB2 DBA certification exam 611, you've come to the right place — a study hall of sorts. This series of DB2 certification preparation tutorials covers the major concepts you'll need to know for the test. Do your homework here and ease the stress on test day.
This tutorial introduces skills you must have to properly manage a DB2 server. This is Part 5 in a series of eight to help you prepare for the DB2 10.1 for Linux, UNIX, and Windows Database Administration Certification (exam 611).
This tutorial is based on "DB2 9 DBA exam 731 prep, Part 5: DB2 Utilities" with updates specific to DB2 10.1 and additional topics and examples.
In this tutorial, you will learn:
- How to extract data using the
- How to populate tables with the
- How to use the
- When and how to use the
- How to use
ADMIN_COPY_SCHEMAin data movement.
- How to use the
RUNSTATS, REORG, REORGCHK, and
REBINDutilities, and the
FLUSH PACKAGE CACHEstatement.
- When and how to use the DB2 Design Advisor.
To take the DB2 10.1 DBA exam, you must have already passed DB2 10.1 Fundamentals, exam 610 or DB2 9 Fundamentals, exam 730. We recommend you take the DB2 Fundamentals tutorial series before starting this series. This tutorial is one tool to help you prepare for exam 611. You should also review the resources at the end of this tutorial for more information about DB2 utilities (see Resources). Although not all materials discussed in the Fundamentals tutorial series are required to understand the concepts described here, you should at least have a basic knowledge of:
- DB2 products
- DB2 tools
- DB2 instances
- Database objects
You do not need DB2 to complete this tutorial. However, you will get more out of it if you download the free trial version of IBM DB2 10.1 to work along with this tutorial.