Results 1 to 7 of 7
  1. #1
    Join Date
    Jun 2016
    Posts
    3

    Unanswered: Problem in connecting to database

    Hello experts,

    We have a issue in connecting to DB2 database after it was brought down for firmware upgrade.

    1. The error is ---The database must be upgraded to latest release.However we are at DB2 level 10.5.6
    We can see this error in db2diag.log from long time.

    2. This system is brought down after long time.Now we are not able to connect to DB.

    If we issue db2 connect to database <SID>,its throwing the above error.

    We even tried FIX pack upgrade,the post installation script is also giving then same error.

    Kindly help us to resolve the issue.

    Thanks,

    Karthik

  2. #2
    Join Date
    Apr 2008
    Location
    Iasi, Romania
    Posts
    561
    Provided Answers: 2
    You should give us the error code and SQLSTATE. Also, OS info.
    Florin Aparaschivei
    DB2 9.7, 10.5 on Windows
    Iasi, Romania

  3. #3
    Join Date
    Jun 2016
    Posts
    3
    SQL5035N The database must be upgraded to the current release
    OS info:Linux 2.6.32-131.0.15.el6.x86_64 #1 x86_64 x86_64 x86_64 GNU/Linux

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Code:
    SQL5035N  The database must be upgraded to the current release.
    
    Explanation:
    
    The database was created in a previous release of DB2 database product.
    You must issue the UPGRADE DATABASE command to upgrade the database to
    the current release.
    
    The command cannot be processed.
    
    User response:
    
    Issue the UPGRADE DATABASE command before attempting to access the
    database using the current release.
    
    If you receive this message when you issued a database restore, drop the
    existing database before proceeding.
    
    sqlcode: -5035
    
     sqlstate: 55001
    Andy

  5. #5
    Join Date
    Jun 2016
    Posts
    3
    We have issued upgrade database command but ends up with same error.

    Also we have tried fix pack upgrade but the post installation script also gives the same error.

    And regarding dropping and recreating database,we don't have a backup in place as this is a test system.

    Regards,
    Karthik

  6. #6
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Have you tried running this:

    http://www.ibm.com/support/knowledge.../r0054449.html

    Andy

  7. #7
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    Hello,

    db2diag -A
    db2 upgrade database <SID>

    Run these commands as a DB2 instance onwer, show us the result of the last command and contents of the ~/sqllib/db2dump/db2diag.log file.
    Regards,
    Mark.

Posting Permissions

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