New Features of DB2 10: Easier migration from Oracle

Here are some:

Local type

This function allows PL/SQL and SQL PL blocks in BEGIN... The END block defines local type variables. Before declaring this type, you need to convert it to a global type or PL/SQL package.

The following PL/SQL statements can be performed in DB2.

 
 

  
  
DECLARE 
  
  
TYPE point IS RECORD(x NUMBER, y NUMBER);  
  
  
here point;  
  
  
BEGIN 
  
  
here := (5, 3);  
  
  
END;  
  
  
/ 
 
 

Local Program

This function is similar to a local type that allows you... Declare the program in the END block. In turn, programs can declare local programs, reference variables and local types in the blocks they declare. Similar to the local type in DB2 9.7, when an application uses this function, you need to move the locally declared programs to a package or make them global.

The following PL/SQL statements can be performed in DB2.

 
 

  
  
DECLARE 
  
  
TYPE point IS RECORD(x NUMBER, y NUMBER);  
  
  
PROCEDURE makepoint(x IN NUMBER, y IN NUMBER, xy OUT point)  
  
  
IS 
  
  
BEGIN 
  
  
xy := (x, y);  
  
  
END;  
  
  
here point;  
  
  
BEGIN 
  
  
makepoint(5, 3, here);  
  
  
END;  
  
  
　/ 
 
 

PL/SQL Expression Inlining

DB2 9.7 is fast. DB2 10 or even faster!

Customers and business partners often report that Oracle applications enable DB2 to achieve or exceed the performance of the source system. However, there has been a situation where the features of heavy program logic, few or no SQL have yet achieved this goal.

The reason is that DB2 9.7 executes most simple SQL statements in mathematical or string expressions.

DB2 10 compresses Most algorithms, Boolean logic, and string operations into a single lightweight unit. This greatly improves the performance.

One business partner will say that switching from DB2 9.7 to DB2 10 provides improvements to multiple specific PL/SQL routines. This, in turn, accelerates a key process by exceeding the performance goal of more than 20% compared with the source system.

Please wait. More!

There are many other features, instead of further improving application compatibility and making DB2 a good choice.

Expression Supporting hash connection conditions

Zig zag join

Row and column access control (RCAC)

Merge pureScale DB2 10

By the numbers

Since DB2 9.7, the compatibility between DB2 and real Oracle Applications has steadily increased. So far, DB2 seems to have broken the PL/SQL code command line of 98%. When an application is migrated from Oracle to DB2 10, these command lines remain unchanged.