DB2 installation - Revision history

Kir: use the new settings

2010-09-20T07:49:15Z

use the new settings

MaxZinal: /* Set VE resource limits appropriately */

2010-09-20T05:57:09Z

‎Set VE resource limits appropriately

MaxZinal: /* Set VE resource limits appropriately */

2010-09-20T05:53:29Z

‎Set VE resource limits appropriately

Kir: warn about UBC inconsistency

2007-10-05T12:35:34Z

warn about UBC inconsistency

Kir: /* Create a new VE */ linked to debian template creation

2007-10-05T12:29:49Z

‎Create a new VE: linked to debian template creation

Elronxenu: Call it a VE consistently

2007-09-06T14:47:22Z

Call it a VE consistently

Elronxenu: Fixed grant command

2007-09-06T14:45:09Z

Fixed grant command

Elronxenu: Last one.

2007-09-06T08:43:53Z

Last one.

Elronxenu: Tidy it up a little now

2007-09-06T08:42:12Z

Tidy it up a little now

Elronxenu: How to get DB2 Express-C going in a Virtual Environment

2007-09-06T08:40:14Z

How to get DB2 Express-C going in a Virtual Environment

New page

DB2 has been certified by IBM for use inside Virtuozzo. It works in OpenVZ too!

IBM provides a free download of DB2 Express-C which is what I
installed.

Here is a rough guide to installing DB2 into a freshly-created VE.

== Create a new VE ==

I created a new VE for the Debian distribution using debootstrap.

== Set VE resource limits appropriately ==

DB2 installation can fail and it will not be possible to operate the database if your resource limits are too low. I used these limits for a small database:

* kmemsize to 10,000,000
* privvmpages to 300,000
* shmpages to 80,000
* numproc to 150
* tcpsndbuf to 700,000
* tcprcvbuf to 700,000
* diskspace to 6,000,000

== Install additional packages ==

* libstdc++5 (required for installation)
* pdksh (required for operation?)
* ssh (may be required for operation)
* xbase-clients (for xauth)
* firefox (for post-installation)
* strace and telnet (for debugging)
* libdbi-perl gcc libc6-dev make (for building CPAN DBD::DB2 package)

== Download the DB2 Express-C package ==

DB2 Express-C version 9 is available from this page:
[[http://www-306.ibm.com/software/data/db2/express/download.html]]

You will need to register with IBM before you can download.

* Untar the received file as root
* Run exp/disk1/db2setup
* Follow the prompts:
* Setup user 'dasusr1'
* Setup user 'db2inst1' and database instance 'db2inst1'

== Post-install actions ==

This is where it gets yukky. DB2 wants to run a browser inside the VPS. It wants to run Java applets inside the browser. I installed Iceweasel, but the post-install script does not recognise it. I was eventually able to hack the script to recognise and use the browser but it crashed on one of the Java applets. I think you can get by without running the post-install.

Here's what to do instead:

First, su to the instance owner:

* su - db2inst1

Try starting and stopping the database:

* db2start
* db2stop

If these don't work it means your environment variables are not set properly. IBM set these for me:

* CLASSPATH=/home/db2inst1/sqllib/java/db2java.zip:/home/db2inst1/sqllib/java/db2jcc.jar:/home/db2inst1/sqllib/java/sqlj.zip:/home/db2inst1/sqllib/function:/home/db2inst1/sqllib/java/db2jcc_license_cu.jar:.
* DB2INSTANCE=db2inst1
* PATH=/usr/local/bin:/usr/bin:/bin:/usr/games:/home/db2inst1/sqllib/bin:/home/db2inst1/sqllib/adm:/home/db2inst1/sqllib/misc

Try creating IBM's sample database:

* db2sampl

== Setup a development environment ==

I develop in perl so I was most interested in access to the database though the DBI library. I did this:

* Use CPAN to download and install DBD::DB2

If you don't use CPAN you can also do this (as root):

* Download http://search.cpan.org/CPAN/authors/id/I/IB/IBMTORDB2/DBD-DB2-1.1.tar.gz
* Untar the file and change into the directory
* perl Makefile.PL PREFIX=/usr
* make
* make test
* make install

== Setup DB2 for autostart ==

It seems that DB2 can be auto-started at VE boot time, but not auto-stopped. I used this script:

#!/bin/sh
#
# Script to start DB2 instances on bootup.
#

set -e

. /lib/lsb/init-functions

case "$1" in
start)
echo Starting DB2
/opt/ibm/db2/V9.1/instance/db2istrt
;;
stop)
;;
restart|reload)
;;
esac

exit 0

And I used this command to create the symlink to make it start at VE "boot" time:

* update-rc.d db2 start 95 2 .

== Testing your installation ==

From the db2inst1 user, do:

* db2

Inside the db2 client, try:

* connect to sample
* grant all privileges to user fred (?not sure?)
* connect reset

@@ Line 12: / Line 12: @@
 == Set VE resource limits appropriately ==
