Topic
  • 5 replies
  • Latest Post - ‏2013-09-12T10:11:30Z by 05D4_灼_马
SystemAdmin
SystemAdmin
17917 Posts

Pinned topic SQL5035N The database must be upgraded to the current release.

‏2009-08-18T06:59:28Z |
I restore a newly created database with a backup file, and received an warning message of "SQL2519N The database was restored but the restored database was not upgraded to the current release. Error "-902" with tokens "*N" is returned." It may be caused by the current db2 server is at V9.7 level, but the backup file was generated under a lower level of db2 server.
db2inst1@test01~$ db2 restore database a500k from /home/db2inst1 on /home/db2inst1 into annuity
SQL2529W Warning! Restoring to an existing database that is different from
the backup image database, and the alias name "ANNUITY" of the existing
database does not match the alias name "A500K" of the backup image, and the
database name "ANNUITY" of the existing database does not match the database
name "A500K" of the backup image. The target database will be overwritten by
the backup version. The Roll-forward recovery logs associated with the target
database will be deleted.
Do you want to continue ? (y/n) y
SQL2519N The database was restored but the restored database was not upgraded
to the current release. Error "-902" with tokens "*N" is returned.


This prevent me from connecting to the database and do more work.
db2inst1@wasbld14 ~$ db2 connect to annuity
SQL5035N The database must be upgraded to the current release.
SQLSTATE=55001


So I tried to migrate or upgrade the database by the following ways, but all failed.

db2inst1@wasbld14 ~$ db2 migrate db annuity
SQL0902C A system error (reason code = "") occurred. Subsequent SQL
statements cannot be processed. SQLSTATE=58005

db2inst1@wasbld14 ~$ db2 upgrade database annuity
SQL0902C A system error (reason code = "") occurred. Subsequent SQL
statements cannot be processed. SQLSTATE=58005

Anyone who give me suggestion will be appreciated!
Updated on 2011-01-11T11:10:02Z at 2011-01-11T11:10:02Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    17917 Posts

    Re: SQL5035N The database must be upgraded to the current release.

    ‏2009-08-18T12:17:48Z  
    Hi there,

    What version is the database that you backed up? Is it a full offline back up?
    You can only restore Version 8, Version 9.1, or Version 9.5 databases.

    Hope this helps,

    Amyris.

    PS: the Information Center has a tasks that describes how to upgrade using a backup.
    http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/topic/com.ibm.db2.luw.qb.migration.doc/doc/t0011368.html
  • SystemAdmin
    SystemAdmin
    17917 Posts

    Re: SQL5035N The database must be upgraded to the current release.

    ‏2009-08-25T02:50:32Z  
    Hi there,

    What version is the database that you backed up? Is it a full offline back up?
    You can only restore Version 8, Version 9.1, or Version 9.5 databases.

    Hope this helps,

    Amyris.

    PS: the Information Center has a tasks that describes how to upgrade using a backup.
    http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/topic/com.ibm.db2.luw.qb.migration.doc/doc/t0011368.html
    Thanks Amyris for your follow-ups! Anyway, I was not clear on what version of DB2 this backup was originally from, although I think it was V8.x. My colleague have been able to successfully restore the image on V9.1 in his own environment and run with it, but he never actually figured out how to migrate it to a V9.1 instance.

    This is still an issue to me.
  • SystemAdmin
    SystemAdmin
    17917 Posts

    Re: SQL5035N The database must be upgraded to the current release.

    ‏2009-08-25T11:00:43Z  
    Thanks Amyris for your follow-ups! Anyway, I was not clear on what version of DB2 this backup was originally from, although I think it was V8.x. My colleague have been able to successfully restore the image on V9.1 in his own environment and run with it, but he never actually figured out how to migrate it to a V9.1 instance.

    This is still an issue to me.
    Hi there,

    If you read the topic in the link that I indicated previosly, it explains that the BACKUP DB command runs the MIGRATE DATABASE command after restoring the database. It is likely that there was an issue when running the MIGRATE DATABASE command.

    Hope this helps,

    Amyris.
  • SystemAdmin
    SystemAdmin
    17917 Posts

    Re: SQL5035N The database must be upgraded to the current release.

    ‏2011-01-11T11:10:02Z  
    Hi there,

    If you read the topic in the link that I indicated previosly, it explains that the BACKUP DB command runs the MIGRATE DATABASE command after restoring the database. It is likely that there was an issue when running the MIGRATE DATABASE command.

    Hope this helps,

    Amyris.
    I try this 3 days.

    The solution:

    OBDC Data Source and Configure the database with User and Password.
  • 05D4_灼_马
    05D4_灼_马
    1 Post

    回复:SQL5035N The database must be upgraded to the current release.

    ‏2013-09-12T10:11:30Z  

    As a Chinese DBA, the solution found here!

    Because I met the same problem as you, but I try to use your resume statement, the result was able to successfully restored, and database connection.

    As for your this upgrade command:

    "SQL0902C A system error (reason code =" occurred. Subsequent SQL ")

    Statements cannot be processed. SQLSTATE=58005"

    I suspect that is not caused by the SYSTEM or DB2 encoding problem.

     

    有问题联系:

     

    EMAIL: 315129775@QQ.COM