Database failed to start. SQL1084C - Shared Memory Segments cannot be allocated. SQLSTATE=57019

Jim Orfanakos jim at orfanakos.com
Sun Jan 9 22:49:45 MET 2005


Yes - for whatever the reason the install script did not add those
parameters.  Once I added them - all is fine.

Thanks. 

-----Original Message-----
From: linux.general-bounces at listserv.sap.com
[mailto:linux.general-bounces at listserv.sap.com] On Behalf Of Boris Bialek
Sent: Sunday, January 09, 2005 3:00 PM
To: jim at orfanakos.com
Cc: linux.general at listserv.sap.com; linux.general-bounces at listserv.sap.com
Subject: Re: Database failed to start. SQL1084C - Shared Memory Segments
cannot be allocated. SQLSTATE=57019





you obviously have not set the paramter on your system for the kernel shared
memory segment sizes...

Please add the following lines to /etc/sysctl.conf

# Added for 32-bit DB2
kernel.sem=?250    256000     32    1024?
kernel.msgmni=1024
kernel.shmmax=4294967296
kernel.shmall=<amount of memory in bytes on the system> #end additions for
DB2

The following lines should be added in for a 64-bit system:
# Added for 64-bit DB2
kernel.sem=?250     256000    32    1024?
kernel.msgmni=1024
kernel.shmmax=<amount of memory in bytes on the machine>
kernel.shmall=<amount of memory in bytes on the machine> #end additions for
DB2


then run sysctl -p (normally RedHat is doing sysctl automatically after
reboot in RHEL - I am not sure if you need to add to rc.local for Fedora...

This should work.

Boris

PS: Normally those parameter gets automatically set but it can be that the
DB2 kit thinks some other application changed them and leaves the hands off
it.



Boris C. Bialek , Senior Manager,  DB2 Competitive Technologies (Email,
MSNMessenger and Sametime: bbialek at ca.ibm.com) IBM Toronto Lab, 8200 Warden
Avenue, Markham, L6G 1C7, Canada
Tel: +1 (905) 413 3078   Fax: + 1 (905) 413 4928  T/L: 969-3078
Cell: 905 716 7332        http://www.can.ibm.com/torontolab
Skype: borisbialek




                                                                           
             "Jim Orfanakos"                                               
             <jim at orfanakos.co                                             
             m>                                                         To 
             Sent by:                  <linux.general at listserv.sap.com>    
             linux.general-bou                                          cc 
             nces at listserv.sap                                             
             .com                                                  Subject 
                                       Database failed to start. SQL1084C  
                                       - Shared Memory Segments cannot     
             01/09/2005 11:03          be allocated. SQLSTATE=57019        
             AM                                                            
                                                                           
                                                                           
             Please respond to                                             
                    jim                                                    
                                                                           
                                                                           




I installed the NetWeaver 04 / Linux / MaxDB Technology Preview DVD without
any problems.


Now, after installing the NetWeaver 04 / Linux / DB2 Technology Preview DVD
from TechEd - I get the following error when trying to startsap:


Command:  startsap si4host


Database failed to start.  SQL1084C - Shared Memory Segments cannot be
allocated.  SQLSTATE=57019


I am running on a P4 1.4 GHZ, 1.5 GB RAM, Fedora Core 2


Has anyone else seen this problem?


Thanks. _______________________________________________
linux.general mailing list
linux.general at listserv.sap.com
http://listserv.sap.com/mailman/listinfo/linux.general




_______________________________________________
linux.general mailing list
linux.general at listserv.sap.com
http://listserv.sap.com/mailman/listinfo/linux.general



More information about the linux.general mailing list