db2数据表导入(import)导出(export)命令

#导出命令

db2 export to [file_name] of ixf select [column1,column2,...] from [tablename]

#导入命令

db2 import from [file_name] of ixf insert into [tablename]

#导入命令(如果数据量过大，则要加入commitcount参数如下，否则可能会出现事务日志满的错误（Database transaction log is full）)

db2 import from [file_name] of ixf commitcount [n] insert into [tablename]