如何使用DB2MOVE
Db2move DB_NAME action <options> -u USERID –p PASSWORD
Action:export,import,load
Options如下:
Option
|
Default
|
Notes
| |
-tc
|
table-creators
|
all_creators
|
EXPORT.Wildcard
|
-tn
|
table-names
|
all_user_tables
|
EXPORT.Wildcard
|
-sn
|
schema-names
|
all_schemas
|
EXPORT.Wildcard
|
-ts
|
tblspace-names
|
all_tablespace
|
EXPORT.Wildcard
|
-tf
|
tables
|
from
|
file
|
-io
|
import-option
|
REPLACE_CREATE
|
IMPORT_only.
|
-lo
|
load-option
|
INSERT
|
LOAD_only.
|
-l
|
lobpaths
|
current_dir
|
separated_by_commas.NO
|
-u
|
userid
|
logged_on_userid
| |
-p
|
password
|
logged_on_password
| |
-aw
|
allow-warnings
|
false
|
include
|
warnings
|
during
|
export.
|
例如:
Db2move ehrdb export –u ehr –p ehr
Db2move ehrdb import –u her –p ehr