What new features in DB2 V8 jump out at you? Data Partioned Secondary Indexes (DPSIs)? New SQL commands? Better use of Unicode?
Of course, there are many great new features of DB2 V8. Here are a few:
DPSIs, which can help to relieve the administration problems typically encountered with today's NPIs.
Long names, so tables and columns and other objects can have longer, more realistic names so DB2 can better support databases moved from other environments.
2M SQL statements, by changing the size of the largest SQL statement from 32,765 bytes to 2,097,152 bytes, V8 makes it possible to write much more complex -- and therefore much more useful -- DB2 SQL statements.
Online schema evolution, so more types of database changes can be made more easily.
More robust SQL, recursive SQL, multi-row FETCH and INSERT, dynamic scrollable cursors, etc.
These are just the highlights -- there are more advantages.
About the only drawback is understanding all of the new functionalities and preparing your organization to use it wisely and effectively.
Of course, risk adverse organizations may also choose to delay implementing new versions of any software to allow others to work the kinks out before them.
Editor's note: Do you agree with this expert's response? If you have more to share, post it in one of our
Dig Deeper on IBM DB2 management
Our expert suggests that the best way to pass the SAP BW exam is to have hands-on job experience. But that's not all he has to say about ...
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.