我的DB2数据库文件在E:\上,现E:\空间已满,可否将这些文件移动到别的盘上?如果可以,又应该怎样操作
-----------------------------------------------------------------
如果你的表空间是DMS,直接添加容器就可以了,DB2会自动去平衡数据,
如果你的表空间是SMS,需要做离线全备份,再做重定向恢复;
BACKUP DB dbname TO pathname
RESTORE DB dbname FROM pathname TAKEN AT timestamp REDIRECT
SET CONTAINER.....
RESTORE DB dbname FROM pathname TAKEN AT timestamp CONTINUE
具体语法请参照COMMAND REFERENCE
EXAMPLE:
备份: db2=> backup database xxx to /file compress without prompting,做的是离线全备份,应用都停掉做的。
恢复脚本:
./home/psoft8/sqllib/db2profile
db2 "RESTORE DATABASE FS90PRD FROM /file01/file02 TAKEN AT 20090614170540 TO /file03/ INTO FS90PRD redirect WITHOUT PROMPTING"
...
db2 "SET TABLESPACE CONTAINERS FOR 19 USING (FILE '/xxxx/xxx/xxxx/xxxx/xxxxxx.DBF' 30000)"
...
db2 "RESTORE DATABASE FS90PRD CONTINUE"
db2 "ROLLFORWARD DATABASE FS90PRD STOP"
中间SET TABLESPACE CONTAINERS的那段略掉了.
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/13165828/viewspace-606625/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/13165828/viewspace-606625/