DB2 命令导入导出数据

在Linux上用命令远程连接DB2数据库：db2 connect to 数据库别名(DB2编目) user user_name using password
DB2数据库编目
DB2 命令查看数据库表结构：db2 describe table Schema.table_name
DB2 命令查看视图创建SQL：db2 "SELECT TEXT FROM syscat.views WHERE viewschema='Schema_name' AND viewname='view_name' "
DB2 export 导出数据：

 export to [path(eg: /tmp/XX.ixf)] of ixf select [*/col_name] from Schema.table_name 
 export to [path(eg: /tmp/XX.del)] of del select [*/col_name] from Schema.table_name 
 export to /tmp/XX.txt of del select id, name from Schema.table_name

DB2 命令导出数据：db2 export to /tmp/XX.del of del "select * from Schema.table_name"

DB2 命令导入数据：db2 import from /tmp/XX.del of del insert into Schema.table_name "

db2 导入数据命令：

import from [path(eg: /tmp/XX.ixf)] of ixf insert into Schema.table_name 
load from [path(eg: /tmp/XX.ixf)] of ixf insert into Schema.table_name 

load from [path(eg: /tmp/XX.ixf)] of ixf replace into Schema.table_name  ## 装入数据前，先删除已存在记录
load from [path(eg: /tmp/XX.ixf)] of ixf restart into Schema.table_name  ## 装入失败时，重新执行，并记录导出结果和错误信息

import from [path(eg: /tmp/XX.ixf)] of ixf savecount 1000 messages[path(eg: /tmp/msg.txt)] insert into Schema.table_name ## savecount表示每导入1000条记录一次.
load from [path(eg: /tmp/XX.ixf)] of ixf modified by identityignore insert into Schema.table_name ## 目标表有自增