Dennis' Domino Blog
« Virtualizing IBM Lotus Domino 8.5.1 on VMware vSphere 4Massloading the WebSphere Commerce v7.0 data fails »

Error upgrading database backup to a new DB2 9.7

Permalink 02/25/11 15:28, by Dennis van Remortel, Categories: Websphere
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)

No feedback yet

Leave a comment


Your email address will not be revealed on this site.

Your URL will be displayed.
PoorExcellent
(Line breaks become <br />)
(Name, email & website)
(Allow users to contact you through a message form (your email will not be revealed.)
What Lotus product is discussed mainly here? The answer is domino
antispam test
Yet another Domino/Websphere Admin blog.

About me:
Lotus Notes/Domino Admin
Websphere Commerce Admin
sceptic
critic



Search

XML Feeds

Planet Lotus

blog engine

©2012 by Dennis van Remortel

Contact | Blog template by Asevo | blog engine | cheap hosting | adsense