db2_setup.sh

#!/bin/bash

#usage: db2_setup.sh <db2_username> <db2_password> <db2_dbname>

#setup DB2 on RHEL7.4
USER=$1
PASSWD=$2
DB=$3

#pre-reqs
yum update -y --exclude=WALinuxAgent
yum install -y gcc gcc-c++ libstdc++*.i686 numactl sg3_utils kernel-devel compat-libstdc++-33.i686 compat-libstdc++-33.x86_64 pam-devel.i686 pam-devel.x86_64

#mdadm
yum -y install mdadm
mdadm --create --verbose /dev/md0 --level=10 --raid-devices=4 /dev/sdc /dev/sdd /dev/sde /dev/sdf
mkdir /etc/mdadm
mdadm --detail --scan | sudo tee -a /etc/mdadm/mdadm.conf
mkfs.ext4 -F /dev/md0
mkdir /db2
mount /dev/md0 /db2/
echo '/dev/md0 /db2 ext4 defaults,nofail,discard 0 0' | sudo tee -a /etc/fstab

#download DB2 11.1 from blob storage
wget -nv https://iwm.dhe.ibm.com/sdfdl/v2/regs2/db2pmopn/db2_v111/Xa.2/Xb.XXa1DxLQqbbXkRPVV-WYnwCauduRMDo9X3Jrss38h4Q/Xc.db2_v111/v11.1_linuxx64_server_t.tar.gz/Xd./Xf.LPr.D1vk/Xg.9592889/Xi.swg-dm-db2trial/XY.regsrvs/XZ.1MmAeJ6FG2uTxSIexUR5Rwiz-E0/v11.1_linuxx64_server_t.tar.gz

tar -zxf v11.1_linuxx64_server_t.tar.gz -C /tmp/

#install db2 - approx. 10 minutes
/tmp/server_t/db2_install -b /db2/  -y -n -p SERVER

#open port
firewall-offline-cmd --zone=public --add-port=50000/tcp
firewall-offline-cmd --zone=public --add-port=9091/tcp
systemctl enable firewalld
systemctl restart firewalld

#create user 
adduser $USER
echo $PASSWD | sudo passwd $USER --stdin

#create instance
/db2/instance/db2icrt -u $USER $USER

#start instance as user
chmod +x /db2/adm/db2start
su - $USER -c "/db2/adm/db2start"

#create a database - approx 7 minutes
chown -R $USER /db2 
su - $USER -c "mkdir /db2/db; source ~/sqllib/db2profile; db2 create database $DB on /db2/db"