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

Hot DB2 V8 features

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 .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