Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I installed DB2 Express-C 10.1 on OS X 10.8.4. I installed it in user mode, and it seems to have created an instance with my username (avernet). I checked the instance is indeed there by running db2ilist. The database manager is running, as when I run db2start, I get the message SQL1026N The database manager is already active.

Now, I am trying to create a database by running db2 from the command line, and typing the command create database orbeon, but it returns:

QL1042C  An unexpected system error occurred.  SQLSTATE=58004

What am I missing here? How can I create a simple database from the command line (I prefer not to bother with Data Studio as it isn't available for OS X)?

In db2dump/db2diag.log, I see the follwing error (full file, in case you're interested):

2013-06-29-15.31.38.948217-420 E159047E344          LEVEL: Error (OS)
PID     : 1766                 TID : 140735175762304PROC : db2star2
INSTANCE: avernet              NODE : 000
HOSTNAME: huashan.local
FUNCTION: DB2 UDB, SQO Memory Management, sqloMemCreateSingleSegment, probe:100
CALLED  : OS, -, shmget                           OSERR: 17

Note that for the install to go through, I increased the OS X shared memory, per this recommendation.

share|improve this question
1  
Check the file db2diag.log -- it will be in $INSTANCE_HOME/sqllib/db2dump. It will contain details about the error. –  mustaccio Jul 3 '13 at 17:42
    
@mustaccio I did, and see one error there, which I copied and put in the question. Does that ring a bell? –  avernet Jul 3 '13 at 20:22
    
I'm afraid that's too small a fragment to be useful. How much memory have you got on your Mac? And why did you choose a non-root installation? It has all sorts of limitations. –  mustaccio Jul 3 '13 at 20:37
    
Does that error timestamp match the time you tried to issue your command? –  Chris Aldrich Jul 4 '13 at 20:59
2  
Try creating your database in a different directory: db2 create db orbeon on /datadir dbpath on /dbdir, where /datadir and /dbdir are directories where whoever runs the db2sysc process has full access. –  mustaccio Jul 5 '13 at 19:25

1 Answer 1

up vote 2 down vote accepted

Try creating your database in a different directory: db2 create db orbeon on /datadir dbpath on /dbdir, where /datadir and /dbdir are directories where whoever runs the db2sysc process has full access.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.