Ingeniero en informatica

DB2 9 DBA certification exam 731 prep, Part 1:
Server management
Skill Level: Introductory
Dwaine Snow (dsnow@us.ibm.com)
Senior DB2 Product Manager
IBM Toronto Lab

27 Jun 2006
Learn skills that help you to properly manage your DB2® database servers. This is the
first in a series of seven tutorials to help you prepare for the DB2 9 for Linux®, UNIX®,
and Windows™ DatabaseAdministration (Exam 731).

Section 1. Before you start
About this series
If you are preparing to take the DB2 DBA certification exam 731, you've come to the
right place -- a study hall, of sorts. This series of seven 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.

About this tutorial
Thistutorial introduces skills you must have to properly manage a DB2 server. This
is the first tutorial in a series of seven tutorials to help you prepare for the DB2 9 for
Linux, UNIX, and Windows Database Administration Certification (Exam 731). The
material in this tutorial primarily covers the objectives in Section 1 of the exam,
Server Management. You can view these objectives at:http://www-03.ibm.com/certify/tests/obj731.shtml.

Server management
© Copyright IBM Corporation 1994, 2007. All rights reserved.

Page 1 of 52

developerWorks®

ibm.com/developerWorks

Topics covered in this tutorial include:
• What data consistency is
• What transactions are and how they are initiated and terminated
• How transactions are isolated from each other in a multi-user environment
•How DB2 9 provides concurrency control through the use of locks
• What types of locks are available and how locks are acquired
• What factors influence locking
You should also review the Resources at the end of this tutorial for more information
about DB2 server management.

Objectives
After completing this tutorial, you should be able to:
• Understand the basic skills of managing DB2servers, including how to
create, drop, start, stop, list, migrate, and update instances.
• Use three methods of configuring DB2 client and server connectivity.
• Manage a DB2 server's access and security.
• Use the Task Center to create tasks that are coded in DB2 commands,
OS commands, or MVS shell commands.
• Troubleshoot errors encountered in DB2.

Prerequisites
To understand some of thematerial presented in this tutorial, you should be familiar
with the following terms:
• Object: Anything in a database that can be created or manipulated with
SQL (for example, tables, views, indexes, packages).
• Table: A logical structure that is used to present data as a collection of
unordered rows with a fixed number of columns. Each column contains a
set of values, each value of thesame data type (or a subtype of the
column's data type); the definitions of the columns make up the table
structure, and the rows contain the actual table data.
Server management
Page 2 of 52

© Copyright IBM Corporation 1994, 2007. All rights reserved.

ibm.com/developerWorks

developerWorks®

• Record: The storage representation of a row in a table.
• Field: The storagerepresentation of a column in a table.
• Value: A specific data item that can be found at each intersection of a row
and column in a database table.
• Structured Query Language (SQL): A standardized language used to
define objects and manipulate data in a relational database. (For more on
SQL, see the fourth tutorial in this series.
• DB2 optimizer: A component of the SQL precompiler that chooses anaccess plan for a Data Manipulation Language (DML) SQL statement by
modeling the execution cost of several alternative access plans and
choosing the one with the minimal estimated cost.
To take the DB2 9 DBA exam, you must have already passed the DB2 9
Fundamentals exam 730. If it's available, we recommend that you take the DB2
Fundamentals tutorial series before starting this series....