DB2 v10: Top New Features for Developers

The features which are useful to developers added as part of DB2v10. Find the complete list here.

  1. If you have any old plans and packages that were bound at DB2 Version 5 or before, they will NOT work in DB2 x. You have to REBIND. For many of you this should not be a big deal because the folks I talk with manage to bind/rebind their plans and packages when they moved to DB2 Version 8.
  2. DB2 x will no longer support plans that have DBRMs bound directly. Start planning today to get off the old style DBRM bound directly into a plan. You have to use packages. Now this shouldn’t be a surprise. We have been tell you to do this since about DB2 V2.3 (smile)There should be service in DB2 9 to help you move off of DBRMs bound directly into plans.
  3. Move your ACQUIRE(ALLOCATE) packages to ACQUIRE(USE)
  4. XML Extender is finally no more. If you want to use XML, you should absolutely be using the new XML data type.

Related Pots

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.