When writing my book Extract, Transform and Load with SQL Server Integration Services I was using my past experience which was to use DB2 on the IBM i so I did not include include installation instructions for any environments for DB2 in the book. I would like to eliminate that deficit by providing that supplemental information here on my website.
 
I found a good IBM reference which compares the different versions of DB2 here:https://www.ibm.com/analytics/us/en/db2/trials/
 

Figure 1. IBM DB2 Versions
 
Which shows the trial versions of DB2 available. My initial question was what version do I use? The Express Edition (Express) or the Community Edition (Express-C)? This page answered that question for me.
 
IBM Db2 Database Express Edition

• Memory and DB size: Unlimited
• Length of Trial: Limited

 
IBM Db2 Developer Community Edition

• Memory and DB size: Limited
• Length of Trial: Unlimited

So for educational purposes I decided to go with the Community Edition (Express-C) because I don't need a full production environment for development examples and I didn't want my license to expire before I was done playing with it.
 
After clicking on the download button in figure 1 I had to go through the sign in process then landed on the download page to find that Mac and Linux are listed, but no Windows.
 

Figure 2. IBM DB2 Community Edition for Mac and Linux
 
So I found an additional link on the bottom, which took me to the Windows download which is NOT intended for production usage.
 

Figure 3. IBM DB2 Community Edition for Windows (Installing this version)
 
Now I have the correct version of DB2 download on my computer and am ready to install.
 
If you decided to install the NON Community Express Edition with a limited trial you will see there there is a Windows version available there also.
 

Figure 4. IBM DB2 Trial Edition for Windows (Not installing this version in this article, for information but you could install)
 
For this article we will be installing the Community Edition. Figure 4 was just satisfying my curiosity to ensure that the Windows version is production worthy in the full version before I vested my time in playing with the Community edition.
 
Unzip the v11.1_ntx64_dec.zip file (or whatever version you have) you've download and run the setup application in the unzipped folder.
 

Figure 5. IBM DB2 Setup Launchpad
 
 

Figure 6. IBM DB2 Typical Installation Type with JDBC and OLE DB Support
 
 

Figure 7. Install DB2 Server Edition on this computer
 
 

Figure 8. Select the Installation Folder
 
 

Figure 9. IBM SSH Installation
 
When you set the db2admin password make sure you save it for later.  

Figure 10. Set the db2admin password
 
 

Figure 11. Setup the DB2 Instance
 
To keep things simple for our development environment we'll create a single partition.  

Figure 12. Single Partition Instance
 
 

Figure 13. Configure Instances
 
To keep things simple for our development environment we'll skip the notifications. This is NOT advised for production and you're welcome to set yours up but I will not focus on that for this install.  

Figure 14. Setup Notifications
 
To keep things simple for our development environment we'll skip the security. This is NOT advised for production and you're welcome to set yours up but I will not focus on that for this install.  

Figure 15. Operating System Security
 
 

Figure 16. DB2 Setup
 
 

Figure 17. Setup Complete
 
 

Figure 18. Install Additional Products
 
Once the install is completed you will see the DB2 First Steps screen. Click on Create sample database.
 

Figure 19. Create Sample Database
 
When I created my sample database I walked away and had dinner. It took a while.  

Confirm the Installation

Let's close out this topic by confirming our installation. We can do this by looking at our sample database that was installed.
 
Look in the Windows App list for the IBM Command Line Processor and run it. Enter db2 and press enter
 
To view the databases installed:
list database directory
 
To connect to the database:
connect to sample
 
To list the tables in the database:
list tables
 
To view the contents of the ORG table:
select * from org
 
To disconnect from the database:
terminate
 

Coming Soon...

Connect the SQuirreL IDE to your DB2 database to create your own database. Then we will use SSIS on your DB2 database. Please check in to see when it's available.
 

Happy DB2ing!