Blog Archives

How to Import Data into SQL Server 2005 From DB2 (AS400/iSeries)

Ever since I read how much IBM’s DB2 SMOKED Oracle and SQL Server in the tpc-c (OLTP) benchmarks, I’ve wanted to work with it. The benchmarks go a little something like this: RDBMS tpc-c IBM DB2 6,085,166 Oracle 4,092,799 Microsoft

Posted in DB2, SQL Server

IBM DB2: Five Ways to Discover the Hostname of an iSeries Server for Use in a Four-Part Table Name

I admit, I don’t have too much experience with DB2 yet. But it’s on my to-do list and I’m working on it. I recently had to import some data from DB2 hosted on an iSeries server. I had the hardest

Posted in DB2

Create a DB2-C Express 9.5 Linked Server in SQL Server 2008

In order to emulate a DB2/iSeries<->SQL Server setup that I deal with at work, I installed DB2 Express-C on SuSE Linux Enterprise Server 10. The DB2/Linux Server details, as well as a sample database and table name, are as follows:

Posted in DB2, SQL Server

Free DB2 Express-C 9.5 on SuSE Linux Enterprise Server

IBM DB2’s free version “DB2 Express-C” is available for download at So far, I’ve successfully installed and uninstalled DB2 Express on SLES 10 SP2. While there was a command line installer included (db2_install), the server wouldn’t start after a

Posted in DB2, Linux