Tell me more ×
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.
up vote 1 down vote favorite

I'm experiencing some troubles with the execution of DB2 express c on Mac OSX 10.6 Snow Leopard.

I have installed the db system, creating two users, db2 and db2-user. The latter is the instance owner. I have sourced db2profile and the env variables seem to be set correctly.

Db2 starts successfully, but I'm not able to run db2sampl, the error is: 

Attempt to start DB2 instance failed.
SQL1019N  The node name "db2-user" specified in the command is not valid.

I have googled the error and it looks like I have to change the DB2INSTANCE variable, but I do not know what value should be.

share|improve this question
Did what I suggest work? – Chris Aldrich Jul 23 '12 at 14:07

1 Answer

up vote 1 down vote

You do not want to change DBINSTANCE. All that does is change what instance is the "main" one for your OS. And you only have one instance from what I understand (named db2 I believe). I'm betting this has more to do with permissions as you are attempting to run db2sampl, which I believe creates the sample database if I remember correctly. Instance owner should be able to run this without any issues.

If I were you, I would run db2sampl as instance owner and then perform your necessary GRANTs for db2-user once the database is there.

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.