Friday, January 31, 2014

Installation of DB2 V9.7 on UBUNTU 12.04 - PART 1

Aim : Installing DB2 for training and personal use.



To decide whether to install DB2 in Linux or Unix or Windows, My choice would be Linux as we have some open source operating systems in Linux which are available with no license fee. So i consider Ubuntu 12.04 for all my trainings and learning with DB2. I am not sure about other editions of Ubuntu as i didn't test them. Also my machine is Windows 7 Home premium 64 bit so i consider 64 bit softwares for all my installations.



1) Download Vmware workstartion evaluation copy from Vmware official site. Below is the link for download

http://www.vmware.com/products/workstation/workstation-evaluation

2) Download Ubuntu 12.04 Desktop from below link from Ubuntu official site. Below is the link for download

http://www.ubuntu.com/download/desktop 

3) Download 90 day free trail of DB2 LUW V9.7 Data server which has all the enterprise server features so that we can use all features to test with ease. Below is the link for the download from IBM official site, it will ask for username and password if your are not having one just register with them, login and download the software.

https://www14.software.ibm.com/webapp/download/preconfig.jsp?id=2009-06-19+07%3A01%3A41.585238R&S_TACT=&S_CMP=

After downloading all 3 softwares now first Install Vmware software on your 64 bit Machine. Simple and easy, click on setup file just follow instructions needed to complete it.

Install Vmware workstation on your Windows 7 Machine and once done start Vmware workstation and create new virtual machine for installing Ubuntu 12.04 Desktop. Just follow instructions given in there to create new virtual machine, but if you are a newbie or have any doubts about installation just follow the below YouTube video to get it done.




Login to your new machine with the username and password given during the installation. Now you need to copy DB2 data server trail to your Ubuntu machine, to achieve we can't copy and paste from windows machine directly without having Vmware tools installed in Ubuntu.

For that now we install Vmware tools. Follow below instructions -

1) Goto VM tab in Vmware workstartion click on Install VMware tools....  

2) Window appears on your screen, copy the file VMwareTools-<verison>.tar.gz from the folder to terminal by just dragging the file into terminal, in terminal use command cp <file> .

3) use command sudo tar -xvf <file-name> to extract files into a directory 

4) change to directory cd <dir-name> there will be one perl file used for installation, use sudo perl <file-name.pl>  just hit enter in keyboard using all the default values given there it will take approximately 2 mins to install Vmware tools. Now we are good to use drag and drop from our Host Windows machine to Guest Ubuntu machine shutdown the Ubuntu machine, go to VM tab in Vmware workstation and click on Settings click on Options tab and see that Shared folders option enabled and Guest Isolation tick the 2 options Enable drag and drop, Enable copy and paste.

Note: Above lines mentioned in bold are commands and lines given in brackets    < > should be the filenames respective to your locations and files.

Till now we have installed Vmware workstation in Windows 7 Host machine, Ubuntu new virtual machine in VM, Vmware tools in Ubuntu for using drag and drop functionality into guest - Ubuntu. 

It would be long post if i continue so i would like to split this post into 2 posts, for this will be the end of first post.