2.1.1  Benefits of migrating to DB2 UDB

DB2 UDB is number one in performance and number one in market share, with 

more than one million user licenses world wide. DB2 UDB offers open, 

industrial strength database management for e business, business intelligence, 

transaction processing, and a broad range of applications.

Some primary motivators for migration are: 

Multi platform support

DB2 UDB is a true cross platform database management system (DBMS), 

running on a wide variety of systems including Linux, Windows 

98/NT/2000/XP, Solaris, HP UX, and AIX .

Improved performance

DB2 UDB has leading performance across a broad range of application and 

industry benchmarks on a range of hardware and software platforms. To have 

a look at some current performance measurements, please visit: 

http://www.ibm.com

Industrial reliability and high availability support

DB2 UDB provides superior availability with customer proven results. 

Industrial scalability

DB2 UDB has the best scalability. Only DB2 UDB does transaction 

processing and business intelligence scaling to 1000 nodes. For more 

information about scalability see:

http://www.ibm.com

Integrated support for native environments

DB2 UDB conforms to many standards including the operating system it 

supports. It maps closely onto internal resources for performance and 

scalability. All these considerations make it more reliable and integrate it to 

the operating system.

Integrated system management tools

DB2 UDB Version 8 introduced a number of new tools like the 

Health 

Monitor

, the 

Health Center

, the 

Replication Center,

and the 

Storage 

Management

tool. In addition it includes major improvements to existing tools 

like the 

Configuration Assistant

, the 

Control Center,

and the

 Development 

Center

.

Self managing and resource tuning capability

DB2 UDB also has included self managing and resource tuning database 

technology that lets database administrators choose to configure, tune, and 

manage their databases with enhanced automation. The innovative database 

manageability means administrators spend less time managing routine tasks, 

and more time focusing on tasks that help enterprises gain and maintain a 

sustainable competitive advantage.

 Chapter 2. Planning the migration from MySQL to DB2 UDB 

47