-DB2 installation can fail and it will not be possible to operate the database if your resource limits are too low. I used these limits for a small database:
+These are tested resource limits for x86-64 system running Debian/GNU Linux 5.0.6:
 * kmemsize to 26214400:29491200

@@ Line 34: / Line 34: @@
 * vmguardpages to 2097152:unlimited
 * oomguardpages to 26112:unlimited
 == Install additional packages ==

← Older revision		Revision as of 05:53, 20 September 2010
Line 23:		Line 23:

	{{Inconsistent UBC warning}}		{{Inconsistent UBC warning}}
		+
		+	These are tested resource limits for x86-64 system running Debian/GNU Linux 5.0.6 (the settings above did not work very well):
		+
		+	* kmemsize to 26214400:29491200
		+	* privvmpages to 2097152:unlimited
		+	* shmpages to 1572864
		+	* numproc to 400
		+	* tcpsndbuf to 1720320:2703360
		+	* tcprcvbuf to 1720320:2703360
		+	* vmguardpages to 2097152:unlimited
		+	* oomguardpages to 26112:unlimited

	== Install additional packages ==		== Install additional packages ==

← Older revision		Revision as of 08:43, 6 September 2007
Line 126:		Line 126:
	grant all privileges to user fred (?not sure?)		grant all privileges to user fred (?not sure?)
	connect reset		connect reset
		+
		+	== Enjoy! ==
		+
		+	Please provide feedback in the discussion (Talk) page about improvements to this HOWTO.

@@ Line 21: / Line 21: @@
 * tcprcvbuf to 700,000
 * diskspace to 6,000,000
 == Install additional packages ==
@@ Line 130: / Line 132: @@
 Please provide feedback in the discussion (Talk) page about improvements to this HOWTO.

@@ Line 8: / Line 8: @@
 == Create a new VE ==
-I created a new VE for the Debian distribution using debootstrap.
+I created a new VE for the Debian distribution using debootstrap, as described in [[Debian template creation]].
 == Set VE resource limits appropriately ==

@@ Line 47: / Line 47: @@
 == Post-install actions ==
-This is where it gets yukky. DB2 wants to run a browser inside the VPS. It wants to run Java applets inside the browser. I installed Iceweasel, but the post-install script does not recognise it. I was eventually able to hack the script to recognise and use the browser but it crashed on one of the Java applets. I think you can get by without running the post-install.
+This is where it gets yukky. DB2 wants to run a browser inside the VE. It wants to run Java applets inside the browser. I installed Iceweasel, but the post-install script does not recognise it. I was eventually able to hack the script to recognise and use the browser but it crashed on one of the Java applets. I think you can get by without running the post-install.
 Here's what to do instead:

@@ Line 124: / Line 124: @@
   connect to sample
-  grant all privileges to user fred (?not sure?)
+  grant dbadm on database to user fred
   connect reset

@@ Line 42: / Line 42: @@
 * Run exp/disk1/db2setup
 * Follow the prompts:
-   * Setup user 'dasusr1'
+** Setup user 'dasusr1'
-   * Setup user 'db2inst1' and database instance 'db2inst1'
+** Setup user 'db2inst1' and database instance 'db2inst1'
 == Post-install actions ==
@@ Line 62: / Line 62: @@
 If these don't work it means your environment variables are not set properly. IBM set these for me:
-* CLASSPATH=/home/db2inst1/sqllib/java/db2java.zip:/home/db2inst1/sqllib/java/db2jcc.jar:/home/db2inst1/sqllib/java/sqlj.zip:/home/db2inst1/sqllib/function:/home/db2inst1/sqllib/java/db2jcc_license_cu.jar:.
+ CLASSPATH=/home/db2inst1/sqllib/java/db2java.zip:/home/db2inst1/sqllib/java/db2jcc.jar:/home/db2inst1/sqllib/java/sqlj.zip:/home/db2inst1/sqllib/function:/home/db2inst1/sqllib/java/db2jcc_license_cu.jar:.
-* DB2INSTANCE=db2inst1
+ DB2INSTANCE=db2inst1
-* PATH=/usr/local/bin:/usr/bin:/bin:/usr/games:/home/db2inst1/sqllib/bin:/home/db2inst1/sqllib/adm:/home/db2inst1/sqllib/misc
+ PATH=/usr/local/bin:/usr/bin:/bin:/usr/games:/home/db2inst1/sqllib/bin:/home/db2inst1/sqllib/adm:/home/db2inst1/sqllib/misc
 Try creating IBM's sample database:
@@ Line 108: / Line 108: @@
           ;;
   esac
-−
   exit 0
 And I used this command to create the symlink to make it start at VE "boot" time:
-* update-rc.d db2 start 95 2 .
+ update-rc.d db2 start 95 2 .
 == Testing your installation ==
@@ Line 123: / Line 123: @@
 Inside the db2 client, try:
-* connect to sample
+ connect to sample
-* grant all privileges to user fred (?not sure?)
+ grant all privileges to user fred (?not sure?)
-* connect reset
+ connect reset