随笔分类 -  db2

DB2中创建表
摘要：CONNECT TO TEST;CREATE TABLE DB2ADMIN.PERSON ( ID BIGINT NOT NULL , NAME BIGINT , FLAG BIGINT , ADDRESS VARCHAR (500) ,DEFSTR VARCHAR (500) , CONSTR... 阅读全文
posted @ 2015-12-11 14:25 雨中飞鹭 阅读(2140) 评论(0) 推荐(0)
db2的定时备份
摘要：定时任务：db2.batdb2cmd -i -w db2_backup.bat exit db2_backup.batdb2 connect to TESTdb2 force applications alldb2stop forcedb2start db2 backup database sx... 阅读全文
posted @ 2015-12-11 14:22 雨中飞鹭 阅读(401) 评论(0) 推荐(0)
db2的离线备份和还原
摘要：db2cmd中运行命令1.做一个离线备份（db2cmd）mstsc—>db2cmddb2 connect to mydb #连接数据库db2 list applications ＃显示数据库应用状态db2 force applications all ... 阅读全文
posted @ 2014-12-30 11:31 雨中飞鹭 阅读(2036) 评论(0) 推荐(0)