Results 1 to 11 of 11
  1. #1
    Join Date
    Jun 2010
    Posts
    5

    Exclamation Unanswered: 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...

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    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

  3. #3
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,369
    Try updating instance_memory dbm cfg to automatic

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

  5. #5
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,369
    from command line:
    db2 update dbm cfg using instance_memory automatic

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

  7. #7
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,369
    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

  8. #8
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746

  9. #9
    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 Attached Files

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

  11. #11
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,369
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •