关于db2联机备份

彩云归

我联机备份了一个数据库WEB，从备份的文件大小上来看，应该是成功了。但根据备份恢复后，却总是出现
[IBM][CLI Driver] SQL1117N  由于 ROLL-FORWARD PENDING，不能连接或激活数据库 "WEB"。  SQLSTATE=57019

我试过停止回滚，提示操作成功，但点击WEB数据库，还是出现上述错误。我也试过把这个数据库的参数userexit和logretain改了，但也不管用。

请问应该怎么办？如何避免这种情况？

sonne

如果是报下面类似错误，可做如下调整，
db2 =>; connect to test_a
SQL1117N A connection to or activation of database "TEST_A" cannot be made because of ROLL-FORWARD PENDING. SQLSTATE=57019

db2 =>; ROLLFORWARD DATABASE test_a stop
Rollforward Status
Input database alias = test_a
Number of nodes have returned status = 1

Node number = 0
Rollforward status = not pending
Next log file to be read =
Log files processed = -
Last committed transaction = 2003-05-02-01.41.08.000000

DB20000I The ROLLFORWARD command completed successfully.

db2 =>; connect to test_a

Database Connection Information

Database server = DB2/6000 6.1.0
SQL authorization ID = DB2ADMIN
Local database alias = TEST_A