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


We are IT pros who grew up living and loving life in Cajun Country.


Chrissy LeMaire
View Chrissy LeMaire, BSc. MCITP's profile on LinkedIn

Brandon Abshire
View Brandon Abshire, MCDBA's profile on LinkedIn


Chrissy LeMaire
Microsoft PowerShell MVP