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
[email protected]/search390>discussion forums.
Dig Deeper on IBM DB2 management
To export data from a DB2 table to a flat file, you need to run an export specifying the proper file format. The export utility exports data from a ...
Craig Mullins recommends two specific resources for learning how to create and support Binary Large Objects (BLOB) in DB2.
Craig Mullins explains various definitions of a data mart and sheds some light on the complexity of its relation to a data warehouse.