Failure Creating a Database in DB2
Error: 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: ""
Resolution:
db2stop
db2start
Resolution:
- Add the domain user ID to the local group DB2ADMNS.
- Open the DB2 command window - Administrator and run the following commands from the prompt:
db2stop
db2start
- Use the runas command to run as db2admin user so as to be able to create database
- Run the following command to set the DB2 command line (DB2CLP) variable
db2set DB2_GRP_LOOKUP=LOCAL
runas /noprofile /user:db2admin cmd
Enter the password for db2admin: <Enter the password>