Connections migration DB issues

I thought I had already posted this but was remided by our slack chat today that I hadn’t. When migrating the Connections meetrics database from V5 to V6 there is an error that is thrown when the DB2 restore tries to run the upgrade command.

DB20000I The RESTORE DATABASE command completed successfully.
SQL2519N The database was restored but the restored database was not upgraded to the current release

The error related to the application heap size, and there is not enough space allocated to run the upgrade command.

Get the current heap size by running the following db2 command

db2 GET DATABASE CONFIGURATION FOR METRICS

You can resolve the issue running the commands:

db2 UPDATE DB CFG FOR METRICS USING APPLHEAPSZ 1536
db2 UPGRADE DATABASE METRICS

I set the APPLHEAPSZ to double the current one. I have also previously seen the same issue with the Cognos DB – which can be resolved in the same way

db2 UPDATE DB CFG FOR COGNOS USING APPLHEAPSZ 2018
db2 UPGRADE DATABASE COGNOS

I have seen this issue with both Connections V5 and 5.5 DB2 databases updating to V6 and this has fixed it for me (and now some others) .. when you google the error you don’t get much in the way of help, so hopefully this will help others who get stuck.

 

 

 

Leave a Reply

Your e-mail address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.