SQL1092N "USER" does not have the authority to perform the requested command

The error "SQL1092N <USER> does not have the authority to perform the requested command" usually comes when a domain user tries to perform a database operation that requires administrative privileges.

To resolve this, perform below steps (Windows OS):-

1. Execute "db2set DB2_GRP_LOOKUP=LOCAL" from db2 command editor
2. Create a new group called DB2ADMNS (Right click My Computer -> Manage -> Computer Management ->  System Tools -> Local Users and Groups -> Groups
3. Add the domain user to the DB2ADMNS group
4. Execute "db2 update dbm cfg using sysadm_group DB2ADMNS" from db2 command editor
5. Execute "db2stop"
6. Execute "db2start"