==============================================================================================
连接到数据库: connect to ertpaml user erptaml using erptaml
备份 backup db mydatabase to E:/zyy/
还原 restore db mydatabase from E:/zyy/
导出某一张表结构及数据 :export to d:/aa.ixf of ixf select * from TableName
导入: import from d:/aa.ixf of ixf commitcount 5000 create/insert/replace into TableName
==============================================================================================
db2look -d YOURDB -a -e -x -o creatab.sql
导出建库表的SQL
db2move YOURDB export
用db2move将整个数据库数据备份出来
=====================================================
db2 force applications all
停止DB2所有进程
=====================================================