層次結構表空間的類型表空間的靈活性表空間和容器類型表空間和容器之間的關系緩沖池和容器之間的關系表和視圖之間的關系表和索引之間的關系數據庫對象和配置文件間的關系My

Serverinstance

1Database

1Database

2instance

2Database

1一個物理服務器包括:一個管理服務器（

Admin

Server）一個或多個實例每個實例(數據庫管理器database

manager)是一個邏輯服務器可以擁有一個到多個數據庫admin

server(DAS)The

DB2

Server

PictureDB2

Admin

Server

(UNIX

and

Windows)A

background

process

to

support

instance

administrationdasusr1

on

UNIX

(default)DB2DAS

service

on

Windows

(default)Required

for:Network

Database

DiscoveryRemote

AdministrationTools

Catalog

-task

schedulingdb2admin

{stop

|

start}start/stopadminserverDB2

Admin

Server

(Windows)The

DAS

process

c so

be

stopped

and

started

from

the

services

panel

inWindowsDBM

CFGget

dbm

cfg [show

detail]update

dbm

cfgusing

<p>

<v>showparametersupdateparametersMany

parameters

aredynamic

(takeeffect

immedia

y).

Changes

to

otherparameters

may

require

aninstancerestart.Instance

-

Stopand

StartingIt

is

sometimes

necessary

to

stop

and

restart

an

instanceexample:

after

changing

a

non-dynamic

parameter

in

the

DBM

CFGdb2stop

[force]db2startorDB

CFG

from

Command

Lineget

db

cfg

for

<dbname>

[showdetail]update

db

cfg

for

<dbname>

using<p>

<v>showparametersupdateparametersParameters

include:location

of

database

logsdefaults

for

query

optimizationsize

ofmemory

for

lock

managementetc..Many

parameters

are

dynamic.

Others

may

require

all

applications

disconnect.Non-dynamic

changes

to

take

effect

after

all

applications

disconnect

andteapplication

re-connectsDB

CFG

from

Control

CenterDB2

RegistryA

place

to

specify

environment

or

platform

specific

settingse.g.

settings

for

RAID,

optimizer

paths

not

yet

fully

integrated,

communication

protocols,environment

specific

performance

enhancementsSettings

can

be

applied

to

various

levelsenvironmentinstanceglobal

(all

instances)db2setdb2set

-alldb2set

-lrdb2set

<r>=<value>list

allavailablevariables

forplatformlist

variables

setfor

instancelist

all

currently

setvariablesset

a

registryvariableDatabase

ObjectsTableA

collection

of

data

logically

arranged

in

columns

and

rowsViewA

representation

of

the

data

in

tablesIndexAn

ordered

set

of

keys

each

pointing

to

a

row

in

a

tableSchemaAll

DB2

UDB

objects

have

a

two

part

name

and

the

schema

is

theA

schema

is

an

identifier

that

helps

group

database

objects

together.Schemas

can

be

either

implicit

or

explicit

when

accessing

an

object.Database

Application

ObjectsSequencesTriggersUser

Defined