IBM 000-8697 사용자 설명서
Data Consistency, Recovery, and Migration
4-53
Database and Table Migration
The correct method for you depends on your processing environment and
what you want to move (a database, selected tables, or selected columns from
selected tables). The table displayed in
what you want to move (a database, selected tables, or selected columns from
selected tables). The table displayed in
compares the advantages
and different characteristics of each migration method. The sections that
follow describe and compare each migration method in detail. (Refer to
follow describe and compare each migration method in detail. (Refer to
for a complete discussion of each OnLine utility. The
LOAD
and
UNLOAD
statements are documented in the
DB
-
A
ccess
U
ser’s
M
anual.)
Figure 4-9
Quick comparison of migration methods
UNLOAD/
LOAD
LOAD
UNLOAD/
dbload
dbload
dbexport/
dbimport
dbimport
tbunload/
tbload
tbload
Performance
Moderate
Moderate
Moderate
Fast
Ease of use
Input must
adhere to
format
adhere to
format
You must
build input
file
build input
file
No initial
requirements
requirements
No initial
requirements
requirements
Flexibility
built into
options
built into
options
No
Yes
Yes
Yes
Ability to
modify data
schema
modify data
schema
Modify the
ASCII file
created by
dbschema
ASCII file
created by
dbschema
Modify .sql
file
file
No ability to
modify
modify
No ability to
modify
modify
Granularity of
data
data
A portion of a
field up to a
complete
table
field up to a
complete
table
A portion of a
field up to a
complete table
field up to a
complete table
Database only
Table or
database
database
Output
destination
destination
Must have
enough disk
space for data
enough disk
space for data
Must have
enough disk
space for data
enough disk
space for data
Disk or Tape
Tape only