IBM DB2 database has a long history and is available on a myriad of IBM mainframes and operating systems. Its original roots are in 70s, when IBM’s researcher Edgar F. Codd described the theory of relational databases and relational algebra. However, DB2 (or IBM Database 2) name was officially assigned to a product in 1983. IBM, ironically, failed to recognize the potential of Codd’s innovation and Oracle ended up actually beating IBM to market with its SQL language implementation.
We support DB2 directly in our products! You don't need separate drivers and can immediately connect to your database.
Today, IBM DB2 is still going strong and is capable of supporting legacy (read – extremely old) applications, as well as providing latest features. It is very reliable and fast database, used in enterprise market. TPC-C and TPC-H industry benchmarks show excellent performance of DB2.
Competing with Oracle, DB2 is supposedly able to run 98% of Oracle SQL code without changes, allowing even very large codebases to migrate from Oracle to DB2 relatively quickly. DB2 is able to reach great performance levels.
There is a free edition of DB2 called DB2 Express-C. While free editions of Oracle and SQL Server are limited in database size, DB2 Express-C isn’t. It will use just two CPU cores and maximum 16GB of memory, but it may make sense to use it for large databases under light average load.
It's very easy to copy existing database tables into your DB2 database. Just point Full Convert to your source database, select your target and let it copy things over.
Tutorials showing how to copy data from another database into DB2:
It may make sense to migrate your data away from DB2. You may want to do it permanently or just need to share your tables with a collague in a different format.
Tutorials showing how to copy data from DB2 to another database: