DB2常用命令

1、db2start

   db2stop

2、connect to db_name user db_username using db_password

3、db2set DB2_CREATE_DB_ON_PATH=YES             (SQL1052N)

4、db2set DB2_EXTSECURITY=NO          (SQL1219N)

5、db2 restore database db_name from '文件所在文件夹' taken at 20130617215906 on d:\DB2 path on d:\DB2             (SQL0902C重定向恢复)

6、export to aa1.ixf of ixf select * from table1

   export to aa2.csv of del select * from table2

   import from aa1.ixf of ixf replace into table1