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

The benefits and drawbacks of DB2 V8

What are the benefits/drawbacks to upgrading to DB2 V8?
There are many benefits offered by DB2 V8. The biggest of them is 64-bit addressing that offers virtual storage constraint relief. Prior to V8, DB2 used 31-bit addressing, which was introduced over 20 years ago in 1981.

With all this additional storage, IBM has moved many things above the 2Gb bar to free up space below. This includes the buffer pools, the sort and RID pools, parts of the EDM pool, and more. These changes allow for significantly greater throughput, with more concurrent threads and therefore improved scalability.

With the ability to create very large virtual buffer pools, many organizations will jump at the chance to expand the size of buffers to keep pace with their large databases and 24/7 applications.

Some organizations are choosing to implement DB2 V8 in CM just to get the expanded virtual storage. This allows them to benefit from the 64-bit addressing without having to worry about how to implement most of the new functionality of V8.

Over time, with planning and understanding, these organizations will migrate through ENFM and into NFM, but CM brings immediate relief without much downside.

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.

This was last published in August 2004

Dig Deeper on IBM DB2 management

PRO+

Content

Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchAWS

SearchContentManagement

SearchOracle

SearchSAP

SearchSQLServer

Close