DB2 表误删除

表误删除

恢复的前提，必须对该表所在表空间启用DROPPED TABLE RECOVER选项，通过如下命令验证：
db2 “select tbspace,drop_recovery from syscat.tablespaces”

从删除表历史里找到表的DDL
db2 list history dropped table all for testy

前滚恢复的同时导出被删除的表的数据库
db2 “rollforward db testy to end of logs and stop tablespace (ts1) online recover dropped table 000000000000444000060004 to ./exporttab”

SQL4908N The table space list specified for roll-forward recovery on
database “” is invalid on members or nodes “”.

利用删除表历史中的DDL语句重建表

IMPORT或者LOAD前滚恢复中导出的数据

db2 “import from ./exporttab/NODE0000/data del insert into db2inst1.t1”

db2 “load from ./exporttab/NODE0000/data del insert into db2inst1.t1”