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)"
页:
[1]