error when create sample database on db2 SQL1092N "USERID does not hav

I'm beginner working on db2 database .I face error when create sample database on db2

error as below :

Creating database "SAMPLE" on path "D:"...
  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:
"AELAZI
  'db2sampl' processing complete.

so why this error happen and how to solve it please

I make install to db2 on c drive as default setting without change any thing .

I get error when I try to install sample database on c and d drive .

I try to open DB2 command administrator and execute

db2set DB2_GRP_LOOKUP=LOCAL,TOKENLOCAL        
db2 update dbm cfg using sysadm_group DB2ADMNS
db2stop                                        
db2start

I try to create sample database again but issue still exist

so How to solve issue and why this issue happen ?

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

ahmed salah2y ago
CAN you show me please by more details if possible

this is first time i treat and handle db2 database
Sachin Singh2y ago
1. add my Windows userID to DBADMNS and DBUSRS group(Under computer management>local users and groups>groups).

2.execute "db2set DB2_GRP_LOOKUP=local" command in cmd.

3. open cmd and run "runas /noprofile /user:Administrator cmd"