Tuesday, February 11, 2014

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

PART 2


Now drag and drop the downloaded copy of IBM DB2 Data server trail copy from your Windows machine to Ubuntu. Follow below instructions.

Always remember we are doing root installation, so remember to use sudo command / else login into root account and setup the db2


1) To extract zipped files to a directory use command                                                
tar -xvf v9.7_linuxx64_server.tar.gz       -
2) change to extracted directory use, list the files and you can now see 7 script files and 2 directories. Now we need to validate if all the prerequisites are met to continue installing DB2 in the machine.

use this command sh db2prereqcheck it will show you errors/warnings like below.

WARNING:
   The 32-bit library file libpam.so is not found on the system
ERROR:
The required library file libstdc++.so.5 is not found on the system.
ERROR:
The required library file libaio.so.1 is not found on the system.

To fix this errors, we need to download and install below packages. Use below commands

1) sudo apt-get install libpam0g:i386 
2) sudo apt-get install libstdc++5
3) sudo apt-get install libaio-dev


libpam.so.0 (32-bit) is required for DB2 database servers to run 32-bit non-SQL routines, use the command, libaio.so.1 is required for DB2 database servers using asynchronous I/O.
libstdc++.so.5 is required for DB2 database servers and clients.

After install all 3 packages above run the prereqcheck again and see if we are good. Following all the instructions above shall give you no errors and warnings during prereqcheck

Now run sh db2setup to start the actual installation, DB2 Launch pad will open.

From the DB2 Setup launchpad, you can view installation prerequisites and the release notes, or you can proceed directly to the installation. 

Click Install a Product and the Install a Product window displays the products available for installation.
If you have no existing DB2 database products installed on your computer, launch the installation by clicking Install New. Proceed through the installation following the DB2 Setup wizard prompts.

If you have at least one existing DB2 database product installed on your computer, you can:
1) Click Install New to create a new DB2 copy.
2) Click Work with Existing to update an existing DB2 copy, to add function to an existing DB2 copy, upgrade an existing DB2 Version 9.5 and Version 9.7 copy, or to install an add-on product.

After the installation completes, login into the instance user and enter db2 to enter into interactive mode. Now your are good to fly into db2 world....

db2inst1@test-machine:~$ db2
(c) Copyright IBM Corporation 1993,2007
Command Line Processor for DB2 Client 9.7.6
.....................................................................
.....................................................................

For more detailed help, refer to the Online Reference Manual.

db2 => 




No comments:

Post a Comment