18. Installing DB2 Version 8.2 on systems that use .deb packages
Before proceeding, please ensure that you have read
Section 3 and Section 4.
These notes are based on a single-partition installation on
Ubuntu 5.04. As Ubuntu uses .deb packages, we use the alien
package conversion utility to convert and install the DB2 RPM packages directly.
18.1. Pre-installation notes
Ensure that you have installed alien:
sudo apt-get install alien |
If you want to run a multiple-partition environment, you will need to install the pdksh package.
18.2. Installation notes
The RPM packages supplied with the DB2 install CD contain dependency listings that cannot
be satisfied inside a Ubuntu environment, because Ubuntu does not use RPM as a native
packaging method. To overcome these dependencies, you need to modify the db2_install
script to ignore dependencies and force the installation of DB2 onto your system using alien.
Perform the following steps to modify the db2_install script
and install the product:
Open the ~/db2/linux/db2_install script in your text editor and modify the following lines
From:
( rpm -ivh ${INSTDEV?}/${pkg?}${RPMEXTN?} 2>&1; \
echo $? > ${TMPRC?} ) | tee -a ${DB2INSTLOG?} |
To:
( alien -dic ${INSTDEV?}/${pkg?}${RPMEXTN?} 2>&1; \
echo $? > ${TMPRC?} ) | tee -a ${DB2INSTLOG?} |
Issue the following command to begin installing DB2:
The DB2 installer prompts you to enter the keyword of the product you want to install.
for example, issuing the db2_install command for the DB2 UDB Express
Edition for Linux install displays the following screen:
Specify one or more of the following keywords,
separated by spaces, to install DB2 products.
Keyword Product Description
DB2.EXP DB2 UDB Express Edition for LINUX
Enter "help" to redisplay product names.
Enter "quit" to exit.
***********************************************************
DB2.EXP
|
The DB2 installer will now install many RPM packages into the
/opt/IBM/db2/V8.1/ directory.
18.3. Post-installation notes
Now that you have installed DB2, you need to create the groups, users,
DB2 Administration Server instance, and database instance for your database.
The following instructions create users and groups with the default names
used in the DB2 documentation (dasadm1, db2inst1, db2fenc1).
Create the required groups:
sudo groupadd -g 999 db2iadm1
sudo groupadd -g 998 db2fadm1
sudo groupadd -g 997 dasadm1
|
Create the required users and assign them to their corresponding groups:
sudo useradd -u 1004 -g db2iadm1 -m -d /home/db2inst1 db2inst1
sudo useradd -u 1003 -g db2fadm1 -m -d /home/db2fenc1 db2fenc1
sudo useradd -u 1002 -g dasadm1 -m -d /home/dasusr1 dasusr1
|
Create the DB2 Administration Server:
sudo /opt/IBM/db2/V8.1/instance/dascrt -u dasusr1 |
Create the DB2 database instance:
sudo /opt/IBM/db2/V8.1/instance/db2icrt -a server -u db2fenc1 db2inst1 |
18.3.1. Enabling remote connections
When you perform a manual install of DB2, the installer does not automatically
set up the communication protocols for your DB2 server. To enable connections to your
DB2 server from remote clients, perform the following steps:
Set the port on which DB2 should communicate. Ensure that you select a port that
is not blocked by a firewall or used by another service defined in the /etc/services file.
To set the communications port, update the DB2 database manager configuration variable
SVCENAME. For example, to set the communications port to 50055, issue the following command
as the instance user ("db2inst1", if you've been using the defaults):
db2 update dbm cfg using svcename 50055 |
Set the DB2 communications protocol registry variable to define the protocol
supported by the server. Typically the only protocol you would use is TCP/IP, so issue
the following command as the instance user ("db2inst1" if you've been using the defaults):
Restart the database instance to enable the settings to take effect.
You should now be able to catalog and connect to your DB2 server from a remote client.
18.3.2. Running the DB2 Control Center and other DB2 GUI tools
To run the DB2 Control Center or other DB2 GUI tools, you must install the IBM
Software Developers' Kit for Java. This RPM is included in the DB2 install CD-ROM in
the /db2/linux/Java-1.4/ directory. To install the IBM Software Developers' Kit for
Java, change to the root directory of the CD-ROM and issue the following command:
sudo alien -dic db2/linux/Java-1.4/IBMJava2-SDK-1.4.1-2.0.i386.rpm
|
Log in as the db2inst1 user and invoke the DB2 Control Center: