DB2 on Ubuntu: The database manager shared memory set cannot be allocated
Posted in Uncategorized on 08/25/2010 11:33 am by ashluxI’ve been trying to get DB2 Express-C working on Ubuntu but I get an error when trying to start DB2:
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.
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:
sudo -s "echo 2147483648 > /proc/sys/kernel/shmmax"
DB2 successfully starts up now.
08/26/2010 at 3:28 PM
If this doesn’t work (it didn’t for me as shmmax was already at the max
possible), try this:
http://www-01.ibm.com/support/docview.wss?rs=0&q1=SQL1220N&uid=swg21217932&loc=en_US&cs=utf-8&cc=us&lang=all
from
https://www.ibm.com/developerworks/forums/thread.jspa?messageID=14515257�
worked perfectly
Edit: Fixed link – Ash
08/26/2010 at 4:50 PM
Yah there are quite a few reasons that you could get this error. Thanks anthalamus.
09/04/2010 at 1:29 AM
It solved the problem in a step.. good post
09/07/2010 at 10:46 AM
+1 It’s work. Run db2start script successfully.