Go to your db2 installer directory in your terminal. Example, cd /hom e/dy lan/ Desk top/ Linu xExp ress /exp Try the following command. sudo ./db2setup It is always recommended to run db2 installation in with a root authority.In Ubuntu, in order to run the root authority you will have to add the command sudo as prefix. You will probably get the following error:- ERROR: The required library file libaio.so.1 is not found on the system. Check the following web site for the up-to-date system requirements of IBM DB2 9.7 http ://w ww.i bm.c om/s oftw are/ data /db2 /udb /sys reqs .htm l http ://w ww.s oftw are. ibm. com/ data /db2 /lin ux/v alid ate Aborting the current installation ... Run installation with the option " -f sysreq" parameter to force the installation. Use the following command to resolve the issue. sudo apt-get install libaio-dev After that, you will need to run the command sudo ./db2setup again If you receive a blank GUI or the whole launchpad went grey , you will need to do the following: Go to System → Preferences → Apperance. Go to the Visual Effects tab in the Appearance Preferences tab. Select None and click close. Close your launchpad and run the command ./db2setup again. Now you should be able to view you launchpad. We will go through the installation process step by step here. After accepting the license agreement, you will reach the Select the Installation Type windows. For this tutorial we will select Custom installation. Next on the Select installation, response file creation and both window, select the option ' install DB2 Express on this computer and save my settings in response file. ' Next, you will be prompted to the ' Select the features to install ' window. You can choose to select the tools and features that you want here. However, in this tutorial we will keep everything as default. The following is the ' Select the languages to install '. You can choose the language that you want DB2 to have. For this tutorial, we will only choose English. On the ' Specify the location of DB2 Information Center ' window. Select On IBM Website. The next window, it will ask you whether dyou want to install IBM Tivoli System Automation. Select Do not Install SA MP . For this tutorial, we will not install the SA MP. You will still be able to run DB2 as per normal without this tool. In the next window, you will need to setup the DB2 Administration Server User (DAS user). The DAS user is one that will run the DAS that is required for DB2 tools such as DB2 Control Center, Configuration Assistant etc. This user will have the authority to start or stop the DAS. For this tutorial, we will keep all the name and group name as default which will create a new user(look at below). Create your own password for this user The following window, you will need to setup a DB2 instance. A DB2 instance is an environment that allows you to store your data and run DB2 applications. Select Create a DB2 instance. Next, you will need to setup for your instance user. In this tutorial we will keep everything as default which will create the new user for you (refer to the below image). Create your own password for this user. After that, you will need to create a fenced user. All the fenced user defined function and store procedure will run under this user. As usual, for this tutorial keep everything as default (refer to below) and create your own password. After, this you will need to create the DB2 tool catalog in the 'Prepare DB2 tools catalog. DB2 tools catalog is needed if you wish to run database backup and replication. As usual keep everything as default here (which will create everything new). The following window will prompt you to set up the notifications on the alert to the administrator when the database needs to be alerted. For this tutorial, we will not setup anything on this, so we will select 'Do not set up your DB2 server to send notifications at this time. Finally, at the end you will have the summary of the configuration you have made. Click install. The installation will take a while. In steps 14 and 15, we talked about the instance user. Each time you need to use the DB2 tools like Control Center or run a db2 command, you will need to login as the instance user in the terminal or the operating system. If you login in the Ubuntu as the instance user, you will see the DB2 GUI tools.
Dylan Cheong Ngee Shinn
Imported from developerWorks blogger. Originally written on Nov 8,2010