db2move 备份还原
db2move dbname EXPORT
db2move dbname EXPORT -u userName -p password
db2move dbname EXPORT -aw
db2move dbname export -tn tablename -u userName -p password
db2move dbname export -sn schemaName -tn tableName -u userName -p password -aw
db2move dbname import -u userName -p psw
db2move dbname load
drop table t;
create table t(id int not null,
name varchar(20),
constraint pk_t primary key(id));
insert into t(id,name) values(1,'hury');
insert into t(id,name) values(2,'lj');
insert into t(id,name) values(3,'song');
update t set name = 'hury1' where id = 1;
select * from t;
db2move db_test export -aw -tn t
-io <value> IMPORT specific actions. IMPORT One of: INSERT,
Default is REPLACE_CREATE INSERT_UPDATE, REPLACE,
(see docs for limitations CREATE, REPLACE_CREATE
of Import create function)
db2move db_test import
db2move db_test import -io insert
db2move db_test import -io replace
db2move db_test import -io create
db2move db_test import -io INSERT_UPDATE
db2move db_test import -io REPLACE_CREATE
-lo <value> LOAD specific options. LOAD One of: INSERT,
Default is INSERT REPLACE
db2move db_test load
db2move db_test load -lo insert
db2move db_test load -lo replace