1

I'm trying to create a sample database in first steps after installing db2 Express V10.5 I've looked at the answers provided below, but I'm not able to resolve my issue. How to grant rights for a user in DB2 Express? DB2 Express on Windows 7 - Disable security?

Here is the exact error message

Creating database "SAMPLE" on path "C:"...
  Attempt to create the database "SAMPLE" failed.
  SQL1092N  The requested command or operation failed because the user ID does
not have the authority to perform the requested command or operation.  User ID:
"I32129
  'db2sampl' processing complete.

I'm logging on to my computer with a username on a domain managed by my company. My username is actually i321290, not sure if that error is accurate or if its hitting some character limit. While I was installing db2 I created a username and password for db2admin which is in the PROD_EXPC.rsp file. The DB2ADMNS and DB2USERS groups are created in my local groups. I created local users db2admin, i321290, and I32129 and added each of them to the above groups. The user names aren't case sensitive. DOMAIN\db2admin and DOMAIN\I321290 are also members of these groups. I've run the following commands

db2set DB2_GRP_LOOKUP=local
db2stop
db2start

but still receive the same error.

closed as off-topic by Jack Douglas Feb 22 '15 at 21:55

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Too localized - this could be because your code has a typo, basic error, or is not relevant to most of our audience. Consider revising your question so that it appeals to a broader audience. As it stands, the question is unlikely to help other users (regarding typo questions, see this meta question for background)." – Jack Douglas
If this question can be reworded to fit the rules in the help center, please edit the question.

  • Check what is logged by the DB2 instance in the Windows event log (or in db2diag.log) at the time of the error. – mustaccio Dec 18 '14 at 13:16
0

I had the same problem and solved it by adding domain admin user into the local Administrators group on local computer (where I installed DB2 DB).

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