Installing DB2 9.5 x64 on Ubuntu 9.10... um on second thought 9.04
- Published:
- categories: ibm
- tags: ibm, db2, linux, automation, installation
Ok so I posted some steps to get DB2 installed and working on 8.10 a few years ago now… so I am trying to migrate to the current milenium and bring my Ubuntu and DB2 versions up to speed to boot.
This one is making me pull my hair out though…. namely because of some confusion on how dynamic load libraries work in Linux and my inability to figure it out on my own. So the rub is that libstdc++5 has been removed from Karmic because the community no longer wants to support it, it breaks some new stuff they want to add but some old stuff breaks without it. It’s a trade off, these are made with lots of packages in every release, but like every other winey baby on the Ubuntu forums I don’t care until I care, and you can read the list of complaints here if you want to, although at some level I know these are the same people yelling at their son/daughters volunteer peewee soccer ref, needless to say I don’t think too highly of some of these complainers.
Here are the v8.1 instructions I am working off of. :)
http://blog.chinaunix.net/u/7282/showart_473461.html
Install
sgw@db02:/opt/ibm/db2/V9.5/adm$ sudo ./db2licm -a /home/sgw/db2ese_u.lic
[sudo] password for sgw:
LIC1402I License added successfully.
LIC1426I This product is now licensed for use as outlined in your License Agreement. USE OF THE PRODUCT CONSTITUTES ACCEPTANCE OF THE TERMS OF THE IBM LICENSE AGREEMENT, LOCATED IN THE FOLLOWING DIRECTORY: "/opt/ibm/db2/V9.5/license/en_US.iso88591"
sgw@db02:/opt/ibm/db2/V9.5/adm$
Create Users
sgw@db02:~$ sudo useradd -m db2inst1
[sudo] password for sgw:
sgw@db02:~$ sudo passwd db2inst1
Enter new UNIX password:
Retype new UNIX password:
passwd: password updated successfully
sgw@db02:~$ sudo useradd -m db2fenc1
sgw@db02:~$ sudo passwd db2fenc1
Enter new UNIX password:
Retype new UNIX password:
passwd: password updated successfully
sgw@db02:~$ sudo passwd db2das1
passwd: unknown user db2das1
sgw@db02:~$ sudo useradd -m db2das1
sgw@db02:~$ sudo passwd db2das1
Enter new UNIX password:
Retype new UNIX password:
passwd: password updated successfully
Create Instance
sgw@db02:/opt/ibm/db2/V9.5$ sudo ./instance/dascrt -u db2das1
SQL4406W The DB2 Administration Server was started successfully.
DBI1070I Program dascrt completed successfully.
sgw@db02:/opt/ibm/db2/V9.5$ ls /home/db2das1/
das
sgw@db02:/opt/ibm/db2/V9.5$ ls /home/db2das1/
das
sgw@db02:/opt/ibm/db2/V9.5$ sudo ./instance/db2icrt -a server -u db2fenc1 db2inst1