db2命令

--db2 导入导出ixf名命令 

db2 "export to exportfileName.xif of ixf select * from tablename"

 

db2 "import  from importfileName.ixf of ixf  insert into tablename"

--10w行提交一次

db2 "import from importfileName.ixf of ixf commintcount 100000 insert into tablename"

--db2  导出del文件命令

db "export to filename.del of del select * from tablename"

 

--db2 catalog

 db2 uncatalog node nodeName
db2 catalog tcpid node noadeName remote 182.122.222.111 server 5000

db2 catalog db dbName as db at node  nodeName

 

--db2  查看表结构

 db2look -d dbname -e -t tableName -o tablename.sql

 

--db2 查看表空间

db2 list tablespaces

db2 list tablespace containers for 1 show detail 

 

--db2 增加表空间

db2 "alter tablespace  name add(file  '/db2data/db2name/filename.dat'  10000)"