Step by step DB2 installation on AIX server.

Answer

1) Please verify AIX version using following commands:

oslevel -s OS release

bootinfo -K 32 or 64 BIT

2) Get an appropriate installation software from Passport advantage

3) Follow the steps :

Login as ROOT

1) Create a temporary directory (temp) to hold the DB2 installer tar file and un-tarred files. (2-3 GB hard drive space).
mkdir temp

2) FTP DB2 file to the AIX box

3) Un-tar the DB2 installer file. (tar xvf ../v9fp2_aix_ese.tar).

4) Execute the command line installer. Type ./db2_install.
DB2 is installed in /opt/IBM/db2.

5)Create users and groups for use with DB2.

mkgroup id=999 db2iadm1.
mkgroup id=998 db2fadm1.
mkgroup id=997 dasadm1.
mkuser id=1004 pgrp=db2iadm1 groups=db2iadm1 home=/home/db2inst1 db2inst1.
mkuser id=1003 pgrp=db2fadm1 groups=db2fadm1 home=/home/db2fenc1 db2fenc1.
mkuser id=1002 pgrp=dasadm1 groups=dasadm1 home=/home/dasusr1 dasusr1.
Verify the owner of the directories. To do this, type ls -ld /home/db2inst1. The directory ownership should appear as follows:
/home/db2inst1 should show group db2iadm1 and user db2inst1
/home/db2fenc1 should show group db2fadm1 and user db2fenc1
/home/dasusr1 should show group dasadm1 and user dasusr1

6)Paswords management

passwd db2inst1 password, where password represents the password you want to use for the DB2 instance.
pwdadm -f NOCHECK db2inst1.
passwd db2fenc1password, where password represents the password you want to use for the fenced user.
pwdadm -f NOCHECK db2fenc1.
passwd dasusr1password, where password represents the password you want to use for the DB2 administration server (DAS) user.
pwdadm -f NOCHECK dasusr1.
chgroup users=db2inst1,root db2iadm1.


7) Create a DB2 Administrative Server (DAS). Type /opt/db2/V9.5/instance/dascrt -u dasusr1.

8) Create a DB2 instance:
Type /opt/db2/V9.5/instance/db2icrt -a server -u db2fenc1 db2inst1.

Login as db2inst1


9) Configure DB2 communication:

Edit /etc/services and verify or add the following line at the end of the file: db2c_db2inst1 50000/tcp
Type db2 update dbm cfg using svcename db2c_db2inst1.
Type db2set DB2COMM=tcpip.

10) Add the DB2 license:

Type cd /opt/IBM/db2/V9.5/adm.
Type ./db2licm -a <DB2 installer location>/db2/ese/disk1/db2/license/db2ese_o.lic, where <DB2 installer location> represents the directory where the DB2 installer is located (for example, /db2temp/install).

11) Restart DB2:

Type db2stop force.
Type db2 terminate.
Type db2start.

12) Test your DB2 instance:

Type . /home/db2inst1/sqllib/db2profile.
Type db2level . Information about the instance and DB2 is displayed.
Type db2 create db test to create a test database.
Type db2 list db directory to list information about all the databases created for this instance.
Type db2 connect to test user db2inst1 using <password>, where password represents the password you defined in step 6 for the DB2 instance.
Type db2 disconnect test.
Type db2 drop db test.