DB2 UDB 8.2 Administration Guide: Implementation V8.2 SC09-4820-01 - IBM官方手册 - CSDN文库

需积分: 1 171 浏览量更新于2024-07-31 收藏 3.12MB PDF 举报

身份认证购VIP最低享 7 折!

领优惠券(最高得80元）

资源详情

资源推荐

xiv

Administration

Guide:

Implementation

Chapter

1.

Before

creating

a

database

After

determining

the

design

of

your

database,

you

must

create

the

database

and

the

objects

within

it.

These

objects

include

schemas,

database

partition

groups,

table

spaces,

tables,

views,

wrappers,

servers,

nicknames,

type

mappings,

function

mappings,

aliases,

user-defined

types

(UDTs),

user-defined

functions

(UDFs),

automatic

summary

tables

(ASTs),

triggers,

constraints,

indexes,

and

packages.

You

can

create

these

objects

using

SQL

statements

in

the

command

line

processor

and

through

SQL

statements

in

applications.

For

information

on

SQL

statements,

refer

to

the

SQL

Reference

manual.

For

information

on

command

line

processor

commands,

refer

to

the

Command

Reference

manual.

For

information

on

application

programming

interfaces

(APIs),

refer

to

the

Administrative

API

Reference

manual.

Another

way

you

can

create

database

objects

is

through

the

Control

Center.

The

Control

Center

can

be

used

instead

of

the

SQL

statements,

command

line

processor

commands,

or

APIs.

In

this

chapter

the

method

for

completing

tasks

using

the

Control

Center

is

highlighted

by

placing

it

within

a

box.

This

is

followed

immediately

by

a

comparable

method

using

the

command

line,

sometimes

with

examples.

In

some

cases,

there

may

be

tasks

showing

only

one

method.

When

working

with

the

Control

Center,

recall

that

you

can

use

the

help

there

to

provide

more

detail

than

the

overview

information

found

here.

This

chapter

focuses

on

the

information

you

should

know

before

you

create

a

database

with

all

of

its

objects.

There

are

several

prerequisite

concepts

and

topics

as

well

as

several

tasks

you

must

perform

before

creating

a

database.

The

chapter

following

this

one

contains

brief

discussions

of

the

various

objects

that

may

be

part

of

the

implementation

of

your

database

design.

The

final

chapter

in

this

part

presents

topics

you

must

consider

before

you

alter

a

database

and

then

explains

how

to

alter

or

drop

database

objects.

For

those

areas

where

DB2

Universal

Database

interacts

with

the

operating

system,

some

of

the

topics

in

this

and

the

following

chapters

may

present

operating

system-specific

differences.

You

may

be

able

to

take

advantage

of

native

operating

system

capabilities

or

differences

beyond

those

offered

by

DB2

UDB.

Refer

to

your

Quick

Beginnings

manual

and

operating

system

documentation

for

precise

differences.

As

an

example,

Windows

supports

an

application

type

known

as

a

“service”.

DB2

for

Windows

will

have

each

DB2

instance

defined

as

a

service.

A

service

can

be

started

automatically

at

system

boot,

by

a

user

through

the

Services

control

panel

applet,

or

by

a

Windows

32-bit

application

that

uses

the

service

functions

included

in

the

Microsoft

Windows

32-bit

application

programming

interface

(API).

Services

can

execute

even

when

no

user

is

logged

on

to

the

system.

Unless

specifically

mentioned,

references

to

Windows

9x

will

refer

to

Windows

98,

and

Windows

ME.

References

to

Windows

NT

will

refer

to

Windows

NT,

Windows

©

Copyright

IBM

Corp.

1993

-

2004

3

|

|

剩余464页未读，继续阅读

panduan

粉丝: 4
资源: 1

最新资源

资源上传下载、课程学习等过程中有任何疑问或建议，欢迎提出宝贵意见哦~我们会及时处理！点击此处反馈