The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.
Course Of The Month
9 days, 9 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Migration from db2v9.1 to db2v9.5
Posted on 2011-02-16
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
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
[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
Active today
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
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
Featured Post
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…
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface.
Change Cu…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month9 days, 9 hours left to enroll
623 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.