Home > Ask the Data management / BI Experts > Questions & Answers > Should I upgrade now to DB2 V8?
Ask The Data Management Expert: Questions & Answers
EMAIL THIS

Should I upgrade now to DB2 V8?

Craig Mullins, Years 2005-2006 EXPERT RESPONSE FROM: Craig Mullins, Years 2005-2006

Pose a Question
Other Data Management Categories
Meet all Data Management Experts
Become an Expert for this site


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


>
QUESTION POSED ON: 24 August 2004
The other week, I attended a few SHARE sessions on DB2 V8. Should I upgrade to it now? Is it stable?

>
Whether or not to upgrade to V8 of DB2 for z/OS now requires thought and planning. One of the biggest impacts of V8 will be the requirement to be running a zSeries machine and z/OS v1.3 -- or greater. DB2 V8 will not support old hardware nor will it support OS/390.

Keep in mind, too, that the z/OS v1.3 requirement is the minimum requirement, and you will need v1.4 or v1.5 in order to use certain new DB2 V8 functionality (e.g. MLS).

DB2 customers must migrate to V7 before converting to V8. There will be no IBM-supported capability to jump from V6 (or an older version) directly to V8 without first migrating to V7.

Additionally, you will need to understand the modes of DB2 V8. There are three distinct DB2 operating modes that dictate the functionality available to DB2 when operating in that mode. The modes are:

1. Compatibility mode (CM)
2. Enabling new function mode (ENFM)
3. New functionality mode (NFM)

You will need to read the documentation to understand what new features are available in each of these modes and how to transition through the modes.

Basically, CM is V8 without the new features (except the ability to exploit large virtual storage), ENFM is the interim mode used to convert the system catalog tables to support the new functionality, and NFM is full-blown DB2 V8.

So, my advice is that if you have not yet begun to plan how and when you will upgrade to V8, now is a good time to start planning. On the other hand, if you have already read the transition guide, understand the new functionality and put together a plan, then you are ahead of most folks.

Editor's note: Do you agree with this expert's response? If you have more to share, post it in one of our discussion forums.


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   



RELATED CONTENT
IBM DB2 management
How to select an MPP database: DB2 vs. Teradata
What are the top database management systems (DBMS)?
Are there benefits to using both Teradata and a DB2 database?
Tips for evaluating top database management systems and choosing a small DBMS
Exec explains IBM's Information On Demand (IOD) initiative
IBM DB2 9 Fundamentals certification (Exam 730): Sample questions about tables, Part 7
IBM DB2 9 Fundamentals certification (Exam 730): Sample questions about tables, Part 6
IBM DB2 9 Fundamentals certification (Exam 730): Sample questions about tables, Part 5
DB2 basics
IBM DB2 basics

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary



Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.
Browse our Expert Advice

About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 2005 - 2009, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts