Results 1 to 5 of 5

Thread: OS Upgrade

  1. #1
    Join Date
    Feb 2009
    Posts
    18

    Unanswered: OS Upgrade

    Hello. we are looking to upgrade our operating system on our database server (DB2 v8.2) from sles-9 to sles-10SP2. i would like to know what should be done, from the database side, before and after this upgrade. Thanks

  2. #2
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746
    make a full/offline backup.
    Then upgrade. If it still works, fine. If not re-install DB2 and re-create/restore your database.
    and ... try it on a test-server first...

  3. #3
    Join Date
    Feb 2009
    Posts
    18
    OK thats fine but are there no specific configurations or settings that must be changed or updated? If yes then you're saying that I simply do a full offline backup and restore after the os upgrade?

  4. #4
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    All you need to do is to stop the instances and then upgrade the OS. Nothing should happen to your db2 installation/instances/databases, but taking an offline database backup prior to the upgrade is a good idea. During an OS upgrade, permissions on db2 binaries may get modified and as a result you won't be able to start the instance (sql1042c). If that happens, you'll need to update the instance using the db2iupdt command. When upgrading the OS, always verify that you meet the minimum DB2 requirements (ie. kernel/libraries level). For DB2 v8 and SLES 10, they're documented here:
    IBM developerWorks: Wikis - Information Management - SUSE Linux Enterprise Server (SLES) 10 - DB2 UDB V8.2

  5. #5
    Join Date
    Feb 2009
    Posts
    18
    Thank you kindly, db2girl and dr te z

Posting Permissions

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