Migrating Oracle Instead of triggers to DB2

Currently DB2 is supporting instead of triggers but not in PL/SQL context. This may come in a near future version of DB2. who knows?!!

So, you'll need to migrate all of your triggers to DB2 SQL PL.

A possible workaround would be to move your trigger code into a stored procedure which takes two anchored parameters of the same view type (i.e. MyV%ROWTYPE). This should solve most of the effort.

Enjoy!

IBM to unveil NoSQL technology inside DB2

Curt Cotner, IBM's vice president and chief technology officer for database servers, Announces that IBM plans to inject NoSQL technology in DB2 database system early next year. IoD Vegas 2011.

For more information plz check: http://searchdatamanagement.techtarget.com/news/2240102614/IBM-to-unveil-NoSQL-technology-inside-DB2

DB2 9.7 FP 5 released

IBM announced the release of DB2 9.7 FP5.

You can download the new fix pack from IBM site: www.ibm.com/support/docview.wss?uid=swg24031181

Major enhancements in the compatability were added. A key feature is nested collections support. Now you can have nested collection for up to 16 levels. Converting Oracle collection should be a piece of cake now :)

Some new functions are added like HEXTORAW, NVL2 and SUBSTR2

For complete FIX PACK summary, please check http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=/com.ibm.db2.luw.wn.doc/doc/c0056050.html