IBM Frozen Dessert Maker VERSION 9 Manual De Usuario

Descargar
Página de 109
Chapter
 
5.
 
Basic
 
administration
 
Now
 
that
 
you
 
have
 
installed
 
your
 
DB2
 
product
 
and
 
verified
 
its
 
successful
 
installation,
 
you
 
are
 
ready
 
to
 
create
 
your
 
own
 
database.
 
The
 
following
 
sections
 
will
 
guide
 
you
 
through
 
the
 
steps
 
of
 
creating
 
a
 
new
 
database
 
that
 
will
 
take
 
advantage
 
of
 
DB2
 
automatic
 
maintenance
 
features.
 
Creating
 
your
 
own
 
database
 
Database
 
basics
 
 
A
 
relational
 
database
 
presents
 
data
 
as
 
a
 
collection
 
of
 
tables.
 
A
 
table
 
consists
 
of
 
a
 
defined
 
set
 
of
 
columns
 
and
 
any
 
number
 
of
 
rows.
 
The
 
data
 
in
 
each
 
table
 
is
 
logically
 
related,
 
and
 
relationships
 
can
 
be
 
defined
 
between
 
tables.
 
Data
 
can
 
be
 
viewed
 
and
 
manipulated
 
based
 
on
 
mathematical
 
principles
 
and
 
operations
 
called
 
relations
 
(such
 
as,
 
INSERT,
 
SELECT,
 
and
 
UPDATE).
 
A
 
database
 
is
 
self-describing
 
in
 
that
 
it
 
contains,
 
in
 
addition
 
to
 
data,
 
a
 
description
 
of
 
its
 
own
 
structure.
 
It
 
includes
 
a
 
set
 
of
 
system
 
catalog
 
tables,
 
which
 
describe
 
the
 
logical
 
and
 
physical
 
structure
 
of
 
the
 
data;
 
a
 
configuration
 
file,
 
which
 
contains
 
the
 
parameter
 
values
 
associated
 
with
 
the
 
database;
 
and
 
a
 
recovery
 
log,
 
which
 
records
 
ongoing
 
transactions
 
and
 
transactions
 
that
 
can
 
be
 
archived.
 
Databases
 
can
 
be
 
local
 
or
 
remote.
 
A
 
local
 
database
 
is
 
physically
 
located
 
on
 
the
 
workstation
 
in
 
use,
 
while
 
a
 
database
 
on
 
another
 
machine
 
is
 
considered
 
remote.
 
You
 
can:
 
v
   
Create
 
a
 
database
 
using
 
the
 
Control
 
Center
 
v
   
Add
 
a
 
database
 
using
 
the
 
Control
 
Center
 
or
 
Configuration
 
Assistant
 
v
   
Drop
 
a
 
database
 
from
 
the
 
Control
 
Center
 
v
   
Backup
 
a
 
database
 
using
 
the
 
Control
 
Center
 
v
   
Restore
 
a
 
database
 
using
 
the
 
Control
 
Center
 
v
   
Configure
 
a
 
database
 
using
 
the
 
Control
 
Center
 
v
   
Connect
 
to
 
a
 
database
 
using
 
the
 
Control
 
Center
 
v
   
Resolve
 
database
 
health
 
alerts
 
with
 
the
 
Health
 
Center
 
Related
 
concepts:
  
v
   
v
   
v
   
 
Related
 
tasks:
  
v
   
Creating
 
your
 
own
 
database
 
using
 
the
 
Create
 
Database
 
with
 
the
 
Automatic
 
Maintenance
 
wizard
 
 
The
 
Create
 
Database
 
with
 
Automatic
 
Maintenance
 
wizard
 
is
 
the
 
quickest
 
way
 
to
 
set
 
up
 
your
 
own
 
database.
 
Based
 
on
 
basic
 
information
 
that
 
you
 
provide,
 
the
 
wizard:
 
 
©
 
Copyright
 
IBM
 
Corp.
 
1993,
 
2006
 
31