DB2 常用命令

数据导出

db2 export to E:\xxxxxxx.del of del select * from tm_owner;

数据导入：

db2 import from tm_vehicle.del of del  insert into tm_vehicle

 

数据库事物日志已满：

db2 get db cfg for imssh

db2 update db cfg for imssh using LOGPRIMARY 100
db2 update db cfg for imssh using LOGSECOND 40
db2 update db cfg for imssh using LOGFILSIZ 10240

默认

db2 update db cfg for imssh using LOGPRIMARY 13
db2 update db cfg for imssh using LOGSECOND 12
db2 update db cfg for imssh using LOGFILSIZ 1024
 

 

修改表明：

rename table table1 to table2;

 

 

 

转载于:https://my.oschina.net/wangdaxin/blog/685107