Question & Answer
What needs to be done in order to install DB2 as Maximo platform on AIX box.
Customers have asked questions about DB2 installation.
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).
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
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.
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.
17 June 2018