在DB2V9的情况下,如果使用自动存储的数据库,备份之后恢复的话可能出现上述报错,必须使用如下办法恢复
restore ..........taken at......... ON path-list DBPATH ON target-dir
例如:
db2 restore db test from "d:\oa" taken at 20121026203410 on "d:\db2i1" dbpath on "d:"
就可以了
path-list指放tablespace的storage路径
target-dir指存放 db control files 的地方