DB2 的 731

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®,

homework here and ease the stress on test day.

About this tutorial

This tutorial 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.

Topics covered in this tutorial include:

• What data consistency is

• 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 DB2 servers, 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,

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 the same 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.

• Record: The storage representation of a row in a table.

• Field: The storage representation 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.

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.

Although not all materials discussed in the Fundamentals tutorial series are required

to understand the concepts described in this tutorial, you should at least have a

basic knowledge of:

• DB2 products

• DB2 tools

with this tutorial.

Section 2. DB2 instances

Creating and dropping an instance

A DB2 instance is a logical context in which DB2 commands and functions are

executed. You can think of an instance as a service or a daemon process that

manages access to database files. More than one instance can be defined on a

server machine. Each instance is independent of the others, meaning that all

instances can be managed, manipulated, and tuned separately.

To create an instance in Windows simply issue this command:

db2icrt instance_name

also know as the system controller process, db2sysc. This protects the database

manager from being accidentally or maliciously damaged by any user-defined

routines.

To drop an instance, disconnect all database connections and stop the instance by

issuing this command:

db2idrop -f instance_name

Listing, migrating, and updating a DB2 instance

To list DB2 instances that exist on a server, use the command:

db2ilist

Instance migration is required if you decide to move up to a newer version of the

the server you need to update the existing instances to link to the new fixpack files.

Use the following command to update an instance:

db2iupdt instance_name

Setting up the DB2 environment

operates and functions. The DB2 environment is made up of:

• DB2 profile registries

• Operating system environment variables

• DB2 database manager configuration parameters

• DB2 database configuration parameters

Setting profile registries

db2set registry_variable = value