If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > DB2 on MAC OSX Problems

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 06-26-10, 15:10
ahmad3 ahmad3 is offline
Registered User
 
Join Date: Jun 2010
Posts: 5
Exclamation DB2 on MAC OSX Problems

Hello.
i just installed db2 on my mac. i have problem with starting the db2.
i installed DB2 V9.5.0.2 and Fix Pack 2.
i run $db2fs command with no problem but i cannot create sample database. when i do the $db2start i get this error

SQL1220N The database manager shared memory set cannot be allocated.

and when i try to create a new db by using this command

$sb2 create database test

i get this error

SQL1032N No start database manager command was issued. SQLSTATE=57019

and when i run $db2sampl i get

Starting the DB2 instance...
Creating database "SAMPLE"...
Attempt to create the database "SAMPLE" failed.
SQL1032N No start database manager command was issued. SQLSTATE=57019


'db2sampl' processing complete.


Please help me i am looking for a solution for a week now...
thanks...
Reply With Quote
  #2 (permalink)  
Old 06-26-10, 15:52
Marcus_A Marcus_A is offline
Registered User
 
Join Date: May 2003
Location: USA
Posts: 5,198
Are you are using DB2 Express-C? If so, you should get support for that on the DB2 Express-C community forum on the IBM website. There are some people who have used DB2 on Max OS who have posted on that forum.

I would aslo suggest that try the latest copy of DB2 Express-C which is 9.7.2.
__________________
M. A. Feldman
IBM Certified DBA on DB2 for Linux, UNIX, and Windows
IBM Certified DBA on DB2 for z/OS and OS/390
Reply With Quote
  #3 (permalink)  
Old 06-26-10, 23:09
db2girl db2girl is offline
∞∞∞∞∞∞
 
Join Date: Aug 2008
Location: Toronto, Canada
Posts: 1,816
Try updating instance_memory dbm cfg to automatic
Reply With Quote
  #4 (permalink)  
Old 06-26-10, 23:53
ahmad3 ahmad3 is offline
Registered User
 
Join Date: Jun 2010
Posts: 5
Quote:
Originally Posted by db2girl View Post
Try updating instance_memory dbm cfg to automatic
Hi...
How exactly i should change that instance_memory to auto?
Thanks
Reply With Quote
  #5 (permalink)  
Old 06-27-10, 06:34
db2girl db2girl is offline
∞∞∞∞∞∞
 
Join Date: Aug 2008
Location: Toronto, Canada
Posts: 1,816
from command line:
db2 update dbm cfg using instance_memory automatic
Reply With Quote
  #6 (permalink)  
Old 06-27-10, 07:38
ahmad3 ahmad3 is offline
Registered User
 
Join Date: Jun 2010
Posts: 5
Quote:
Originally Posted by db2girl View Post
from command line:
db2 update dbm cfg using instance_memory automatic
thanks... the command was successful, however still same problem
Reply With Quote
  #7 (permalink)  
Old 06-27-10, 08:40
db2girl db2girl is offline
∞∞∞∞∞∞
 
Join Date: Aug 2008
Location: Toronto, Canada
Posts: 1,816
Is DB2 on MAC OS similar to DB2 on Linux? In this case, verify that the kernel parameters are properly configured. If this doesn't help, execute:

db2diag -A
db2start

Attach db2diag.log here
Reply With Quote
  #8 (permalink)  
Old 06-28-10, 05:26
dr_te_z dr_te_z is offline
Registered User
 
Join Date: Jan 2009
Location: Zoetermeer, Holland
Posts: 555
Reply With Quote
  #9 (permalink)  
Old 06-28-10, 05:29
ahmad3 ahmad3 is offline
Registered User
 
Join Date: Jun 2010
Posts: 5
Quote:
Originally Posted by db2girl View Post
Is DB2 on MAC OS similar to DB2 on Linux? In this case, verify that the kernel parameters are properly configured. If this doesn't help, execute:

db2diag -A
db2start

Attach db2diag.log here
i use same commands in terminal as i used to use in Linux. So i guess so,i ve attached the log.zip file here...
Attached Files
File Type: zip log.zip (3.9 KB, 3 views)
Reply With Quote
  #10 (permalink)  
Old 06-28-10, 05:31
ahmad3 ahmad3 is offline
Registered User
 
Join Date: Jun 2010
Posts: 5
Quote:
Originally Posted by dr_te_z View Post
yeah twice... watching it again to see if i missed anything during installation...
Reply With Quote
  #11 (permalink)  
Old 06-28-10, 09:42
db2girl db2girl is offline
∞∞∞∞∞∞
 
Join Date: Aug 2008
Location: Toronto, Canada
Posts: 1,816
Verify how your kernel parameters are set using "ipcs -l". The video on channelDB2 is recommending setting shmmax to 1GB and shmall to some other value. Try making shmall the same as shmmax and reboot.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On