-
编辑 删除
使用表空间备份重建数据库
今天在个人机子上试验了一下，通过部分表空间备份重建数据库有3个表空间备份NEWDB.3.db2inst1.DBPART000.20130821204748.001 MYTBS的备份NEWDB.3.db2inst1.DBPART000.20130821204740.001 SYSTOOLSPACE的备份NEWDB.3.db2inst1.DBPART000.20130821204722.001 SYSCATSPACE USERSPACE1的备份只用3个表空间来重建NEWDB（SYSCATSPACE是必须的）db2 "restore db newdb rebuild with tablespace (SYSCATSPACE,USERSPACE1,mytbs) taken at 20130821204748"SQL2561W Warning! Rebuilding a database from a table space im
-
编辑 删除
list history command
开始学习DB2，记录一下自己的学习成果。list history command的解释>>-LIST HISTORY--+-------------------+--------------------------> +-BACKUP------------+ +-ROLLFORWARD-------+ +-DROPPED TABLE-----+ +-LOAD--------------+ +-CREATE TABLESPACE-+ +-ALTER TABLESPACE--+ +-RENAME TABLESPACE-+ +-REORG-------------+
