Problem solve Get help with specific problems with your technologies, process and projects.

Should I upgrade now to DB2 V8?

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 .VO7aaqqaAFk.0@/search390>discussion forums.

Dig Deeper on IBM DB2 management

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.