DB2常用命令（中）

• 暴力停库

db2_kill

• schema导出

db2move dbname export -sn achema_name -u id -p password

• schema恢复

db2move dbname load -lo replace -u id -p password

• 表数据导出

--1.无分割符导出

db2 export to /directory/filename.txt of del select * from tablename

db2 export to /directory/filename.del of del select * from tablename

--2.有分割符导出

db2 export to /directory/filename.txt of del modied by coldel | select * from tablename

db2 export to /directory/filename.del of del modied by coldel |select * from tablename

• 数据导入表

--1.无指定分隔符

db2 load from /directory/filename.txt of del insert into tablename nonrecoverable

--2.指定 "|"为分隔符

db2 load from /directory/filename.txt of del modified by coldel | insert into tablename nonrecoverable