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.
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...
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
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.