| « Virtualizing IBM Lotus Domino 8.5.1 on VMware vSphere 4 | Massloading the WebSphere Commerce v7.0 data fails » |
Error upgrading database backup to a new DB2 9.7
After restoring the database backup to a new DB2 9.7 server, the RESTORE DATABASE command should automatically run the UPGRADE DATABASE command to upgrade to the new level.
However, if you are upgrading from version 8 this results in the database not being upgraded, and the RESTORE DATABASE command returns the following error message with reason code:
SQL2519N The database was restored but the restored database was not upgraded to the current release. Error "-1704" with tokens "3" is returned. SQLSTATE=57011
Solution:
Reason code 3 normally indicates that the upgrade failed because the database logs are full. However, in this scenario we fixed the problem by upgrading to DB2 9.7 Fix Pack 3a.
(via Randall de Boer)
However, if you are upgrading from version 8 this results in the database not being upgraded, and the RESTORE DATABASE command returns the following error message with reason code:
SQL2519N The database was restored but the restored database was not upgraded to the current release. Error "-1704" with tokens "3" is returned. SQLSTATE=57011
Solution:
Reason code 3 normally indicates that the upgrade failed because the database logs are full. However, in this scenario we fixed the problem by upgrading to DB2 9.7 Fix Pack 3a.
(via Randall de Boer)