Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2016
    Posts
    2

    Unanswered: DB2 upgrade from 9.7 to 10.5

    Hi,

    I am restoring a 9.7 database on a new server with DB2 10.5 installed and I get the following message. Can anyone help with this error message?
    Thanks


    db2 => RESTORE DATABASE ISC4 FROM "D:\DB2Backups\OFFLINE" TAKEN AT 2016083104001
    8 TO "E:" INTO ISC4 WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 WITHOUT PROMPTING
    SQL2519N The database was restored but the restored database was not upgraded
    to the current release. Error "-954" with tokens "1 1208 DB2ADMIN ISC4
    QDB2/NT64 88 88 0 1252 0 " is returned

  2. #2
    Join Date
    Apr 2012
    Posts
    1,006
    Provided Answers: 16
    Check the suggestions for SQL0954C in the Knowledge Center (link below), and also I suggest to install from a V10.5 build that is at Fixpack7 or higher (if you don't know the fixpack level, you can download the server-fixpack at FP7 or higher and install from that).
    http://www.ibm.com/support/knowledge...sql00954c.html

  3. #3
    Join Date
    Sep 2016
    Posts
    2
    Hi,

    Thanks for your help. I ran the following two commands and it resolved the issue.

    db2 update db cfg for db_name using APPLHEAPSZ 2048 AUTOMATIC
    db2 update db cfg for db_name using DBHEAP 4096 AUTOMATIC

    Thanks again.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •