DB2数据库的导入与导出
1.打开db2的命令行处理器2.建立编目（若有建立，可跳过）
db2 catalog tcpip node nodename remote IP server 50000（编目节点)
db2 catalog db dbname as mydbat node nodename（数据库实例)
3.连接数据库
db2 connect dbname user username using password
4.导出数据库
export to of ixf select [字段(例: * or col1,col2,col3)] from TABLE1;
export to of del select [字段(例: * or col1,col2,col3)] from TABLE1;
5.导入数据库
import from of ixf insert into TABLE1;
load from of ixf insert into TABLE1;
页:
[1]