DB2 Troubleshooting

 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: 

• Add the domain user ID to the local group DB2ADMNS.

• Open the DB2 command window - Administrator and run the following commands from the prompt:

            db2 update dbm cfg using sysadm_group DB2ADMNS
            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

            db2cmd -i -w db2clpsetcp

            db2set DB2_GRP_LOOKUP=LOCAL      

            runas /noprofile /user:db2admin cmd

            Enter the password for db2admin: <Enter the password>