Friday, 13 September 2024

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>


Wednesday, 11 September 2024

MQSI Commands

Create a note
  mqsicreatebroker INODE -i [user] -a [passord] -q QMGR 

 Delete a node
  mqsideletebroker INODE