DB2 on Ubuntu: The database manager shared memory set cannot be allocated

By | August 25, 2010

I’ve been trying to get DB2 Express-C working on Ubuntu but I get an error when trying to start DB2:

[text]
ashlux@SERVER:~/java/db2exc$ db2
(c) Copyright IBM Corporation 1993,2007
Command Line Processor for DB2 Client 9.7.2

db2 => db2start
SQL1220N The database manager shared memory set cannot be allocated.
[/text]

After some searching I discovered that the problem is probably shmmax being too low. A site on tuning Oracle which shows how to increase shmmax:

[text]
sudo -s "echo 2147483648 > /proc/sys/kernel/shmmax"
[/text]

DB2 successfully starts up now.

4 thoughts on “DB2 on Ubuntu: The database manager shared memory set cannot be allocated

Leave a Reply

Your email address will not be published. Required fields are marked *