Post
Ask Question
ahmed salah

ahmed salah

  • 1.2k
  • 547
  • 65.2k

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

Oct 4 2023 1:24 PM

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 ?


Answers (2)