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