Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Migration from db2v9.1 to db2v9.5

Posted on 2011-02-16
1
Medium Priority
?
508 Views
Last Modified: 2012-06-21
In our project, they are planning to migrate from db2v9.1 to db2v9.5

I need to know the impact and how many days will it take to migrate and the detials about the migration..this is on priority, Kindly send me any links if you have any...

there are 4 databases at present in this enviroinment and it on AIX
0
Comment
Question by:jmartin_v
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 46

Accepted Solution

by:
Kent Olsen earned 2000 total points
ID: 34906357
Hi Jmartin,

You should be able to upgrade the DB2 server objects without impact to the database(s).

IBM typically uses the minor release number (in this case, .1 to .5) to indicate that corrective code (patches) and small features have been added to the base product.  Anything that involves structure changes to DB2 internal objects or data storage is done as part of a major release.

Since both versions are release 9.x, this should be easy, with no need to convert or restore data.


Good Luck,
Kent
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

November 2009 Recently, a question came up in the DB2 forum regarding the date format in DB2 UDB for AS/400.  Apparently in UDB LUW (Linux/Unix/Windows), the date format is a system-wide setting, and is not controlled at the session level.  I'm n…
Recursive SQL in UDB/LUW (it really isn't that hard to do) Recursive SQL is most often used to convert columns to rows or rows to columns.  A previous article described the process of converting rows to columns.  This article will build off of th…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Suggested Courses

704 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question