taoxingtianxia 发表于 2013-1-13 18:09:26

DB2常用操作命令

 
进入DB2编辑框:
db2cmd


打开DB2:
db2start


连接用户为pangdatao密码为108117的DB2数据库sample:
db2 connect to sample user pangdatao using 108117


断开数据库sample的连接:
db2 disconnect sample


备份数据库sample到e:\db2:
db2 backup db sample to e:\db2


恢复备份时间戳为201111231155567的数据库sample:
db2 restore db sample from e:\db2 taken at 20111231155567


停止DB2:
db2stop
 
页: [1]
查看完整版本: DB2常用操作命令